Improve Query Performance of Data Warehouse with MYSQL Query Cache

Authors

Deepika Jain, Aruna Jain
Department of Computer Science, University of Delhi, India.

Abstract

Data Warehouse is the process of storing data from different sources at one place and analyzed data for decision making. Information is extracted from the Data Warehouse through a query. When the query is executed, all the data organized in the Data Warehouse is analyzed to produce the same result. In this paper, we are analyzing the efficiency and performance of Data Warehouse using MYSQL Query Cache technique on SQL SELECT statement. With query cache we don’t have to repeatedly analyze all the data of Data Warehouse while executing the same query again and again. This approach definitely reduces the response time of query execution and improves the efficiency and performance of the database in Data Warehouse, particularly when Data Warehouse is updated at regular interval.