Data warehouses provide a much–needed strategy for organizations to collect, store, and analyze vast amounts of business data. As businesses expand both brick–and–mortar and online activities, the field of data warehousing has become increasingly important. Since it was first published in 1990, W. H. Inmon′s Building the Data Warehouse has been the bible of data warehousing it is the book that launched the data warehousing industry and it remains the preeminent introduction to the subject. This new edition covers the latest developments with this technology, many of which have been pioneered by Inmon himself.
An overview of all the fundamental components of data warehouse systems offers you a refresher of the methods used for data warehouse design; various data warehouse migration strategies; and the technologies that can be applied for loading, indexing, and managing data. In order to bring you up to date, this in–depth guide then features the latest advances in data warehousing.
New chapters cover:
- Understanding methods for handling unstructured data in a data warehouse
- Storing data across multiple storage media
- Examining the pros and cons of relational vs. multidimensional design
- Measuring return on investment in planning data warehouse projects
- Exploring advanced topics, including data monitoring and testing
Chapter 1: Evolution of Decision Support Systems.
Chapter 2: The Data Warehouse Environment.
Chapter 3: The Data Warehouse and Design.
Chapter 4: Granularity in the Data Warehouse.
Chapter 5: The Data Warehouse and Technology.
Chapter 6: The Distributed Data Warehouse.
Chapter 7: Executive Information Systems and the Data Warehouse.
Chapter 8: External Data and the Data Warehouse.
Chapter 9: Migration to the Architected Environment.
Chapter 10: The Data Warehouse and the Web.
Chapter 11: Unstructured Data and the Data Warehouse.
Chapter 12: The Really Large Data Warehouse.
Chapter 13: The Relational and the Multidimensional Models as a Basis for Database Design.
Chapter 14: Data Warehouse Advanced Topics.
Chapter 15: Cost–Justification and Return on Investment for a Data Warehouse.
Chapter 16: The Data Warehouse and the ODS.
Chapter 17: Corporate Information Compliance and Data Warehousing.
Chapter 18: The End–User Community.
Chapter 19: Data Warehouse Design Review Checklist.