Actions for DB2 UDB's high function business intelligence in e-business

Email RIS file
Bookmark
Report an Issue

DB2 UDB's high function business intelligence in e-business / [Nagraj Alur and others].

Published
San Jose, Calif. : IBM Corp., 2002.
Edition
1st ed.
Physical Description
1 online resource (xxii, 252 pages) : illustrations
Additional Creators
Alur, Nagraj
Access Online

Availability

I Want It
I Want It

Finding items...

Series
Language Note
English.
Summary
This IBM Redbooks publication 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 book 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.
Subject(s)
ISBN
9780738424606
0738424609
Digital File Characteristics
data file
Bibliography Note
Includes bibliographical references and index.
View MARC record | catkey: 37418266