Design your data warehouse correctly from the start!
It is well-documented that most data warehouse projects fail. The #1 reason: poor data models or the failure of warehouse designers to apply a sound design methodology. Too many warehouses, and too many books, treat building the warehouse from a template approach. Don't fall into that trap!
Object-Oriented Data Warehouse Design: Building a Star Schema delivers data modeling methodologies that are proven to work. In data warehouse design, one size definitely doesn't fit all! So,
With Object-Oriented Data Warehouse Design: Building a Star Schema, you will design your data warehouse for maximum business value-the first time.
"I highly recommend the book for its clarity and practicality. Bill has taken a complex subject and brought it down to the level of readability and comprehension." —Bill Inmon
Click here for a sample chapter for this book: 0130850810.pdf
1. The Data Warehouse.
Business Intelligence. The Data Warehouse. Decision Support Systems. Summary. Glossary.
The Development Process. Metadata. The Objective of Objects. Summary. Glossary.
The Definition Phase. The Analysis Phase. The Design Phase. Summary. Glossary.
Dimensionality. Dimensionality and Information Systems. Star Schema. Summary. Glossary.
Dimension-Table Characteristics. Slowly Changing Dimensions. Constellations and Conforming Dimensions. Snowflakes. Dimension of Time. The Dimensions of BBBC. Summary. Glossary.
Fact Tables. Factless Fact Tables. Degenerate Dimensions. Degenerate Facts. Heterogeneous Fact Tables. BBBC Fact Tables. Summary. Glossary.
Parallel Processing. Bitmapped Indexing. Star Query Optimization. Summation Tables. Web-Enabled Data Warehousing. The BBBC Data Warehouse. Summary. Glossary.
Analyzing Patient Needs.
The ETL Strategy.
The Open Information Model. Common Warehouse Metadata.
In the beginning were applications. Users thought that applications would provide them with information. And insofar as the stated requirements of the applications were concerned, the applications sufficed. But over time the business requirements changed. Keeping the applications in sync with the changing business requirements was a difficult thing to do.
Along the way in trying to keep up with changing requirements, the end users encountered some other limitations to the world of applications. Those limitations were the need for
The applications that the corporation had created or otherwise acquired had no notion of integration. One application thought a customer was one thing. Another application thought a customer was something else. And a third application had yet another interpretation of what a customer was. When it came to the corporate understanding of data, there was-simply stated-no corporate understanding. From a corporate perspective the manager could not answer such basic questions as
In short, the different applications were never designed to work together in an integrated manner.
The second issue was that applications focused inevitably on very current data. Applications could reveal
The applications were designed to keep track of what is going on right now. But when it came to a sense of the need and importance of historical information, the applications treated historical data with no respect at all.
Unfortunately, integration and history represent a very important component of information. And applications simply did not measure up.
The end user's first reaction was to rewrite the applications of yesterday. But this idea quickly fell by the wayside. The end user found that-as far as applications were concerned-the clock could not be turned back. There were simply too many applications, too much undocumented code, too much fragile code, too much complexity to even attempt to roll back the tide of applications.
Thus was born the notion of a data warehouse, an alternative to the dilemma of the end user who needed information but could not impose change on the legacy applications environment.
Like all radical and fresh concepts, the notion of a data warehouse was derided and scorned by the academics and theoreticians. Since the idea of data warehousing had not risen among their ranks, it could not possibly be a valid concept. Today data warehousing is no longer a theory. It is conventional wisdom, and corporations around the world recognize that the road forward leads through the data warehouse.
Data warehousing forms the center of a wide universe. From the corporate data warehouse, with its granular, corporate integrated data, spring many different kinds of decision support activity. The data warehouse forms the basis for such DSS processing as
But data warehousing did not happen all at once. Like a giant jigsaw puzzle, data warehousing has been put together a piece at a time. The world of data warehousing has been led by writers and by practitioners who became writers. These leaders have described from their experience what works and what does not.
Into this realm falls Bill Giovinazzo's book. Its really interesting aspect is that it is
Based on the reality of data warehousing, Bill Giovinazzo's book is a modern rendition of what you need to know about data warehousing in order to be successful. It strikes a fine balance between theory and practicality. Theories are explained in the cloth of practicality. Rules of thumb and practical realities always have a touch of theory to explain the underlying philosophy.
If you care about success in warehousing, this is the book that belongs on your bookshelf.
W. H. Inmon