Building the data warehouse
The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himselfIn addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handlin...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
J. Wiley
c2005.
|
| Edición: | 4th ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627574706719 |
Tabla de Contenidos:
- Building the Data Warehouse, Fourth Edition; Credits; About the Author; Contents; Preface for the Second Edition; Preface for the Third Edition; Preface for the Fourth Edition; Acknowledgments; Building the Data Warehouse, Fourth Edition; Chapter 1: Evolution of Decision Support Systems; The Evolution; Problems with the Naturally Evolving Architecture; The Development Life Cycle; Patterns of Hardware Utilization; Setting the Stage for Re-engineering; Monitoring the Data Warehouse Environment; Summary; Chapter 2: The Data Warehouse Environment; The Structure of the Data Warehouse
- Subject OrientationDay 1 to Day n Phenomenon; Granularity; Exploration and Data Mining; Living Sample Database; Partitioning as a Design Approach; Structuring Data in the Data Warehouse; Auditing and the Data Warehouse; Data Homogeneity and Heterogeneity; Purging Warehouse Data; Reporting and the Architected Environment; The Operational Window of Opportunity; Incorrect Data in the Data Warehouse; Summary; Chapter 3: The Data Warehouse and Design; Beginning with Operational Data; Process and Data Models and the Architected Environment; The Data Warehouse and Data Models
- The Data Model and Iterative DevelopmentNormalization and Denormalization; Metadata; Cyclicity of Data - The Wrinkle of Time; Complexity of Transformation and Integration; Triggering the Data Warehouse Record; Profile Records; Managing Volume; Creating Multiple Profile Records; Going from the Data Warehouse to the Operational Environment; Direct Operational Access of Data Warehouse Data; Indirect Access of Data Warehouse Data; Indirect Use of Data Warehouse Data; Star Joins; Supporting the ODS; Requirements and the Zachman Framework; Summary; Chapter 4: Granularity in the Data Warehouse
- Raw EstimatesInput to the Planning Process; Data in Overflow; What the Levels of Granularity Will Be; Some Feedback Loop Techniques; Levels of Granularity - Banking Environment; Feeding the Data Marts; Summary; Chapter 5: The Data Warehouse and Technology; Managing Multiple Media; Indexing and Monitoring Data; Interfaces to Many Technologies; Programmer or Designer Control of Data Placement; Parallel Storage and Management of Data; Language Interface; Efficient Loading of Data; Efficient Index Utilization; Compaction of Data; Compound Keys; Variable-Length Data; Lock Management
- Index-Only ProcessingFast Restore; Other Technological Features; DBMS Types and the Data Warehouse; Changing DBMS Technology; Multidimensional DBMS and the Data Warehouse; Data Warehousing across Multiple Storage Media; The Role of Metadata in the Data Warehouse Environment; Context and Content; Refreshing the Data Warehouse; Testing; Summary; Chapter 6: The Distributed Data Warehouse; Types of Distributed Data Warehouses; The Nature of the Development Efforts; Distributed Data Warehouse Development; Building the Warehouse on Multiple Levels
- Multiple Groups Building the Current Level of Detail
