Synopses & Reviews
"This book not only describes the intricacies of various IBM products, such as IBM DB2, IBM Intelligent Miner, and IBM DB2 OLAP, but it also sets the context by providing a comprehensive overview of data warehousing architecture, analytics, and data management."
-Wayne Eckerson, Director of Research, The Data Warehousing Institute
In IBM Data Warehousing, Michael Gonzales shows how to exploit IBM technologies to get the most from your data warehousing investment. These technologies include everything from SMP and MPP technical architectures to DB2 Universal Database and DB2 OLAP Server. The author provides an in-depth look at the fundamentals of business intelligence (BI), the BI architecture, data management, and enhanced analytics. In addition, he presents expert tips, tricks, and workarounds to ensure maximum performance of your IBM data warehouse.
This book covers the suite of IBM products necessary for determining your warehousing needs and building your BI environment. Key topics include:
* Features of DB2 that support business intelligence and data warehousing efforts
* IBM technologies that facilitate the management of your warehouse
* OLAP, data mining, spatial analysis and meta data as it relates to IBM technology
* Project management techniques for prioritizing business intelligence iterations and reducing risks
* Choosing the right data warehousing architecture for your business needs
The companion Web site contains links to vendors, technical notes, and other reference material for the products mentioned in the book.
Synopsis
- IBM is a leading vendor of integrated technology for data warehouse applications
- Offers a single resource that describes the applicability and cohesiveness of the entire IBM warehouse-centric suite of products
- Explains planning and designing architecture, as well as implementing, maintaining, and growing the data warehouse
- Companion Web site includes technical notes, product updates, corrections and updates to the text, as well as links to relevant resources
Synopsis
- Reviews planning and designing architecture and implementing the data warehouse.
- Includes discussions on how and why to apply IBM tools.
- Offers tips, tricks, and workarounds to ensure maximum performance.
- Companion Web site includes technical notes, product updates, corrections, and links to relevant material and training.
About the Author
MICHAEL L. GONZALES is President of The Focus Group, Ltd., where he guides organizations from the initial development phase of a data warehouse project to full imple-mentation. He has written for publications including Intelligent Enterprise and DB2 Magazine, is a frequent speaker at industry user conferences, and conducts data warehouse courses internationally.
Table of Contents
Acknowledgments.
Introduction.
PART ONE: FUNDAMENTALS OF BUSINESS INTELLIGENCE AND THE DATA WAREHOUSE.
Chapter 1. Overview of the BI Organization.
Chapter 2. Business Intelligence Fundamentals.
Chapter 3. Planning Data Warehouse Iterations.
PART TWO: BUSINESS INTELLIGENCE ARCHITECTURE.
Chapter 4. Designing the Data Architecture.
Chapter 5. Technical Architecture and Data Management Foundations.
PART THREE: DATA MANAGEMENT.
Chapter 6. DB2 BI Fundamentals.
Chapter 7. DB2 Materialized Query Tables.
PART FOUR: WAREHOUSE MANAGEMENT.
Chapter 8. Warehouse Management with IBM DB2 Data Warehouse Center.
Chapter 9. Data Transformation with IBM DB2 Data Warehouse Center.
Chapter 10. Meta Data and the IBM DB2 Warehouse Manager.
PART FIVE: OLAP AND IBM.
Chapter 11. Multidimensional Data with DB2 OLAP Server.
Chapter 12. OLAP with IBM DB2 Data Warehouse Center.
Chapter 13. DB2 OLAP Functions.
PART SIX: ENHANCED ANALYTICS.
Chapter 14. Data Mining with Intelligent Miner.
Chapter 15. DB2-Enhanced BI Features and Functions.
Chapter 16. Blending Spatial Data into the Warehouse.
Bibliography.
Index.