What is data warehouse and data mart?
Data marts contain repositories of summarized data collected for analysis on a specific section or unit within an organization, for example, the sales department. A data warehouse is a large centralized repository of data that contains information from many sources within an organization.
A Data Warehouse is a blend of technologies and components which allows the strategic use of data. A data mart is simple form of a Data Warehouse. It is focused on a single subject. The data in Data Warehouse assembled from multiple sources to provide accurate and timely information.
What is data mart and its types?
Three basic types of data marts are dependent, independent, and hybrid. The categorization is based primarily on the data source that feeds the data mart. Dependent data marts draw data from a central data warehouse that has already been created.
Why data mart is required?
A dependent data mart allows sourcing organization’s data from a single Data Warehouse. It offers the benefit of centralization. … Either where a user can access both the data mart and data warehouse, depending on need, or where access is limited only to the data mart
Components of a Data Warehouse
- Overall Architecture. …
- Data Warehouse Database. …
- Sourcing, Acquisition, Cleanup and Transformation Tools. …
- Meta data. …
- Access Tools. …
- Data Marts. …
- Data Warehouse Administration and Management. …
- Information Delivery System.
So, even if you have a warehouse you don’t have to use data marts. Equally, it is possible to create marts without a warehouse. You can put the data from a particular system, a finance system for example, into a data mart and structure the data for analytical purposes.
