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

Optimization of Composite Plates Based on Imperialist Competitive Algorithm

Imperialist Competitive Algorithm (ICA) is a new optimization algorithm that inspired by socio-political process of imperialistic competition. In this paper an optimization methodology for the design of composite plates...

Load Balanced Routing using OSPF

Today’s Internet applications are in need of additional bandwidth. The Internet nature changes and its traffic are growing because of new applications. Initially when the file transfers dominated the internet we don’t re...

FRAUDULENT ACTIVITIES USING VIRTUAL MEETINGS

This paper investigates fraudulent and illegal activities that take place through virtual meeting systems. The first section gives an introduction to the problem. Section two describes some cases of fraudulent activity u...

SRGM with logistic-exponential Testing-effort function with change-point and Analysis of Optimal release policies based on increasing the test efficiency

Reliability is the one of the important factor of software quality. Past few decades several software reliability growth models are proposed to access the quality of the software. Main challenging task of reliability gro...

A Genetic Algorithm Optimized Decision Tree- SVM based Stock Market Trend Prediction System

Prediction of stock market trends has been an area of great interest both to researchers attempting to uncover the information hidden in the stock market data and for those who wish to profit by trading stocks. The extre...

Download PDF file
  • EP ID EP108017
  • DOI -
  • Views 104
  • 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