Corporate Information Factory (Paperback)

~ W. H. Inmon (Author), Claudia Imhoff (Author), Ryan Sousa (Author) "Business is quickly reshaping itself to complete in a global economy governed by the needs of the costumer (e.g., individual, business, etc.)..." (more)
Key Phrases: local data warehouse, corporate information factory, exploration warehouse, Jon Geiger, Joyce Montanari, Metadata Metadata (more...)

Editorial Reviews

Product Description

The "father of data warehousing" incorporates the latest technologies into his blueprint for integrated decision support systems

Today's corporate IT and data warehouse managers are required to make a small army of technologies work together to ensure fast and accurate information for business managers. Bill Inmon created the Corporate Information Factory to solve the needs of these managers. Since the First Edition, the design of the factory has grown and changed dramatically. This Second Edition, revised and expanded by 40% with five new chapters, incorporates these changes. This step-by-step guide will enable readers to connect their legacy systems with the data warehouse and deal with a host of new and changing technologies, including Web access mechanisms, e-commerce systems, ERP (Enterprise Resource Planning) systems. The book also looks closely at exploration and data mining servers for analyzing customer behavior and departmental data marts for finance, sales, and marketing.

From the Back Cover

The father of the data warehouse incorporates the latest technologies into his blueprint for integrated decision support systems

Having invented the corporate information factory (CIF) to help IT and database managers cut through the jungle of information technologies out there, bestselling author Bill Inmon again teams up with experts Claudia Imhoff and Ryan Sousa to show you how to integrate all key components of the modern information system architecture in a way that meets your evolving business needs.

You’ll get clear explanations on how to integrate the enterprise data warehouse with a host of new technologies and solutions that have emerged since this groundbreaking work was first published in 1998. You’ll also discover how to leverage these technologies to ensure broad access to information for end users, while reducing costs and improving scalability across the enterprise. Ultimately, you’ll learn to design, build, and implement a company-wide information ecosystem that:

• Integrates with legacy systems and the Web
• Leverages third-party ERP, CRM, and eBusiness applications
• Exploits the latest in data exploration and mining technologies
• Takes advantage of low-cost alternative storage
• Scales across the enterprise through the use of data marts and operational data stores
• Accommodates the use of multiple data warehouses
• Can start small and grow incrementally

See all Editorial Reviews

Product Details

• Paperback: 400 pages
• Publisher: Wiley; 2 edition (December 18, 2000)
• Language: English
• ISBN-10: 0471399612
• ISBN-13: 978-0471399612
• Product Dimensions: 9.2 x 7.5 x 1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #137,524 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #43 in

  Books > Computers & Internet > Databases > Data Warehousing

Customer Reviews

Most Helpful Customer Reviews

23 of 23 people found the following review helpful:

3.0 out of 5 stars It Depends!, March 21, 2001

By	eganov (WI USA) - See all my reviews

Evaluating "overview" books such as these is difficult. If this is a new subject to you or you are a manager needing an overview, you'll probably find it a good introduction to the Inmon-style Data Warehouse (the other being Kimball-style). But after giving the book a "once-over", that's it. Nothing is handled in enough detail to make this any kind of reference or guide. So from the novice perspective this is a "must read" and as good an introduction to CIF as you will get, from the people that define the standards - give it 4 stars (why not 5 stars will be discussed later). If you have worked on Data Warehousing projects in the past but your environment was not particularly designed with much forethought, then by all means whiz through this book and you'll see that all the pieces can be part of a cohesive strategy - 3 stars. If you are experienced then you'll probably see this as a waste of time, too high level. You can get everything in here from various web sites, whitepapers or other books - 1 star. Regardless of where you're coming from though this is one of the few books that actually use pictures in a way that is detrimental to clarity. Some are repeated so many times, so inane or so large that you have to surmise that they are mostly there to thicken the book. The appendix, CIF Architecture Guidelines, is also the largest section of the book yet I have no idea what the point is. I think it would be more appropriately titled - Incomplete Ruminations on Random Topics.

11 of 11 people found the following review helpful:

3.0 out of 5 stars 50,000 ft-level architectural overview, May 22, 2000

By	DTC# "ROP" (ROP) - See all my reviews

This review is from: Corporate Information Factory (Hardcover)

I saw Ms. Imhoff give a talk, so I was motivated to buy her book. I was expecting more detail and more depth, but I was satisfied anyway. As a new comer to the data warehousing/OLAP field, I found it helpful to have a book that showed me the "forest"; many other books are available to show me the "trees."

