What is Data Mart?
In the Data Warehouse system Data Mart is a major role. Data Mart contains a subset of an organization. In other words, a data mart contains only those data that are specific to a particular group. For example, the marketing data mart may contain only data related to items, customers, and sales.
- Data Marts improve end-user response time by allowing users to have access 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.
- Data Marts are confined to subjects.
Three Types of Data Mart:
Based on data source dividing the Data Mart into three types
1.Dependent: In contrast, are standalone systems built by drawing data directly from internal or external sources of data or both. This allows you to unite the organization’s data in one data warehouse system with centralization.
2.Independent: Data Mart is created without the use of a central data warehouse for smaller groups within an organization.
- 3.Hybrid: Data Marts can draw data from operational systems or data warehouses. It is a combination of dependent and independent data warehouse.
Implementing Datamart with simple steps:
Data Mart implementing is a bit of a complex procedure. Here are the detailed steps to implementing the Data Mart:
This is the first phase of Data Mart implementation while tasks assigned. At the time gathering the information about the requirements. Then create the physical and logical design of the data mart.
Constructing is the second phase of implementation. It involves creating the physical database and logical structures in data warehouse system. Here are storage management, fast data access, data protection, and security for constructing the database structure.
Populating is the third phase of implementation. It involves Mapping data from source to destination, extraction of source data and loading data into the Data Mart.
Accessing is the fourth step phase of implementation. It involves querying data, creating reports and charts, etc.
Managing is the final step of Data Mart implementation. It involves access to management, tuning the data for the required database and managing fresh data into the data mart.