期刊文献+

基于内存数据库的索引算法研究 被引量:3

Research on memory database index algorithm
下载PDF
导出
摘要 随着内存价格的不断走低,数据库中的数据在内存中运行已经具有了一定的可行性。内存数据库有着比磁盘数据库无法比拟的优势,那就是在实时和高并发的应用上所展现的能力。因此基于磁盘的索引算法已经不能适应内存数据库的要求,有必要探索出一种新的索引算法。文中从当今研究比较热门的敏感索引树出发,分析了CSB+索引树的优缺点及适用情形,设计出了一种改进CSB+树的查询算法,得出改进后的CSB+树对TLB失配具有显著的改善效果,提高了内存数据库的性能。 With the low price of memory,the data in the database is fully feasible,and the ability of memory database in real-time and high concurrency is not suitable for disk database. Therefore,a new algorithm is proposed. This paper analyzes the advantages and disadvantages of CSB + index tree and its application,and designs a new algorithm to improve the CSB + tree,and gives out the comparison of CSB + tree and TLB tree. The improved CSB + tree has a significant effect on TLB mismatch,and improves the performance of the memory database.
出处 《信息技术》 2016年第11期139-142,共4页 Information Technology
关键词 内存数据库 缓存 CSB+树 TLB 索引 memory database cache CSB + tree TLB index
  • 相关文献

参考文献7

二级参考文献23

  • 1杨武军,张继荣,屈军锁.内存数据库技术综述[J].西安邮电学院学报,2005,10(3):95-99. 被引量:39
  • 2Ailamaki A, DeWitt D J, Hill M D, Wood D A. DBMSs on a modern processor: Where does time go? In Proc. VLDB Conference, Edinburgh, UK, Sept. 7-10, 1999, pp.266- 277.
  • 3Barroso L A, Gharachorloo K, Bugnion E D. Memory system characterization of commercial workloads. In Proc. the 25th ISCA, Barcelona, Spain, June 27-July 1, 1998, pp.3-14.
  • 4Keeton K, Patterson D A, He Y Q, Raphael R C, Baker W E. Performance characterization of a Quad Pentium Pro SMP using OLTP workloads. In Proc. the 25th ISCA, Barcelona, Spain, June 27-July 1, 1998, pp.15-26.
  • 5Becker M, Mancheril N, Okamoto S. DBMSs on a modern processor: "Where does time go?" revisited. Technical Report, Carnegie Mellon University, USA, 2004.
  • 6Rao J, Ross K A. Cache conscious indexing for decisionsupport in main memory. In Proe. VLDB Conference, Edinburgh, UK, Sept. 7 10, 1999, pp.78-89.
  • 7Hennessy J L, Patterson D A. Computer Architecture: A Quantitative Approach. Morgan Kaufmann Publishers Inc., 2002.
  • 8Boncz P, Manegold S, Kersten M L. Database architecture optimized for the new bottleneck: Memory access. In Proc. VLDB Conference, Edinburgh, UK, Sept. 7-10, 1999, pp.54- 65.
  • 9Rao J, Ross K A. Making B^+-trees cache conscious in main memory. In Proc. ACM SIGMOD, Dallas, USA, May 16-18, 2000, pp.475-486.
  • 10Shatdal A, Kant C, Naughton J F. Cache conscious algorithms for relational query processing. In Proc. VLDB Conference, Santiago, Chile, Sept. 12 15, 1994, pp.510-521.

共引文献218

同被引文献17

引证文献3

二级引证文献17

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部