Adaptive Cache for Database Query

QIU Lin-feng,CAO Xue-cheng,BAI Wen-yang
DOI: https://doi.org/10.3778/j.issn.1002-8331.2008.22.047
2008-01-01
Computer Engineering and Applications Journal
Abstract:In tradition,databases manage their caches in a relatively mechanical way and the cache can’t tune itself in dynamic environments.Semantic caching can make the database understand the query and provide the information needed in the dynamic tuning.Query cache is a kind of the semantic cache,between the SQL parser and the query executor.This paper does some research on the self-management of the database query cache,in order to improve the database performance.First some concepts of the database cache and the autonomic computing are introduced.Then,the formal definition of the query cache and the adaptive model are given.The experiment is done based on MySQL and the result is obvious.
What problem does this paper attempt to address?