Differences

This shows you the differences between two versions of the page.

--- data_management:data_warehouse [2023/10/22 17:43]
peter created
+++ data_management:data_warehouse [2024/03/08 13:33] (current)
@@ Line 3: / Line 3: @@
 ===Definition===
 A data warehouse is a central [[data_management/data_storage|data storage]] for managing structured data.
+===DMBoK2===
+Data Warehousing describes the operational extract, cleansing, transformation, con-trol, and load processes that maintain the data in a data warehouse so that it can be used by BI. The data warehousing process focuses on enabling an integrated and his-torical business context on operational data by enforcing business rules and maintain-ing appropriate business data relationships. Also includes processes that interact with Metadata repositories.
+===DDDM===
+  * An integrated, centralized decision support database and the related soft-ware programs used to collect, cleanse, transform, and store data from a variety of operational sources to support Business Intelligence. A Data Warehouse may also include dependent [[data_management/data_mart|data marts]]. (DAMA-DMBOK Guide, 1st edition, pg. 197.)
+  * A subject oriented, integrated, time variant, and non-volatile collection of summary and detailed historical data used to support the strategic deci-sion-making processes for the corporation. (“What is a Data Ware-house?” W.H. Inmon, Prism, Volume 1, Number 1, 1995)
+  * A copy of [[data_concept/transactional_data|transaction data]] specifically structured for query and analysis. (Ralph Kimball, The Data Warehouse Toolkit, pg. 310.)
@@ Line 10: / Line 19: @@
 ===Relation===
-|Data ware house|is child of|[[data_management/data_storage|data storage]]|
+|Data warehouse|is child of|[[data_management/data_storage|data storage]]|
+|Data warehouse|has subset|[[data_management/data_mart|data mart]]|
 ===Reference===
-Rani, Isha (2023). [[https://www.linkedin.com/posts/isharanimicrosoftleader_%3F%3F%3F%3F%3F%3F%3F%3F-%3F%3F%3F%3F%3F-%3F%3F%3F%3F-%3F%3F%3F%3F%3F%3F%3F-activity-7117115203019812865-Udi5?|Key data terms explained]]. LinkedIn Post.
+  * Rani, Isha (2023). [[https://www.linkedin.com/posts/isharanimicrosoftleader_%3F%3F%3F%3F%3F%3F%3F%3F-%3F%3F%3F%3F%3F-%3F%3F%3F%3F-%3F%3F%3F%3F%3F%3F%3F-activity-7117115203019812865-Udi5?|Key data terms explained]]. LinkedIn Post.
+  * Earley, S. (2011). The DAMA Dictionary of Data Management (DDDM). Technics Publications, LLC, New Jersey.
-{{tag>All}}
+{{tag>All DMBoK2 DDDM}}

User Tools

Site Tools

Differences

Page Tools