Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data :Warehousing - Coggle Diagram
Data :Warehousing
-
Inflow - extraction, cleanising and loading of data from source systems into the DW
-
Upflow - adding value to the data through summarizing, packaging and distribution of the data
-
Problems
-
-
Complexity of data intergration - the integration of data coming from multiple source systems is highly complex
-
Characteristics
-
Integrated Data - Intergrades data from different source systems, must be made consistent to present a unified view of data to the user
Non-Volatile Data - datra is mot updated in real-time, its refreshed from operational systems regularly
Time-Variant Data - data is only accurate and valid at some point in time or over some time interval
Components
-
query Manager - management of user queries, directing them to the appropriate tables and scheduling the execution of queries
Load Manager/ETL Manager - Extraction, Transormation and Loading of data into the warehouse
-
Benefits
-
Competitive advantage - by allowing access to data that can reveal previously unavailable, unknown information or patterns of the business
Increased productivity of corporate decision makers - By creating an integrated database of consistent, subject-oriented, historical data
DW Information Flows
ETL - involves tasks of capturing data from source systems, cleansing and transforming it, and loading the results into a target system