Data Warehouse Terminology
What’s a Data Warehouse?
Data Warehouse v. Database
|Optimized for read write access of
a single or few data records
|Aggregates many data sources; optimized for analytical workloads that typically involve aggregating all rows of certain columns of fact tables
|Single layer of information presented
|Layered information in standardized formatting
|Recording and retrieving information
|Storage of large amounts of information
Data Warehouse v. Data Lake
|Raw, unstructured data
|Structured, integrated data
|Simplified storage bank
|Standardized storage vault
|Unformatted or loose formatting
Data Mart vs Data Warehouse vs Data Lake Architectures
Data Warehouse v. Data Mart
|Dependent or independent*
|Small subsets of a data warehouse but typically aligned with business division.
|For the entire enterprise
* A dependent data mart is dependent on a data warehouse as the source for its data, resulting in less control over the data; an independent data mart is not dependent on a data warehouse, and data is ingested from different outside sources, granting more control over the data.
We’re Here to Help
For more information about how our ClientInsight platform can help you automate your data quality checks, account for your successes, and gain greater vision and insight into your data, schedule a demo and our experts will reach out to you.
Please fill out the form below if you’d like to speak with one of our experts.