Research And Implementation Of Database Result Cache

Along with the continuous acceleration of the social information process, data quantity which need be dealt by a variety of applications become much bigger, so it seems especially important to improve the database access speed of the response. Result cache is a useful Query Optimization Technique for improving database response capacity. When users query database , the result cache can directly return the query result by storing query results in a cache table. Because of avoiding searches for the huge table and the time-consuming connections operations, the result cache improves SQL Query Efficiency.This paper firstly introduces the concept of the result cache, and expounds the position of the result cache in the query system. Secondly, three technologies to achieve result cache are studied: memory space management; transaction management; cache consistency management. In these studies the paper puts forwards improved algorithm for the result chache. Finally the server result cache is designed and implemented in the domestic database Oscar. It is studied deeply that the memory allocation algorithm, the memory index algorithm, the cache replacement strategy and the cache failure treatment.The paper also provides a solving scheme and a detailed design of the data consistency maintenance between the server and the client.The structure of this paper is : firstly the paper introduces the concept of the result cache, researches the result cache of ORACLE database,and makes a feasible analysis of the result cache implementation in the domestic database OSCAR;Secondly, the paper enumerates several technical problems of the result cache, and finally the algorithm and strategy to achieve the result cahce is given. Measurement results indicate that the design of the result cache is very useful for improving the performance of read-intensive workloads.