Building the data warehouse / W.H. Inmon.

Format:

Book

Author/Creator:

Inmon, William H.

Language:

English

Subjects (All):

Database management.

Data warehousing.

Physical Description:

1 online resource (575 p.)

Edition:

4th ed.

Place of Publication:

New York : J. Wiley, c2005.

Language Note:

English

System Details:

text file

Summary:

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 handling unstructured data in a data warehouse and storing data across multiple storage mediaDiscusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projectsCovers advanced topics, including data monitor

Contents:

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

Notes:

"Wiley computer publishing."

Includes bibliographical references and index.

ISBN:

9786610279715

9781280279713

1280279710

9780471774235

0471774235

OCLC:

650016443