Improve Performance of Data Warehouse by Query Cache

Abstract

Abstract-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. 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 will study how using query cache improves performance of Data Warehouse and try to find the common problems faced. These kinds of problems are faced by Data Warehouse administrators which are minimizes response time and improves the efficiency of query in data warehouse overall, particularly when data warehouse is updated at regular interval.

Optimization Using Multicore-Processor Parallelization: A Case Study of Tax Processing System in Indonesia

“…By using cache memory to temporary save, the query result will be done because of there is the situation where the system send the same query at once or many users at the different time [17,18]. Besides doing optimization on the query, the accuracy and efficiency are important to be noticed [19].…”