-
Marketplace
-
Channel Resources
Articles from this Site
Navy Exchange Service Command Selects Netezza
Netezza Enters Location Intelligence Market
Data Warehousing Meets Data Archiving in Information Lifecycle Management
Data Warehousing Appliances Fly into a Storm of Controversy
IBM Launches Next Generation of Business Intelligence with Dynamic Warehousing
White Papers
Data Warehouses: What are they and how will they benefit your organization?
Data Warehousing Buyer's Guide
Books
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:


