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

Word Disambiguation in Web Search

Internet is huge like a sea as the amount of information is growing rapidly on WEB. Whenever user searches something on Internet the Search Engine provides an incredible amount of information that increases the complexit...

Encoding And Decoding of a Message in the Implementation of Elliptic Curve Cryptography using Koblitz’s Method

Elliptic Curve Cryptography recently gained a lot of attention in industry. The principal attraction of ECC compared to RSA is that it offers equal security for a smaller bit size, thereby educing processing overhead. E...

An Ellipsoidal 3D Shape Representation and Wavelet Transform Feature Descriptor for 3D Shape Retrieval

For the year of past most three-dimensional objects are represented and mapped with spherical function. Since the mapping preserves important criteria such as geometrical information of a 3D object, the representation of...

Fault Detection of Reachability Testing with Game Theoretic Approach

This paper presents a game theoretic approach to fault detection of reachability testing. Physical systems are susceptible to fault at any time. Due to this reason the problem of determining and reacting to fault detecti...

Generalisation of RSA Scheme using fundamental groups and ZKIP

We address the problem of computation involved in RSA algorithm namely exponentiation under modulo arithmetic and various mathematical and timing attacks in RSA. The computation is made easy and quick by assigning elemen...

Download PDF file
  • EP ID EP108017
  • DOI -
  • Views 115
  • Downloads 0

How To Cite

Fahad Sultan, Dr. Abdul Aziz (2010). Ideal Strategy to Improve Datawarehouse Performance. International Journal on Computer Science and Engineering, 2(2), 409-415. https://europub.co.uk/articles/-A-108017