Data Warehouse

Definition

A data warehouse is a centralized repository for aggregating data of different types for further analysis. Data from different source databases are loaded into a data warehouse by a process called Extract Transform Load (ETL). Extracting is the process of pulling some or all of the data out of the source databases. Transforming includes various aspects of processing, including data cleaning and structuring the data to adhere to a common format. Loading the data is the process of moving the data into the warehouse. 

Relevant Literature

A brief, clear explanation of the distinction between databases, data warehouses and data lakes.

Alex the Analyst. "Database vs Data Warehouse vs Data Lake | What is the Difference?" YouTube, uploaded by Alex the Analyst, 26 Apr 2022, https://youtu.be/-bSkREem8dM?si=BLHQTEg2hyZoxnKV.

Search for a Term