Anonymous
Posted Fri Mar 10 00:00:00 EST 2000
If you are just playing at data warehousing, then get yourself a copy of one of those 'The Doofus¿ Guide To Whatever' books. But, if you want to be successful implementing an enterprise-level, mission-critical data warehouse, this is one book you will definitely want to have. For me this is a new look at the whole Business Intelligence field. I am not even half way through and I can already see why some past projects ran into trouble and how I can avoid similar trouble in the future. And this is not one of those unreadable academic tomes that you put on your bookshelf to impress your boss. I have to agree with Bill Inmon¿s foreword that Giovinazzo '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.' This is a very readable book with lots of immediately useful information without resorting to that 'cookbook' approach. I especially enjoyed the discussion in Chapter 4, The Implementation Model, on multiple dimensions and translating them into a star schema. The whole object oriented approach to star schema design seems so logical, now that I have had it explained in such a clear, concise manner. BTW, the other book I wouldn¿t be without is Ralph Kimball¿s 'The Data Warehouse Toolkit'. But if you can only get one, get this one. And if you manage a DW, I¿d seriously consider investing in a copy for every person on the project. I think you¿ll be glad you did.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
More About This Textbook
Overview
8508A-8
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
Product Details
Related Subjects
Meet the Author
William Giovinazzo has been an Oracle instructor, a software engineer, and a systems analyst, and has worked on every side of a data warehouse, including marketing, sales, development, implementation, and maintenance. Now a Business Intelligence Evangelist at Oracle Corporation, he regularly writes columns and speaks on data warehousing and Oracle technologies.
Read an Excerpt
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
Table of Contents
1. The Data Warehouse.
Business Intelligence. The Data Warehouse. Decision Support Systems. Summary. Glossary.
2. Object-Oriented Design.
The Development Process. Metadata. The Objective of Objects. Summary. Glossary.
3. Analysis and Design.
The Definition Phase. The Analysis Phase. The Design Phase. Summary. Glossary.
4. The Implementation Model.
Dimensionality. Dimensionality and Information Systems. Star Schema. Summary. Glossary.
5. Dimension Tables-the Nouns of the Data Warehouse.
Dimension-Table Characteristics. Slowly Changing Dimensions. Constellations and Conforming Dimensions. Snowflakes. Dimension of Time. The Dimensions of BBBC. Summary. Glossary.
6. Fact Tables—The Verbs of the Data Warehouse.
Fact Tables. Factless Fact Tables. Degenerate Dimensions. Degenerate Facts. Heterogeneous Fact Tables. BBBC Fact Tables. Summary. Glossary.
7. Implementation Considerations.
Parallel Processing. Bitmapped Indexing. Star Query Optimization. Summation Tables. Web-Enabled Data Warehousing. The BBBC Data Warehouse. Summary. Glossary.
Appendix A: The Spacially Enabled Data Warehouse.
Analyzing Patient Needs.
Appendix B: Extraction, Transformation, and Loading.
The ETL Strategy.
Appendix C: Metadata Standards.
The Open Information Model. Common Warehouse Metadata.
Appendix D: Conventional Wisdom, Tips, Hints, and General Advice.
Glossary.
Index.
Preface
Foreword
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