-
Marketplace
-
Channel Resources
Articles from this Site
Data Warehousing Appliances Fly into a Storm of Controversy
IBM Launches Next Generation of Business Intelligence with Dynamic Warehousing
Could you please supply a definition for "exploration data mart?"
How could I train to be a good data warehouse business analyst?
What exactly is a corporate information factory, and the pros and cons of this approach?
White Papers
Data Warehouses: What are they and how will they benefit your organization?
Data Warehousing Buyer's Guide
Books
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:


