Chapter 46. Data Warehousing with DB2

This Chapter

• Defining the Basic Terms

• Designing a Data Warehouse

• Populating a Data Warehouse

• Accessing the Data Warehouse

• Managing the Data Warehouse

• The Big Picture

• IBM Data Warehousing Solutions

• Materialized Query Tables

• General Data Warehouse Guidelines

• DB2-Specific Data Warehousing Guidelines

Data warehousing is not a particularly new idea. The basic idea behind data warehousing is one that has been performed by IT professionals throughout the years: enabling end users to have access to corporate operational data to follow and respond to business trends. You might be tempted, therefore, to shrug off data warehousing as another of the many industry buzzwords that rise and fall every ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial