What do you mean by data mart? What are the different types of data mart?
4 years ago
Data Mining and Data Warehousing
What is Data Marts?
- Data marts contain a subset of organization-wide data that is valuable to specific groups of people in an
- A data mart contains only those data that is specific to a particular
- Data marts improve end-user response time by allowing users to have access to the specific type of data they need to view most often by providing the data in a way that supports the collective view of a group of users.
- A data mart is basically a condensed and more focused version of a data warehouse that reflects the regulations and process specifications of each business unit within an
- Each data mart is dedicated to a specific business function or
- For example, the marketing data mart may contain only data related to items, customers, and Data marts are confined to subjects.
Listed below are the reasons to create a data mart
- To speed up the queries by reducing the volume of data to be
- To partition data in order to impose access control
- To segment data into different hardware
- Easy access to frequently needed data
- Creates collective view by a group of users
- Improves end-user response time
- Lower cost than implementing a full data warehouse
- Contains only business essential data and is less
- Three basic types of data marts are dependent, independent, and
- The categorization is based primarily on the data source that feeds the data
- Dependent data marts draw data from a central data warehouse that has already been
- Independent data marts, in contrast, are standalone systems built by drawing data directly from operational or external sources of data or
- Hybrid data marts can draw data from operational systems or data warehouses
What are the Types of Data Marts?
1. Dependent Data Marts
- A dependent data mart allows you to unite your organization's data in one data
- This gives you the usual advantages of
- Figure illustrates a dependent data
2. Independent Data Marts
- An independent data mart is created without the use of a central data
- This could be desirable for smaller groups within an
- Figure illustrates an independent data
3. Hybrid Data Marts
- A hybrid data mart allows you to combine input from sources other than a data
- This could be useful for many situations, especially when you need ad hoc integration, such as after a new group or product is added to the
- Figure illustrates a hybrid data
Raju Singhaniya
Oct 14, 2021