Everything about Data mart
Data management pattern
A data mart is a structure/access pattern specific to data warehouse environments. The data mart is a subset of the data warehouse that focuses on a specific business line, department, subject area, or team. Whereas data warehouses have an enterprise-wide depth, the information in data marts pertains to a single department. In some deployments, each department or business unit is considered the owner of its data mart, including all the hardware, software, and data. This enables each department to isolate the use, manipulation, and development of its data. In other deployments where conformed dimensions are used, this business unit ownership will not hold true for shared dimensions like customer, product, etc. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Data martA 5-minute orientation
- Skim a recent paper: Developing scalable management information system with big financial data using data mart and mining architectureInfluential work since 2022
- Pick up a classic book: Data preparation for analytics using SASThe most-reprinted book on the subject
- Read the landmark paper: Databases for surgical health services research: Clinformatics Data MartCited 23 times
- Go sideways: Data warehouseA closely related topic
- Go sideways: Star schemaA closely related topic
📖 Definitions
Noun The access layer of a data warehouse environment, used to distribute a subset of the data to users.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Databases for surgical health services research: Clinformatics Data Mart
Creating and implementing a COVID-19 recruitment Data Mart
Text data extraction for a prospective, research-focused data mart: implementation and validation
Implementing data-driven decision support system based on independent educational data mart
Automating Data Mart Construction from Semi-structured Data Sources
Design and development of data mart for animal resources
Big Mart Sales Data Visualization and Correlation
Development of Student Data Mart Using Normalized Data Store Architecture
🆕 Influential since 2022
Developing scalable management information system with big financial data using data mart and mining architecture
OLAP Mining with Educational Data Mart to Predict Students’ Performance
Development of a collaborative learning health system data mart in pediatric liver transplantation
The Role of Data Visualization in Decision Making – Case of D-mart
Validation of an Intensive Care Unit Data Mart for Research and Quality Improvement
📚 Books worth reading
Data preparation for analytics using SASGerhard Svolba · 2006
90 days to the data martAlan R. Simon · 1998
Data mining and knowledge discovery technologiesDavid Taniar · 2008
Understanding and implementing successful data martsDouglas Hackney · 1997
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is a…
- Star schema In computing, the star schema or star model is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and…
- Enterprise bus matrix The enterprise bus matrix is a data warehouse planning tool and model created by Ralph Kimball, and is part of the data warehouse bus architecture. The…
- Dimensional modeling Dimensional modeling is part of the Business Dimensional Lifecycle methodology developed by Ralph Kimball which includes a set of methods, techniques and…
- OLAP cube An OLAP cube is a data cube, a multi-dimensional array of data, used for online analytical processing (OLAP), a computer-based technique of analyzing data…
- Ralph Kimball Ralph Kimball (born July 18, 1944) is an author on the subject of data warehousing and business intelligence. He is one of the original architects of data…
- Aggregate (data warehouse) An aggregate is a type of summary used in dimensional models of data warehouses to shorten the time it takes to provide answers to typical queries on large…
- Essbase Essbase is a multidimensional database management system (MDBMS). The platform provides tools to build data analytic applications. Arbor Software developed…