The 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.
Provides basic generic advice
As other reviers have mentioned, this book covers wide, but not that deep. Like many books, it gives advice so generic as to be useless, but an easy to understand overview has its importance too, so perhaps this is a good place to start.
So you will see the basic problems of combining data from different sources into one place, but not necessarily how to do it. Very little is dedicated to the issues around moving that data or ETL.
This book has many chapters, many of which may not apply to your situation.
Good and Bad
This book is a good introduction to data warehousing. However, the style is remarkably bad. It is very repetitious, poorly organized overall, occasionally self-contradictory, and jam-packed with cartoon-like line drawings that seldom add clarity to the discussion. The book easily could be reduced from 500 pages to 200 pages without losing any information, and with an improvement in readability.
BI for smarties
In my opinion Kimball vs Inmon is not a war of religion, they both have pro and cons in different situation. I believe people seriously interested in BI should read the book and take several advices from it. There are situation in which an Inmon design is good, there are some in which it isn't BUT to be able to judge you need to know both an be able to decide based on the customer's necessity.
The pictures in the book are really ugly and useless, nevertheless the concepts are clearly stated and easily understandable. If I have to say something wrong about it is that you need to already know what a BI system is in order to get the most out of the book. It is not for newcomers but it is definetely a good book on BI.
Review of Data Warehouse Tools
Received in a timely manner, in good condition, and it is very useful. Thx.
The (im)practical approach to DW design
If you work for a large corporation which has millions of $ to spend on DW projects, maybe you should look at this book and even consider some of the ideas that it contains.
But if you need to develop a data warehouse using limited resources and within a certain timeframe, your time will better used reading other books, because following the Inmon approach will lead you to an unnecessary complicated and expensive design.
I found that the arguments used by Inmon to demonstrate the limits of the dimensional approach are not convincing at all. For example, at page 142 he says `Because there is a different data structure for each data mart, making any data mart into a data warehouse doesn't make sense.`
Having personally implemented several data warehouses using the `conformed dimensions` approach, I can guarantee that it worked and produced a very elegant and clean data model.
We does not store any files on its server. We does not reserve any rights to, nor claims copyright to, any resources names listed on these pages. All references are copyright to their respective owners.