My Cart
Bookstore Sign In
Books
Advertising
Art
Biographies & Memoirs
Business & Economics
Business & Investing
Cards, Greeting Cards, Card Decks
Children's
Constitution
Education
Entertainment
Family
Fitness & Nutrition Journals
Food & Wine
Grief & Bereavement
Health, Mind & Body
History
Literature & Fiction
Mathematics
Music
Reference
Religion & Spirituality
Self Help
Self-Improvement
Sports
CDs & DVDs
Constitution
Education
Food & Wine
Health, Mind & Body
Literature & Fiction
Music
Parenting & Families
Self-Improvement
Publishing Samples
Technical Manuals
Altova
IBM Redbooks
Juniper Networks
Menu
DB2 UDB's High-Function Business Intelligence in e-business
IBM Redbooks
ADD TO CART
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.
Price:
$50.00
$40.00
Pages:
280
Date Published:
September 24, 2002
ISBN:
0738424609
Author:
IBM Redbooks
Product Number:
SG24-6546-00
Ships in 3-5 days
ADD TO CART
X Close
Why Vervante?
© 2024 Vervante Corporation. All rights reserved.