What is a Data Mart
a Data mart is defined as a subset of data form a data warehouse (but not only) of an organization that is limited to a specific business unit or group of users. It is a subject-oriented database and is also known as High-Performance Query Structures (HPQS).
If implemented correctly, Datamart allow a faster easier access to the data. However this depends on the particular data model that is implemented.
Advantages
- Data marts contain only a subset of the organization’s data. This Data is valuable to a specific group of people in an organization.
- Data marts are cost-effective as compared to a data warehouses, which can take high costs to build.
- Data Mart allows faster and better and easier access of Data. It accelerate the business processes.
- It contains historical data which enables the analyst to determine data trends.
- Data marts promote security as the access can be granular. HR people will not need access to Marketing Data marts for example
Disadvantages
- Many a times enterprises create too many disparate and unrelated data marts without much benefit. It can become a big hurdle to maintain.
- Data Mart cannot provide company-wide data analysis as their data set is limited.
- They are most cost effective than data warehouses, but are also an added cost on the top of the data warehouse.
Awesome post! Keep up the great work! 🙂
Great content! Super high-quality! Keep it up! 🙂