FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   
BI Review content and features are now in DMReview.com!

One brand, one Web site! DM Review is now the home of all the content you're used to at BIReview.com and much more. If you are registered at BIReview.com, you're already registered at DM Review. If not, take just a moment to sign up for all the free services we have for you at the new DMReview.com.

What exactly is a corporate information factory, and the pros and cons of this approach?

Q:  

What exactly is a corporate information factory, and the pros and cons of this approach? How will this approach help organizations?

A:  

Larissa Moss's Answer: A Corporate Information Factory is the term for a data warehouse environment that recognizes different types of target databases to be used for different decision support reporting purposes. The target databases are the ODS (operational data store), the EDW (enterprise data warehouse), the data marts (tailored to specific reporting patterns) and the exploration warehouse. These databases are implemented for different needs of an organization. An ODS stores integrated and cleansed data from multiple operational source files or databases to be used primarily for tactical and operational reporting. An EDW stores integrated, cleansed and historical data from multiple operational source files to be used primarily for strategic ad hoc reporting which requires maximum flexibility and follows no predetermined reporting patterns. Data marts, by far the most common and most popular databases, store selected pre- calculated data tailored for specific reporting patterns. The exploration warehouse is populated with specific pools of data needed for data mining. This can be detailed data, summarized data, historical or transaction level. An organization should make use of the various types of target databases depending on their decision support needs.


Larissa Moss is founder and president of Method Focus Inc., a company specializing in improving the quality of business information systems. She has more than 20 years of IT experience with information asset management. Moss is coauthor of three books: Data Warehouse Project Management (Addison-Wesley, 2000), Impossible Data Warehouse Situations (Addison-Wesley, 2002) and Business Intelligence Roadmap: The Complete Project Lifecycle for Decision- Support Applications (Addison-Wesley, 2003). Moss can be reached at methodfocus@earthlink.net.

For more information on related topics, visit the following channels:



Industry Vendors