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 119
- Downloads 0
On the Security of Image Encoding Based on Fractal Functions
The information age brings some unique challenges to society. New technology and new applications bring new threats and force us to invent new protection mechanisms. So every few years, computer security needs to reinven...
Simulator for Software Project Reliability Estimation
Several models are there for software development processes, each describing approaches to a variety of tasks or activities that take place during the process. Without project management, software projects can easily be...
AGE CLASSIFICATIONS BASED ON SECOND ORDER IMAGE COMPRESSED AND FUZZY REDUCED GREY LEVEL (SICFRG) MODEL
One of the most fundamental issues in image classification and recognition are how to characterize images using derived features. Many texture classification and recognition problems in the literature usually require the...
Effect of Obstacles in the formation of FoV based Clusters in Wireless Multimedia Sensor Network
Wireless multimedia sensor network (WMSN) uses multimedia nodes to sense the area that are uncorrelated to the areas sensed by the neighboring sensors. Because of the extensive amount of data produced in wireless multime...
Literature Review on Patient Scheduling Techniques
Patients need to undergo several checkups, tests, surgery and treatments according to their illness. This paper describes the challenges of patient scheduling and patient scheduling techniques. An efficient scheduling te...