Data Warehouse Terminology
What’s a Data Warehouse?
Data Warehouse v. Database
|Accessibility||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|
|Storage||Single layer of information presented||Layered information in standardized formatting|
|Usage||Recording and retrieving information||Storage of large amounts of information|
Data Warehouse v. Data Lake
|Data Lake||Data Warehouse|
|Accessibility||Raw, unstructured data||Structured, integrated data|
|Storage||Simplified storage bank||Standardized storage vault|
|Usage||Unformatted or loose formatting||Relational formatting|
Data Mart vs Data Warehouse vs Data Lake Architectures
Data Warehouse v. Data Mart
|Data Mart||Data Warehouse|
|Storage||Dependent or independent*||Integrated|
|Usage||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.
Contact us today to learn how Eccovia can help you achieve improved outcomes for the people your organization serves.