Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Warehousing (DW Information Flows (Inflow - extraction, cleansing and…
Data Warehousing
Characteristics
Integrated Data - integrates data from different source systems, must be made consistent to present a unified view of data to the user
Non-Volatile Data - data is not 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
Problems
-
Complexity of data integration - the integration of data coming from multiple source systems is highly complex
-
-
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
Components
Load Manager/ETL Manager - Extraction, Transformation and Loading of data into the warehouse
-
Query Manager - management of user queries, directing them to the appropriate tables and scheduling the execution of queries
-
DW Information Flows
Inflow - extraction, cleansing and loading of data from source systems into the DW
-
Upflow - adding value to the data through summarizing, packaging and distribution of the data
-
-
ETL - involves tasks of capturing data from source systems, cleansing and transforming it, and loading the results into a target system