主存数据库索引机制及其优化研究

Research on Main-Memory Database Index Mechanism and its Optimization

本文对主存数据库索引机制进行了深入研究,对Cache敏感型索引结构以及采用预取等方法提高Cache命中率的主存数据库索引机制进行了分析,讨论了当代计算机的硬件特性对提高主存数据库索引性能的影响以及索引性能的测试方法,指出可以根据主存数据库操作的类型和CPU的硬件参数对主存数据库索引机制进行配置和优化。

The index mechanism for MDB is researched in the paper. Cache-conscious index structures and those index structures adopting prefetching method are analysed. The influence of new hardware on MMDBs＇ indices is also discussed. The index performance evaluation methods are also introduced. A point of view is presented that a main memory database index mechanism should be configured and optimized according to the database operations and CPU parameters.