(Lewis R Cunningham) A reader recently asked: Hi, We are using Oracle eBS and 9i (XML DB not installed), and need to generate XSDs from the client site using SQLPlus. DTDs are currently generated from the client: the SQLPlus script calls a database package that creates a bunch of DTDs from a t
Author: SSWUG Research
Making the Case for an Enterprise-Wide BI and DW Capability
(Robert Farris) This column explores the major challenges companies face and suggests actions to build an effective business intelligence (BI) and data warehouse (DW) capability and its primary drivers.
What Business Can Learn from Open Source
(Paul Graham) Lately companies have been paying more attention to open source. Ten years ago there seemed a real danger Microsoft would extend its monopoly to servers. It seems safe to say now that open source has prevented that. A recent survey found 52% of companies are replacing Windows servers w
Problem Determination for WebSphere for z/OS
(Rica Weller, Cleberson Calefi, Per Fremstad, Keith Jabcuga, Suresh Maddukuri, Kiet Nguyen, Robyn Nostalgi and Rajesh Pericherls) WebSphere Application Server for z/OS V6.0 is a complex product made up of many components, similar to the human body. And, like the human body, WebSphere for z/OS can ex
A Quick Exploration of the Atlas UpdatePanel control
(Brett Burch) I’ve been messing around with Atlas a bit and think the Update Panel server control is what I’m looking forward to most. This article is a brief introduction to the Update Panel control, and only touches the most basic aspects of the Update Panel and Atlas.
Beefing up SQL Server 2005 Express Edition
(Arthur Fuller) SQL Server 2005 Express Edition is a freely available version of SQL Server that is included in several Microsoft products. However, the version bundled in offerings such as Visual Studio 2005 lacks a critical component: Management Studio (which is the equivalent of Enterprise Manage
Divide functionality into manageable pieces with .NET 2.0’s partial classes
The list of enhancements and new features available in .NET 2.0 can be a bit overwhelming. My method has been to wait to dig into the details of the various features until a project calls for it. However, you can use one of the new features, partial classes, throughout your project.
Storing Images in the Database, the Scottish User Group and Mod PL/SQL
(Sue Harper) Yesterday I had an earlier than usual start. I was off to Scotland for the Scottish User Group SIG and had planned to fly up and back in the day. This is easy. The early bit is because I have a mutt (said mutt) and I take him for a walk every day, rain or snow. I am […]
Refactoring MySQL to Support Materialized Views
(Steve Hanov, Andrew Roth and Hobbe Smit) In this paper, we try to determine the refactoring necessary to implement a new feature in MySQL, a popular open source database system. The first step is to obtain the conceptual and concrete architectures. We find the conceptual architecture by examin
By Any Other Name
(Robert Catterall) Sometime in the mid-1990s, I was on an airplane still parked at the gate at DFW International Airport, when the person sitting next to me initiated a conversation by asking what I did for a living. I explained that I was part of IBM’s mainframe DB2 national technical support organ