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

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.

Chapter 1. Business Intelligence overview
Chapter 2. DB2 UDB's materialized views
Chapter 3. DB2 UDB's statistics, analytic, and OLAP functions
Chapter 4. Statistics, analytic, OLAP functions in business scenarios
Appendix A. Introduction to statistics and analytic concepts
Appendix B. Tables used in the examples
Appendix C. Materialized view syntax elements

• WebSphere MQ V6 Fundamentals, SG24-7128-00
• IBM PowerVM Virtualization Managing and Monitoring, SG24-7590-01
• IBM Certification Study Guide eServer p5 and pSeries Administration and Support for AIX 5L Version 5.3, SG24-7199-00

Publish Date
17 September 2002

Last Update
24 September 2002

Rating: Not yet rated

Rate this book

Author(s)

Nagraj Alur is a Project Leader with the IBM International Technical Support Organization, San Jose Center. He has more than 28 years of experience in DBMSs, and has been a programmer, systems analyst, project leader, consultant, and researcher. His areas of expertise include DBMSs, data warehousing, distributed systems management, and database performance, as well as client/server and Internet computing. He has written extensively on these subjects and has taught classes and presented at conferences all around the world. Before joining the ITSO in November 2001, he was on a two-year assignment from the Software Group to the IBM Almaden Research Center, where he worked on Data Links solutions and an eSourcing prototype.

• Nagraj Alur

Peter Haas received a Ph.D. in Operations Research from Stanford University in 1986. He has been a Research Staff Member at the IBM Almaden Research Center since 1987, where a major focus of his work has has been the application of probabilistic and statistical techniques to database systems. He invented a number of methods used by the DB2 query optimizer to estimate query processing costs, as well as methods for estimation of catalog statistics that have been incorporated into the DB2 RUNSTATS utility. He was a principal implementor of the correlation analyis and linear regression functions in DB2 UDB, and helped provided similar functionality to the DB2 Warehouse Manager product. He also developed technology for interactive online processing of complex aggregation queries, and led an effort to develop a prototype "online aggregation" interface to DB2. This work earned him the IBM Research Division 1999 Best Paper Award and an Honorable Mention at the 1999 ACM SIGMOD conference. Recently, he has been leading an effort to provide sampling and estimation functionality in DB2, and is helping to develop the proposed ISO standard for sampling in SQL queries. He is a member of the Institute for Operations Research and Management Sciences and is currently an Associate Editor for the journal "Operations Research". Since 1999, he has been affiliated with the Department of Management Science and Engineering at Stanford University, where he teaches a course on computer simulation.

• Peter Haas

Daniela Momiroska is an IT Specialist from Macedonia, working in Business Innovation Services in The Netherlands. She worked in IBM for three years as an HR Access developer, and in the last two years as a WebSphere Commerce Suite developer. Daniela has developed on-line shops for different customers, and has extensive knowledge of Internet based products centered around the WebSphere family. She holds a degree in computer science from the university of Skopje, Macedonia.

• Daniela Momiroska

Paul Read is a Relational Database Specialist with 20 years of experience in application and system development and management. He is the lead EMEA technical professional for DB2 products on the INTEL platforms and Mobile platforms in the EMEA ATS PIC. He manages the beta and early support programs for DB2 UDB and Everyplace. He also provides technical consulting for the DB2 Brand software products across all platforms.

• Paul Read

Nicholas Summers is a Senior IT Specialist working in Atlanta, Georgia for the IBM Americas Techline organization. His current responsibilities include technical sales support on DB2, Data Management, and Business Intelligence Solutions. He has over 17 years experience in the IT environment as a manufacturing engineer, systems engineer, sales specialist and technical sales support specialist. He holds degrees in Chemistry and Chemical Engineering.

• Nicholas Summers
• Virginia Totanes
• Calisto Zuzarte

ISBN

0738424609

IBM Form Number
SG24-6546-00

Number of pages
270