A Review on Data Warehouse Management
Journal Title: International Journal of Engineering Sciences & Research Technology - Year 30, Vol 3, Issue 3
Abstract
Data warehouse management is a crucial part of industry and business that have been adopted and put into practice with increased complexity of managing pools of data. The architectural layout of data warehousing is composed of a centralized warehouse from which views are generated for needy users. The convention in this case is that the warehouse receives an information injection from individual distributed databases which may as well be not related to the warehouse but hold the raw data needed to justify the existence of warehouse. However, data warehouse management is a relatively complex procedure that needs data updates from distributed databases. The complexity of this procedure relates to anomaly-prone informational transaction between the data source end and the materialized view end. This description supports the critical requirements of data warehouses which are accuracy and timeliness. This review dwells on the assessment of data warehouse literature to verify the dominant strategy employed in data warehouse management and the trade-offs involved. For this purpose various data warehouse management related articles were selected and carefully reviewed. The findings revealed a favor towards Immediate Incremental Management (IIM) of warehouse against Deferred Incremental Management (DIM). It is observed that system availability which constitutes accurate views and real-time updating was the base determining factor. Deferred Incremental Management has been the conventional way but with an increase in data volume that requires a gigabyte transaction rate that defines contemporary business and industry this updating mechanism is quite unsuitable and strips data warehouse management its contextual meaning.
Authors and Affiliations
Umair Rasheed*
Keywords
Related Articles
- EP ID EP95426
- DOI -
- Views 78
- Downloads 0
EXTRINSICALLY CARBON FIBER REINFORCED POLYMER/ALUMINUM FOAM SANDWICH COMPOSITES
The design and the requirements within the constructive development of technical systems cause a connection of different material properties and the combination of different production processes to novel and innovative...
SCHOOL PURPOSE AMPLIFIER
The world over the decade's has made considerable advancement in automation ,automation is employed in home ,industries, commercial & educational sector. In this work ,a microcontroller base automatic school bell ti...
Structural and Spectral Analysis Host Bi2O3-B2O3-LiF and RE3+(Ho3+ or Pr3+): Bi2O3- B2O3-LiF Glasses
Bismuth borate glasses in the composition of 20Bi2O3-50B2O3-30LiF (BiBLF) have been prepared by using conventional melt quenching method. Thermal analysis (Tg-DTA) structural (XRD, FTIR and Raman), SEM micro graph and...
IMPACT OF BRAND LOYALTY ON RETAIL BUYING BEHAVIOUR IN HYDERABAD
Brand loyalty is the consumer’s emotionally -charged decision to purchase a specific brand again and again. Recent studies focused on loyalty concept in goods as well as services sector. Of late brand loyalty is receivi...
CONVERSION OF WASTE PLASTICS INTO ALTERNATIVE FUEL
Plastic waste is regarded as potentially economy source of chemicals and energy. Lots of us have come across a variety of products that use plastic materials today. As a result of the increasing level of private consumpt...