Building the Data WarehouseThe data warehousing bible updated for the new millennium Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing "bible" provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses. Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques. |
Contents
Chapter 1 Evolution of Decision Support Systems | 1 |
Chapter 2 The Data Warehouse Environment | 31 |
Chapter 3 The Data Warehouse and Design | 81 |
Chapter 4 Granularity in the Data Warehouse | 147 |
Chapter 5 The Data Warehouse and Technology | 167 |
Chapter 6 The Distributed Data Warehouse | 201 |
Chapter 7 Executive Information Systems and the Data Warehouse | 247 |
Chapter 8 ExternalUnstructured Data and the Data Warehouse | 265 |
Chapter 9 Migration to the Architected Environment | 277 |
Other editions - View all
Common terms and phrases
amounts of data analysis applications architected environment architecture clickstream common corporate data model created DASD data architect data found data mart data ware data warehouse data data warehouse environment database design deliverable detailed data development group disk storage distributed data warehouse DSS analyst DSS data DSS environment DSS processing end user ERP environment existing systems external data foreign key global data warehouse integration interface issue iterative level of data level of detail level of granularity lightly summarized living sample ment meta data methodology monitoring multidimensional DBMS NORMALLY EXECUTED ONCE occurs OLAP OLTP ONCE OR MULTIPLE operational data operational data store operational environment operational processing operational systems organization PARAMETERS OF SUCCESS partitioning profile record referential integrity relationship requirements ronment SDLC shown in Figure snapshot summary data system of record tables Tech Topic tion transaction unstructured data update volume of data warehousing