| 缓存关联对数据库系统性能的影响及其优化策略 |
| |
| 引用本文： | 冯柯,陈刚,董金祥.缓存关联对数据库系统性能的影响及其优化策略[J].计算机科学,2005,32(3):79-82. |
| |
| 作者姓名： | 冯柯 陈刚 董金祥 |
| |
| 作者单位： | 浙江大学计算机科学与工程学系,杭州,310027;浙江大学计算机科学与工程学系,杭州,310027;浙江大学计算机科学与工程学系,杭州,310027 |
| |
| 基金项目： | 本文研究得到863项目(2003AA4Z3010)资助 |
| |
| 摘 要： | 研究了缓存关联对数据库系统性能的影响，并提出了一种优化策略，大大降低了数据访问时对缓存的争用。该优化技术实现简单，对已有系统改动小，已经实现并应用于开放源代码数据库系统Postgres和MySQL，以及自主开发的CoreBase数据库系统中，测试结果表明：数据库的查询速度得到了极大的提高。
|
| 关 键 词： | 缓存关联 缓存争用 热区 |
Cache Associativity on the Performance of Database Systems :Problems,and Optimization Strategies |
| |
| FENG Ke,CHEN Gang,DONG Jin-Xiang.Cache Associativity on the Performance of Database Systems :Problems,and Optimization Strategies[J].Computer Science,2005,32(3):79-82. |
| |
| Authors: | FENG Ke CHEN Gang DONG Jin-Xiang |
| |
| Affiliation: | FENG Ke,CHEN Gang,DONG Jin-Xiang Department of Computer Science and Engineering,Zhejiang University,Hangzhou 310027 |
| |
| 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. |
| |
| Keywords: | Cache associativity Conflict miss Hotspot |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
点击此处可从《计算机科学》下载全文 |
|
