Cache Associativity on the Performance of Database Systems :Problems,and Optimization Strategies

FENG Ke,CHEN Gang,DONG Jin-Xiang
DOI: https://doi.org/10.3969/j.issn.1002-137X.2005.03.021
2005-01-01
Computer Science
Abstract:In this paper,we studied the impact of cache associativity on the performance of database systems,and pre- sented a new optimization technique,which can reduce the cache conflict miss during the data access significantly. This technique is very simple,and requires only a trivial modification on current database systems. We have already implemented this technique in Postgres, MySQL, two famous open-source database systems, and also CoreBase, a database system developed by ourselves. Experiment results have shown that,the query performance of all above sys- tems were improved greatly.
What problem does this paper attempt to address?