(Chuck Ballard, Angus Beaton, David Chiou, Janardhan Chodagam, Meridee Lowry, Andrew Perkins, Richard T. Phillips and John Rollins) In this redbook we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intellige

(Paul Zikopoulos) In a previous series of articles, I showed you the integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).

(Farzad Farahbod) The annotated XML schema decomposition feature introduced in DB2 9, can be used to decompose entire, or fragments of, XML documents into relational tables. DB2 9 XML shredding technology uses annotations in XML schema as the mapping language to map information in an XML document to

(Craig Mullins) No one working as a DB2 DBA or performance analyst would deny that one of the most important components of assuring efficient DB2 performance is making sure that DB2 access paths are appropriate for your DB2 programs. Binding programs with EXPLAIN(YES) specified is important to ensur

(Robert Brunner) With this article you’ve reached an important point in mastering fundamental database concepts as they relate to the Apache Derby database. This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information. Then it intr

(David Beulke) Walking down the street the other day, I found a $20 bill. Finding money (and, more commonly, finding ways to save it) never fails to please.

(Ueli Wahli, Majid Irani, Ana Negrello, Celio Palma and Jason Smith) This IBM Redbook is intended to help you design your processes and solutions using Rational products to manage compliance. It shows how Rational solutions can be applied by an organization to realize a controlled, auditable softwar

(Chris Eaton) In my last posting I posted a query to pivot rows into columns. In this posting I’ll show you how to do the reverse. That is, take a set of columns and convert them into a series of rows.

(Philip Howard) The march of the big guns into event processing continues. Microsoft, SAS and Sybase have all got point solutions that address this space in one way or another, while it may have escaped your notice that IBM has now got two offerings in this area.

(Suita Gupta, Allan Tham and Raul Chong) If you’re a database specialist interested in growing your DB2 9 skills, there’s a good chance that you’ve already developed database skills with another relational database product somewhere along the way. Recently updated for the latest versions of DB2 and