Chapter 1. Business Intelligence overview 13
Figure 1-5 Business Intelligence functionality
1.3.1 Materialized views
Materialized views provide a powerful look aside capability for the DB2 optimizer
to significantly improve the performance of complex and long running decision
support queries over voluminous data. In some cases, the improvement has
been in orders of magnitude!
The obvious challenges for the DBA are:
? Identifying the requirements for such materialized views
? Creating and maintaining them efficiently
? Dispensing with them when they are no longer necessary
These materialized view issues are covered in this book.
Data Warehouse
DSS
OLAP
MINING
ETML
IBM Intelligent Miner
SAS
etc
IBM/ESSBASE
Cognos
Microstrategy
Business Objects
Brio
etc
WebSphere Commerce Suite, Siebel, i2, Ariba, etc
Analytic Applications (SCM, CRM..)
Business Intelligence Functionality
Import from:
Legacy & External
Sources
DB2
DBMSs
Files
Web
ERP
etc
DB2DB2
IBM QMF
MS Access
IBM/ESRI
etc
Attention: Materialized views are known as Automatic Summary Tables
(AST), or Materialized Query Tables (MQT) in IBM product documentation.
We will use the more widely known term
materialized views to mean
ASTs/MQTs throughout this document.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset