(Whei-Jen Chen) DB2 UDB V8.2, code name Stinger, is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements for Information management customers. This redbook is an update of “DB2 UDB Exploitation of the Windows Environment (S
Other News
Oracle9i Analytic SQL Features, Part 2
(Brad Cowdrey) This is a series of articles on the SQL analytic features of Oracle9i. At first glance, they seem foreign and overly complex; however, once the features are demystified, they become very powerful tools in the business intelligence and reporting environments. Part 2 explores aggregatio
Parsing XML documents with Perl’s XML::Simple
As more and more Web sites begin using XML for their content, it’s increasingly important for Web developers to know how to parse XML data and convert it into different formats. There used to be two ways of doing this: setting up callback handlers that get invoked when a particular element type is r
Display the PL/SQL Dependency Tree
(Casimir Saternos) As PL/SQL a code base for an application grows over time, the number of dependencies that exist can grow and become difficult to manage. This can be especially difficult for the DBA being called upon to support a legacy system that has had numerous independent developers contr
Designing your Application to Reap the Benefits of Lower Isolation Levels
(Derek Williams) In the Volume 10, Number 3 issue of IDUG Solutions Journal, John Lynch and Yong Ju Li described performance improvements that came from changing to a lower, uncommitted read (UR) isolation level. Their results were so dramatic, they referred to them as paradise found. These prom
Building with Oracle XML Database
(Magnús Kristjánsson) As a software development shop involved with XML technologies for several years, Theriak Software (formerly eMR) has witnessed firsthand the many recent improvements Oracle has made in these technologies. This article explores some of the techniques we used to successfully buil
IBM DB2 UDB and SteelEye LifeKeeper for Linux- A High Availability Database Solution
(Andy Beaton) This paper provides an introduction and sample configuration instructions for running IBM DB2 Universal Database (DB2 UDB) on a cluster of Linux servers, with high availability capabilities provided by SteelEye LifeKeeper for Linux. The purpose of high availability software is to p
PeopleSoft ties knot with IBM
(Martin LaMonica) PeopleSoft will develop its future business applications to work with IBM’s infrastructure software and programming tools, as part of a broad technology and marketing agreement between the two companies.
The SQL of OLAP
(Michael Gonzales) When considering online analytic processing (OLAP), architects often focus on issues such as which dimensions to include, what facts are relevant, how often to refresh the data contents, and so on. Among these issues, the OLAP language is often overlooked. And of all the OLAP-cent
BUG: Position() and Last() XPath Functions Are Ignored When You Use Them as XSLT Function Arguments
The position() and last() XPath functions are ignored when you use them directly as XSLT function (standard, script, and extension function) arguments in XPath query expressions that are used in XSLT style sheets.