Data Marts Advantages & Disadvantages
Data Marts Advantages The implementation of data marts enable users to gain faster access to common data utilizing a technique called dimensional data modeling, which optimizes data for reports. For example, since data is prepared in common format, users with little or not training at all, can browse a data mart and obtain information as needed. Data marts can improve end user response time, as it contains raw data which allows computer systems to focus on a single task, thus, improving performance. As opposed to OLTP systems, data marts can also store historical data which enable users to analyze data trends. Moreover, data marts are not as expensive and complex as data warehouses to setup and implement because technical issues are not so difficult to resolve (www.datawarehouse.com).
Data Marts Disadvantages Alike any other system, data marts have many issues including functionality, data size, scalability, performance, data access, and consolidation. Since data marts can be broken into different departments to focus on their individual needs. This approach makes data access, consolidation, and cleansing very difficult. For instance, when a company has a data mart for each of its departments including sales, inventory, tracking, shipping, receiving, and production. Combining revenue information from each of these departments into a single data mart can be overwhelming and confusing, due to the volume of data to be analyzed (www.datawarehouse.com).
Data Warehouse Advantages Unlike, data marts, data warehouses store data in relational format to enable management to access data trends from consolidated databases containing more consistent, accurate, and subject-oriented data. Data sources are governed by business rules which define consolidation techniques, codes standardization, and data cleansing, and tracking of historical data (www.datawarehouse.com). The main purposes of these rules are to allow users to reference unified data, regardless of
Data Marts Disadvantages Alike any other system, data marts have many issues including functionality, data size, scalability, performance, data access, and consolidation. Since data marts can be broken into different departments to focus on their individual needs. This approach makes data access, consolidation, and cleansing very difficult. For instance, when a company has a data mart for each of its departments including sales, inventory, tracking, shipping, receiving, and production. Combining revenue information from each of these departments into a single data mart can be overwhelming and confusing, due to the volume of data to be analyzed (www.datawarehouse.com).
Data Warehouse Advantages Unlike, data marts, data warehouses store data in relational format to enable management to access data trends from consolidated databases containing more consistent, accurate, and subject-oriented data. Data sources are governed by business rules which define consolidation techniques, codes standardization, and data cleansing, and tracking of historical data (www.datawarehouse.com). The main purposes of these rules are to allow users to reference unified data, regardless of
References: Electronic sources retrieved on March 9, 2005 from http://www.noumenal.com/marc/marts.html http://www.datawarehouse.com/article/?articleid=3019