®
SG24-6546-00 ISBN 0738424609
INTERNATIONAL
TECHNICAL
SUPPORT
ORGANIZATION
BUILDING TECHNICAL
INFORMATION BASED ON
PRACTICAL EXPERIENCE
IBM Redbooks are developed by
the IBM International Technical
Support Organization. Experts
from IBM, Customers and
Partners from around the world
create timely technical
information based on realistic
scenarios. Specific
recommendations are provided
to help you implement IT
solutions more effectively in
your environment.
For more information:
ibm.com/redbooks
DB2 UDB’s High-Function
Business Intelligence
in e-business
Exploit DB2’s
materialized views
(ASTs/MQTs)
Leverage DB2’s
statistics, analytic
and OLAP functions
Review sample
business scenarios
This IBM Redbook deals with exploiting DB2 UDB’s
materialized views (also known as ASTs/MQTs), statistics,
analytic, and OLAP functions in e-business applications to
achieve superior performance and scalability. This redbook is
aimed at a target audience of DB2 UDB application
developers, database administrators (DBAs), and independent
software vendors (ISVs).
We provide an overview of DB2 UDB’s materialized views
implementation, as well as guidelines for creating and tuning
them for optimal performance.
We introduce key statistics, analytic, and OLAP functions, and
describe their corresponding implementation in DB2 UDB with
usage examples.
Finally, we describe typical business level queries that can be
answered using DB2 UDB’s statistics, analytic, and OLAP
functions. These business queries are categorized by
industry, and describe the steps involved in resolving the
query, with sample SQL and visualization of results.
Back cover
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.