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 113
- Downloads 0
Multimodal Authentication For High End Security
In earlier days Traditional authentication method in computer systems are based on knowledge and token based. Unfortunately lot of drawbacks are in these systems. Passwords often be forgotten, disclosed or changed. A rel...
AN IMPROVED LOW COMPLEX SPATIALLY SCALABLE ACC-DCT BASED VIDEO COMPRESSION METHOD
In this paper, we propose a low complex Scalable ACC-DCT based video compression approach which tends to hard exploit the pertinent temporal redundancy in the video frames to improve compression efficiency with less proc...
Efficient Global Programming Model for Discriminant Analysis
Conventional statistical analysis includes the capacity to systematically assign individuals to groups. We suggest alternative assignment procedures, utilizing a set of interrelated goal programming formulations. This pa...
Trust Worthy Architecture Implementation for Mobile Ad hoc Networks
A mobile ad hoc network is a wireless communication network that does not rely on a fixed infrastructure and is lack of any centralized control. The wireless and distributed nature of mobile ad hoc networks poses greater...
An Efficient Method for Digital Image Watermarking Based on PN Sequences
In the recent times, the rapid and extensive growth in Internet technology is creating a pressing need to develop several newer techniques to protect copyright, ownership, authentication and content integrity of digital...