Data Warehousing - Data Marts

> (Data|State) Management and Processing > Data Warehouse

1 - About

A data marts is a subject-or application-specific star schema build on the top of an EDW.

A data warehouse refers more to the complete data integration system with an enterprise-wide background.

data marts are designed for a particular line of business and is an “aggregation layer”.

Data marts contain, primarily, dimensions and facts. Facts can contain either atomic data and, if necessary, summarized data.

Data marts are designed and tuned for online analytical processing (OLAP) queries.


3 - Type of data mart

  • Star Schema (Physical table on a relational Database)
  • Virtualized Star Schema (View on a relational Database)

When not virtualized, it must only store rolling history (ie limited history – not the entire history that is contained in the EDW).

4 - Documentation / Reference