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 ALTO systems, data marts can also store satirical 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. Authoresses. 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 fisticuff.
For instance, when a company has a data mart for each of its departments including sales, inventory, tracking, shipping, receiving, and production. Combining revenue intimation from each oftenest departments into a single data mart can be overwhelming and confusing, due to the volume of data to be analyzed (haberdasheries. 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 (amateurishness. Com). The main purposes of these rules are to allow users to reference unified data, regardless Of their source and protecting production data from query drains, as data is stored in separated systems dedicated to specific tasks including retrieving data from production sources at predictable time intervals (womanlier. Mom). For example, sales information containing customers’ Ames is cleansed and integrated across systems by creating a standard master list from the sources, This technique can enable users to utilize the data warehouse master list, as the single source for data marts because the DO is the only active centralized source of commonly updated information O. Watercourse’s. Com).
Data Warehouse Disadvantages Despite the many advantages offered by DO, it is a very expensive system to implement because it concentrates on data modeling and management, instead of the users’ needs, As a result, DO requires more resources, scarce support lolls, and time to implement because maintenance and support are ongoing in order to keep up with changing business conditions.