DB2 UDB's High-Function Business Intelligence in e-business.

Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Notice -- Comments welcome -- Chapter 1. Business Intelligence overview -- 1.1 e-business drivers -- 1.1.1 Impact of e-business -- 1.1.2 Importance of BI -- 1.2 IBM's BI strategy and offerings -- 1.2.1 BI and analytic enhancements in DB2 UDB -- 1.2.2 Advantages of BI functionality in the database engine -- 1.3 Redbook focus -- 1.3.1 Materialized views -- 1.3.2 Statistics, analytic and OLAP functions -- Chapter 2. DB2 UDB's materialized views -- 2.1 Materialized view overview -- 2.1.1 Materialized view motivation -- 2.1.2 Materialized view concept overview -- 2.1.3 Materialized view usage considerations -- 2.1.4 Materialized view terminology -- 2.2 Materialized view CREATE considerations -- 2.2.1 Step 1: Create the materialized view -- 2.2.2 Step 2: Populate the materialized view -- 2.2.3 Step 3: Tune the materialized view -- 2.3 Materialized view maintenance considerations -- 2.3.1 Deferred refresh -- 2.3.2 Immediate refresh -- 2.4 Loading base tables (LOAD utility) -- 2.5 Materialized view ALTER considerations -- 2.6 Materialized view DROP considerations -- 2.7 Materialized view matching considerations -- 2.7.1 State considerations -- 2.7.2 Matching criteria considerations -- 2.7.3 Matching permitted -- 2.7.4 Matching inhibited -- 2.8 Materialized view design considerations -- 2.8.1 Step 1: Collect queries & prioritize -- 2.8.2 Step 2: Generalize local predicates to GROUP BY -- 2.8.3 Step 3: Create the materialized view -- 2.8.4 Step 4: Estimate materialized view size -- 2.8.5 Step 5: Verify query routes to "empty" the materialized view -- 2.8.6 Step 6: Consolidate materialized views -- 2.8.7 Step 7: Introduce cost issues into materialized view routing -- 2.8.8 Step 8: Estimate performance gains.