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. 

Further Resources

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

Send us your feedback or suggestions for new terms

Contact information
CAPTCHA
4 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
This question is to prevent spam submissions. Contact nwso@hshsl.umaryland.edu for any accessibility issues.