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 79
- Downloads 0
STRESS ANALYSIS OF IC ENGINE PISTON FOR DIFFERENT MATERIAL AND PRESSURE LOAD USING FEA
This present work describes the stress distribution of two different aluminum alloys piston by using finite element method (FEM). The piston is designed for a single cylinder petrol engine using SOLIDWORKS 2013 software....
FUTURE GLOBAL – MEAN TEMPERATURE CHANGES
The green house problem, global-mean temperature charge. As this variable changes, all other climate variables will change in concert. At the regional level, large changes in temperature are expected. This will va...
Design of Wallace Tree Multiplier using Compressors
A multiplier is one of the key hardware blocks in most digital and high performance systems such as FIR filters, digital signal processors and microprocessors etc. With advances in technology, many researchers have trie...
AN EVOLUTIONARY COMPUTING APPROACH FOR PID OPTIMIZATION FOR AUTOMATIC VOLTAGE REGULATOR
The primary objective of reactive power control is to develop the generator excitation control system that can be obtained by using automatic voltage regulator. It maintains the generator voltage and reactive power dema...
DESIGN AND ANALYSIS OF COMPOSITE LEAF SPRING FOR LIGHT COMMERCIAL VEHICLE (TATA ACE)
Present time the main issue of automobile industry are weight reduction. The automobile industry has looking for any implementation or modification to reduce the weight of the vehicle. The suspension leaf spring i...