DB2 UDB's High-Function Business Intelligence in e-business
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,...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | 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. |
|---|