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 via an institution.
References
Kimball R, Ross M. The data warehouse toolkit: The Definitive Guide to Dimensional Modeling. 3rd ed. New York: Wiley; 2013.
Inmon WH. Building the data warehouse. 3rd ed. Hoboken: Wiley; 2002.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2016 Springer Science+Business Media New York
About this entry
Cite this entry
Song, IY. (2016). Data Mart. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_883-3
Download citation
DOI: https://doi.org/10.1007/978-1-4899-7993-3_883-3
Received:
Accepted:
Published:
Publisher Name: Springer, New York, NY
Online ISBN: 978-1-4899-7993-3
eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering