Most data warehouse projects fail -- and the #1 cause is a failure to implement the right data models. In this book, leading data warehouse expert William Giovanazzo details a proven software engineering methodology and world-class techniques for data modeling in any decision support environment. Unlike other books, Object-Oriented Data Warehouse Design: Building a Star Schema recognizes that "one size doesn't fit all" in data warehouse design -- and introduces a methodology that can easily be applied to any organization's realities. Readers will develop a star schema data model from start to finish, addressing key issues such as granularity and precision; dimensions; hierarchies, and sizing. Every step is introduced with theory and supported with a live case study example. The book includes methodology checklists, chapter review questions, glossaries, bibliographies, and more. For data warehouse designers and developers, and for DBAs and system engineers in companies developing a data warehouse.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 183 mm
Breite: 243 mm
Dicke: 30 mm
Gewicht
ISBN-13
978-0-13-085081-2 (9780130850812)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
William Giovinazzo has been an Oracle instructor, a software engineer, and a systems analyst, and has worked on every side of a data warehouse, including marketing, sales, development, implementation, and maintenance. Now a Business Intelligence Evangelist at Oracle Corporation, he regularly writes columns and speaks on data warehousing and Oracle technologies.
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.
