Book description
Building on the business intelligence (BI) framework and capabilities that are outlined in InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence, SG24-7813, this IBM® Redbooks® publication focuses on the new business insight challenges that have arisen in the last few years and the new technologies in IBM DB2® 10 for Linux, UNIX, and Windows that provide powerful analytic capabilities to meet those challenges.
This book is organized in to 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. We focus on functions that help 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 employees, IBM clients, and IBM Business Partners.
Table of contents
- Front cover
- Notices
- Preface
- Part 1 Overview
- Chapter 1. Gaining business insight with IBM DB2
- Chapter 2. Technical overview of IBM 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
- 8.1 IBM PureData System for Operational Analytics
- 8.2 Core warehouse availability
- 8.3 Management host availability
-
8.4 High availability management
- 8.4.1 High availability toolkit
- 8.4.2 Starting and stopping resources with the HA toolkit
- 8.4.3 Monitoring the status of the core warehouse HA configuration
- 8.4.4 Monitoring the status of the management host HA configuration
- 8.4.5 Moving database partition resources to the standby node as a planned failover
- 8.4.6 Moving resources to the standby management host as a planned failover
- Chapter 9. Workload management
- Chapter 10. Mining and unstructured text analytics
- Chapter 11. Providing the analytics
- Related publications
- Back cover
Product information
- Title: Leveraging DB2 10 for High Performance of Your Data Warehouse
- Author(s):
- Release date: January 2014
- Publisher(s): IBM Redbooks
- ISBN: 9780738438979
You might also like
book
IBM Information Server: Integration and Governance for Emerging Data Warehouse Demands
This IBM® Redbooks® publication is intended for business leaders and IT architects who are responsible for …
book
DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition
DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering …
book
SQL Procedures, Triggers, and Functions on IBM DB2 for i
Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), …
book
Cataloging Unstructured Data in IBM Watson Knowledge Catalog with IBM Spectrum Discover
This IBM® Redpaper publication explains how IBM Spectrum® Discover integrates with the IBM Watson® Knowledge Catalog …