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 74
- Downloads 0
Global Climatic Variations
Globally changing climatic conditions have shown direct and indirect impact worldwide. In Indian continent drast changes have been recorded in hydrological conditions, Himalayan glaciers, agriculture production and wate...
dghdfhIntegrated Approach towards Grey Water Management
India is facing a water crisis and by 2025 it is estimated that India's population will be suffering from severe water scarcity. With increased population growth and development, there is a need to critically look...
DESIGN OF MULTIBAND MICROSTRIP PATCH ANTENNA USING SPLIT RING RESONATOR FOR APPLICATION IN C, X AND K U BAND
[b]In this work three different microstrip antenna designs are investigated. The first design is a simple microstrip patch antenna. The second design is a multiband antenna and consists of the first structure mic...
BULK ARRIVAL RETRIAL QUEUE WITH FLUCTUATING MODES OF SERVICE, IMMEDIATE FEEDBACK, SERVER VACATION AND ORBITAL SEARCH
This paper deals with single server retrial queue with fluctuating modes of service. Server provides M modes of service with different service rates. At the arrival epoch of a batch, if the server is idle, the...
A STUDY ON THE 3-DIM. EIGENMODE OF THE RECTANGULAR RESONANT CAVITY BY FEM
FEM has been applied to obtain the 3-dim. eigenmode of the rectangular resonant cavity. The vector Helmholtz equation has been analysed for the resonant field strength in homogeneous media. An eigen-equation has b...