Ideal Strategy to Improve Datawarehouse Performance
Journal Title: International Journal on Computer Science and Engineering - Year 2010, Vol 2, Issue 2
Abstract
Data warehouse is set up for the benefits of business analysts and executives across all functional areas. The primary goal of data warehouse is to free the information locked up in the operational database so that decision makers and business analyst can make queries, analysis and planning regardless of the data changes in operational database. Data analysis in a large database requires some innovative techniques; there should be some new methods and procedures to look at the data with different angles. While executing adhoc queries over a large database degrade the query performance at considerable level because query will have to go through from large volume of data after making lot of joins. Moreover, as the number of queries is large, therefore, in certain cases there is reasonable probability that same query submitted by the one or multiple users at different times. Each time when query is executed, all the data of warehouse is analyzed to generate the result of that query. In this paper we purpose an ideal approach which definitely minimizes response time and improves the efficiency of data warehouse overall, particularly when data warehouse is updated at regular interval. This approach has been validated by Formal Method.
Authors and Affiliations
Fahad Sultan , Dr. Abdul Aziz
Keywords
Related Articles
- EP ID EP108017
- DOI -
- Views 109
- Downloads 0
Performance and Evaluation of IEEE 802.11e using QUALNET
IEEE 802.11 MAC (Medium Access Control) algorithms is unable to support modern multimedia applications which require certain level of quality of service (QoS) guarantees in terms of consistent, in time and reliable data...
Evaluation of Next Generation Networks
Abstract—Next Generation Networks have a major impact on existing communications technology. NGN allows the convergence of multiple applications to run on the same network;consist of voice, data and video and other new m...
Analyzing the Critical Issues of Mobile Users in Cloud Computing
Cloud computing has recently emerged as a new paradigm for hosting and delivering services over the Internet. Mobile Cloud Computing is widely accepted as a concept that can significantly improve the user experience when...
Restoration of Normal Frequency Affected by Small Load Variations Through HVDC Link Using Neuro-Fuzzy Approach
HVDC power transmission is coming up with merits to replace the EHV-AC systems. The controller inverter operation can successfully regulate the power in HVDC link leading to fulfillment of power demand in A.C. networks c...
A Heuristic Approach to the Disease Diagnose System Using Machine Learning Algorithms
Abstract--The paper deals with the concepts of expert system and data mining belongs to the Artificial Intelligence fields. The main task of expert system is to ratiocination, while the machine learning algorithm is to f...