What do you mean by data mart? What are the different types of data mart?

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
More related questions

Questions Bank

View all Questions