Cache Associativity on the Performance of Database Systems :Problems,and Optimization Strategies
缓存关联对数据库系统性能的影响及其优化策略

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.