In IBM Data Warehousing, Michael Gonzales shows how to exploit IBM technologies — including everything from SMP and MPP technical architectures to DB2 UDB and DB2 OLAP Server — to get the most from data warehouse investments.

By Paul McDougall – Companies gain more choices to help them build adaptive, real-time infrastructures.

IBM’s DB2 V8.1 for Linux provides new levels of information integration. DB2 UDB V8.1 marks the next stage in the evolution of relational database providing for new levels of information integration within your e-infrastructure. DB2 UDB V8.1 allows you to access any information, from any application

Poorly written SQL code can cause database slowdown. Marin Komadina explains how to collect and identify slow-running SQL statements.

Make sure that when you are evaluating the cost of an Oracle RAC solution, you include the software costs, not just the hardware cost differences. It’s likely that any potential difference in hardware costs will be overshadowed by the increased costs for the Oracle database and the additional Oracle

Book by George Reese – Unlike other books on this topic, which focus on a single way to do things, Java Database Best Practices takes you through a wide variety of different ways to store and access data, enabling you to learn which “persistence model” is most appropriate for each type of applicatio

Looking to stretch the most out of your investment dollars? DB2 UDB allows you to start with a minimum investment without sacrificing functionality. Unlike other databases, DB2’s entry level pricing doesn’t require you to sacrifice database functionality. IBM delivers the same core database function

By Timothy Dyck – Expand Beyond’s PocketDBA 2.0 provides database administrators with a lightweight, HTML-based administration console for on-the-move management. The previous version, 1.4, was an Oracle-only product, but PocketDBA 2.0 broadens users’ options by including modules for Microsof

By David Beulke – DB2 UDB version 8.1 for Linux, Unix, and Windows provides many built-in business intelligence (BI) features. Materialized query tables are one of the most interesting.

By Paul Zikopoulos – This tutorial introduces the basics of the DB2 products and tools, along with the concepts of data warehousing and OLAP. It is the first in a series of six tutorials designed to help you prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).