Object-Oriented Data Warehouse Design: Building A Star Schema / Edition 1

Object-Oriented Data Warehouse Design: Building A Star Schema / Edition 1

by William A. Giovinazzo
     
 

ISBN-10: 0130850810

ISBN-13: 9780130850812

Pub. Date: 02/16/2000

Publisher: Prentice Hall

8508A-8

Design your data warehouse correctly from the start!

It is well-documented that most data warehouse projects fail. The #1 reason: poor data models or the failure of warehouse designers to apply a sound design methodology. Too many warehouses, and too many books, treat building the warehouse from a template approach.

…  See more details below

Overview

8508A-8

Design your data warehouse correctly from the start!

It is well-documented that most data warehouse projects fail. The #1 reason: poor data models or the failure of warehouse designers to apply a sound design methodology. Too many warehouses, and too many books, treat building the warehouse from a template approach. Don't fall into that trap!

Object-Oriented Data Warehouse Design: Building a Star Schema delivers data modeling methodologies that are proven to work. In data warehouse design, one size definitely doesn't fit all! So,

  • Build a complete star schema data model -- from initial analysis through implementation
  • Make better decisions about granularity and precision
  • Master dimensioning, hierarchies, sizing, and more

With Object-Oriented Data Warehouse Design: Building a Star Schema, you will design your data warehouse for maximum business value-the first time.

"I highly recommend the book for its clarity and practicality. Bill has taken a complex subject and brought it down to the level of readability and comprehension." —Bill Inmon

Read More

Product Details

ISBN-13:
9780130850812
Publisher:
Prentice Hall
Publication date:
02/16/2000
Edition description:
New Edition
Pages:
368
Product dimensions:
6.90(w) x 9.00(h) x 0.90(d)

Table of Contents

1. The Data Warehouse.

Business Intelligence. The Data Warehouse. Decision Support Systems. Summary. Glossary.

2. Object-Oriented Design.

The Development Process. Metadata. The Objective of Objects. Summary. Glossary.

3. Analysis and Design.

The Definition Phase. The Analysis Phase. The Design Phase. Summary. Glossary.

4. The Implementation Model.

Dimensionality. Dimensionality and Information Systems. Star Schema. Summary. Glossary.

5. Dimension Tables-the Nouns of the Data Warehouse.

Dimension-Table Characteristics. Slowly Changing Dimensions. Constellations and Conforming Dimensions. Snowflakes. Dimension of Time. The Dimensions of BBBC. Summary. Glossary.

6. Fact Tables—The Verbs of the Data Warehouse.

Fact Tables. Factless Fact Tables. Degenerate Dimensions. Degenerate Facts. Heterogeneous Fact Tables. BBBC Fact Tables. Summary. Glossary.

7. Implementation Considerations.

Parallel Processing. Bitmapped Indexing. Star Query Optimization. Summation Tables. Web-Enabled Data Warehousing. The BBBC Data Warehouse. Summary. Glossary.

Appendix A: The Spacially Enabled Data Warehouse.

Analyzing Patient Needs.

Appendix B: Extraction, Transformation, and Loading.

The ETL Strategy.

Appendix C: Metadata Standards.

The Open Information Model. Common Warehouse Metadata.

Appendix D: Conventional Wisdom, Tips, Hints, and General Advice.

Glossary.

Index.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >