Data process flow
Data Warehouse
A data warehouse is a multi-purpose enabler of operational and performance analytics.
Data Marts
- provide analytical capabilities for a restricted area of the data warehouse
- offer isolated security and isolated performance
- the most important role is business specific reporting and analytics
Data Lakes
A pool of raw data where each data element is given a unique identifier and is tagged with metatags for further use and retains all source data without exclusions.
ETL
Staging area