Building on the business intelligence (BI) framework and capabilities that are outlined in
This book is organized in two parts. The first part provides an overview of data warehouse infrastructure and DB2 Warehouse, and outlines the planning and design process for building your data warehouse. The second part covers the major technologies that are available in DB2 10 for Linux, UNIX, and Windows, function that helps you get the most value and performance from your data warehouse. These technologies include database partitioning, intrapartition parallelism, compression, multidimensional clustering, range (table) partitioning, data movement utilities, database monitoring interfaces, infrastructures for high availability, DB2 workload management, data mining, and relational OLAP capabilities. A chapter on BLU Acceleration gives you all of the details about this exciting DB2 10.5 innovation that simplifies and speeds up reporting and analytics. Easy to set up and self-optimizing, BLU Acceleration eliminates the need for indexes, aggregates, or time-consuming database tuning to achieve top performance and storage efficiency. No SQL or schema changes are required to take advantage of this breakthrough technology.
This book is primarily intended for use by IBM, IBM clients, and IBM business partners.
Table of contents
Part 1. Overview
Chapter 1. Gaining business insight with DB2
Chapter 2. Technical overview of DB2 Warehouse
Chapter 3. Warehouse development lifecycle
Part 2. Technologies
Chapter 4. Column-organized data store with BLU Acceleration
Chapter 5. Row-based data store
Chapter 6. Data movement and transformation
Chapter 7. Monitoring
Chapter 8. High availability
Chapter 9. Workload management
Chapter 10. Mining and unstructured text analytics
Chapter 11. Providing the analytics
These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.
IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.