Building and Maintaining a Data Warehouse
- 4h 41m
- Fon Silvers
- CRC Press
- 2008
As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product. While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoretically sound, is not especially easy. That’s the challenge that Building and Maintaining a Data Warehouse answers.
Based on a foundation of industry-accepted principles, this work provides an easy-to-follow approach that is cohesive and holistic. By offering the perspective of a successful data warehouse, as well as that of a failed one, this work details those factors that must be accomplished and those that are best avoided.
Organized to logically progress from more general to specific information, this valuable guide:
- Presents areas of a data warehouse individually and in sequence, showing how each piece becomes a working part of the whole
- Examines the concepts and principles that are at the foundation of every successful data warehouse
- Explains how to recognize and attend to problematic gaps in an established data warehouse
- Provides the big picture perspective that planners and executives require
Those considering the planning and creation of a data warehouse, as well as those who’ve already built one will profit greatly from the insights garnered by the author during his years of creating and gathering information on state-of-the-art data warehouses that are accessible, convenient, and reliable.
About the Author
Fon Silvers began his career in Information Systems as a one-person IS shop, doing everything from hardware, software, application development, and data entry. After completing his MBA with a concentration in Information Systems from the University of South Florida (Tampa), he moved to a position with a Fortune 500 company, which is where Silvers was introduced to Data Warehousing. While there, he participated in the creation of Data Warehouse solutions that included retail sales transactions, Online Analytical Process (OLAP) analytics, and real-time logistics transactions.
In this Book
-
Building and Maintaining a Data Warehouse
-
Introduction
-
The Big Picture: An Introduction to Data Warehousing
-
Data Warehouse Philosophy
-
Source System Analysis
-
Relational Database Management System (RDBMS)
-
Database Design
-
Data Acquisition and Integration
-
Business Intelligence Reporting
-
Data Quality
-
Metadata
-
Data Warehouse Customers
-
Future of Data Warehousing: An Epilogue
-
Bibliography
