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

Chapter 1. Business Intelligence overview 11

򐂰 Database Management products:

– DB2 Universal Database integrated with DB2 Control Center, Data

Warehouse Center, DB2 OLAP Starter Kit, DB2 Connect, DB2 Extenders

for multimedia data, DB2 XML Extender, DB2 DataPropagator and

Net.Data.

– DB2 Everyplace, DB2 Query Patroller, DB2 Performance Monitor and DB2

Net Search Extender.

򐂰 Analytics:

– Analytic applications such as WebSphere Commerce Suite, WebSphere

Commerce Analyzer and WebSphere Site Analyzer.

– Analytic application development products such as DB2 Intelligent Miner

Scoring, DB2 Intelligent Miner for Data, DB2 Intelligent Miner for Text,

DB2 OLAP Server, DB2 OLAP Server Analyzer, DB2 Spatial Extender,

Query Management Facility and Visual Age for Java.

Please refer to the appropriate IBM product documentation for details about

these products.

1.2.1 BI and analytic enhancements in DB2 UDB

A number of features have been added to DB2 UDB over the years to enhance

the performance of BI and analytics, and thereby the scalability of the DB2 UDB

engine particularly in an e-business environment of voluminous data,

unpredictable workloads and rapidly changing business environments.

DB2 UDB BI and analytic performance features include SQL language

extensions such as VARIANCE, COVARIANCE, CORRELATION, regression,

ROLLUP and CUBE operators, support for large tables and bufferpools,

partitioning of large tables for parallel processing, inter-query and intra-query

parallel processing, materialized views for creating and refreshing summarized

data, cost-based optimizer with multiple join algorithms, star schema

optimization, index only access, index ANDing and ORing, caching of optimized

SQL statements for repeat queries, and query rewrite of inefficient queries.