The book is a very high-level architectural overview of the components of a "corporate information factory", including the data warehouse, data mart, and operational data store. It describes the components and their relationships. It describes the motivations and reasons these components are organized the way they are. It describes some of the important engineering tradeoffs in alternate designs.

The book is a quick and simple read. I got a few very important concepts and ideas from it, but I must definitely read several other books for greater depth and focus.

25 of 31 people found the following review helpful:

2.0 out of 5 stars Inaccurate and pompous, with little substance, January 13, 2003

By	Miki Trasi (Western Mass) - See all my reviews

I approached this book with an open mind, but after I stumbled upon a couple of obviously wrong and some nonsensical statements, I started reading it much more skeptically, and finding more and more problems with it. (However, it did provide more fun ;))

The book has a good premise, trying to explain information system with the factory metaphor. Although authors give some good insight in the way IS should or could be thought of and modeled, there are many instances in the text where you read something and say to yourself "what where these good people thinking". This then undermines your confidence in their vision and full understanding of the matter. And although I think this is a matter of personal preference, authors sometimes seem to be in love with their style, producing some beautiful nonsense like this: "The legacy environment is only a very small vestige of its former invincible self." (pg. 42)

Let me give you some more examples of what I'm talking about:
Authors create metaphors of user classes, calling them "tourist, farmer, explorer and miner", which in itself is not a bad idea, but then they go on to say "...farmers found at the ODS environment are quite different from the farmers found at the data mart". So why did you create the single metaphor then?

Also, check this out: "A miner will typically look over many, many rows of data...". As opposed to what, just a "many rows of data"? Whence some people might need "not so many rows of data"? Like I'm reading a book for my eight-year-old, for goodness sakes!

Then there is this graph showing the directional flow of data, but then it reads: by the way, in all this streams, data can sometimes ("in 1-5% of the cases" - authors never say how they got these numbers, it is all a slight of hand) flow in the opposite direction!!?(Pg. 24) And they go about giving 5 examples, 4 of which are wrong - there is no data flow in them at all!
Example:"...sales dept. notes that loans are slowing down. The decision is made to reduce home loan rates by 1/2 percent."
This is not the back flow of data, as authors assert, it is an information feedback loop that involves people (management), and their decisions. Data (loan rates) is not coming back from Data Mart. User is somehow entering it into Operational system (application). His decision is influenced by data analysis, but it does not reverse the data flow. The fundamental issue here is that authors ignored the fact that information processes in the company involve people as well as the data and systems, and should be modeled as such. To use their metaphor, users should be a part of the information ecosystem. Hence it is not true that, as the book claims, corporate information factory embodies the information ecosystem. (Pg.7)

"...'event' date ...reflects the moment in time when the data in the record was accurate". (Pg. 96) This is incorrect. 'event' date is just recording the time of that single event. Record is always accurate after that, it does not 'age' with time.

At pg. 191 it is asserted that Data Warehouse provides "depth" to the data. That is true only if it is built (modeled) with "depth" requirements in mind. Before I can get "deep" information from the DW, I must build it with my questions in mind, otherwise, it will not give me data. An abstractly deep DW does not exist. It is always an answer to a particular question, or number of questions.

"The Dimension of History" (pg. 193-194) is just plain good old nonsense, with example (life stages of an individual) being completely off the mark. Reminds me of the student who does not know the correct answer to the question so he tries to invent some plausible response, letting his imagination fly ... Sad.

And so on, and so on...

I saved the best ones for the end:
"...the external world is full of normal occurrences and normal events. The very ordinary nature of the external world makes us take it for granted." (Pg. 49) Very philosophically deep, indeed ;)
"The emergence of the integrated applications comes slowly and, in many cases, imperceptibly" (pg.42) Yeah, it just creeps on you when you're not looking... ;)
".. the back flow of the data is minuscule to the point that in some cases it is so small as to be unmeasurable". (Pg. 23) :0 Beg your pardon? This is not quantum physics, guys, this is computer science. Anything can be observed, perceived and measured to the level of a single bit. Or are we talking bit-quarks here? Informational principle of uncertainty?

It is disappointing to have this book co-authored by the "father of the data warehouse".

To the (prospective) readers: This is a fun book if you are an experienced data architect, bad if you wish to use it as a blueprint for your work, and dangerous if you are an IT manager and impose it on your staff.

To the authors: Give us a break, please go back and re-make a decent book around the good basic idea. Less poetic style would also be appreciated. Forget about quantum physics. And give it to some unbiased reviewers first. Remember, only the real friends will tell you the unpopular truth.