Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Data Mart

  • Il-Yeol Song
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_883

Definition

A data mart is a small-sized data warehouse focused on a specific subject. While a data warehouse is for an entire enterprise, a data mart is built to address the specific analysis needs of a business unit. Hence, we can define a data mart as a small-sized data warehouse that contains a subset of the enterprise data warehouse or a limited volume of aggregated data for specific analysis needs of a business unit, rather than the needs of the whole enterprise. Thus, an enterprise usually ends up having many data marts.

Main Text

While a data warehouse is for a whole enterprise, a data mart focuses on a specific subject of a specific business unit. Thus, the design and management of a data warehouse must consider the needs of the whole enterprise, while those of a data mart are focused on the analysis needs of a specific business unit such as the sales department or the finance department. Thus, a data mart shares the characteristics of a data warehouse, such as being...
This is a preview of subscription content, log in to check access.

References

  1. 1.
    Kimball R, Ross M. The data warehouse toolkit: The Definitive Guide to Dimensional Modeling. 3rd ed. New York: Wiley; 2013.Google Scholar
  2. 2.
    Inmon WH. Building the data warehouse. 3rd ed. Hoboken: Wiley; 2002.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.College of Computing and InformaticsDrexel UniversityPhiladelphiaUSA

Section editors and affiliations

  • Torben Bach Pedersen
    • 1
  • Stefano Rizzi
    • 2
  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.DISIUniv. of BolognaBolognaItaly