首页 | 本学科首页   官方微博 | 高级检索  
     

一种具有自适应机制的闪存数据库索引结构
引用本文:房俊华,王翰虎,陈梅,马丹. 一种具有自适应机制的闪存数据库索引结构[J]. 计算机应用, 2013, 33(2): 563-566. DOI: 10.3724/SP.J.1087.2013.00563
作者姓名:房俊华  王翰虎  陈梅  马丹
作者单位:1. 贵州大学 计算机科学与信息学院,贵阳 5500252. 贵州星辰科技开发有限公司,贵阳 550001
基金项目:贵阳市2010年工业科技攻关项目
摘    要:针对闪存数据库系统索引技术中基于日志更新策略存在的检索效率低、日志空间分配不合理及合并带来的高昂更新代价等问题,提出一种具有自适应机制的索引结构LM-B+TREE。LM-B+TREE将索引的更新缓冲页映射于传统B+TREE的相应节点,并根据闪存索引的读写负载及读写代价差异,动态地分配缓冲更新区,自适应地调整索引架构。实验证明LM-B+TREE能够动态地调整索引架构来适应索引的读写负载代价,在减少索引更新代价的同时,有效地提高了索引的查询性能。

关 键 词:闪存数据库  索引结构  缓冲更新  自适应机制  代价评估  
收稿时间:2012-08-20
修稿时间:2012-10-04

Index structure with self-adaptive mechanism in flash-based database system
FANG Junhua , WANG Hanhu , CHEN Mei , MA Dan. Index structure with self-adaptive mechanism in flash-based database system[J]. Journal of Computer Applications, 2013, 33(2): 563-566. DOI: 10.3724/SP.J.1087.2013.00563
Authors:FANG Junhua    WANG Hanhu    CHEN Mei    MA Dan
Affiliation:1. College of Computer Science and Information, Guizhou University, Guiyang Guizhou 550025, China2. Guizhou Stars Technology Development Company Limited, Guiyang Guizhou 550001, China
Abstract:The log-based index update mechanism in flash-based database system has following shortage: low query efficiency, expensive update cost, unreasonable space allocation and merge for the log. In order to solve these problems, a new adaptive index structure named LM-B+TREE was proposed. LM-B+TREE can map the page for index update buffer into corresponding node of traditional B+ TREE. Furthermore, according to the read/write workload and read/write overhead, LM-B+TREE can dynamically maintain the update buffer and adjust the index frame adaptively. The experimental results show that LM-B+ TREE can dynamically adjust the index structure to adapt to the read-write workload, significantly reduce the overhead of index update and improve the query performance.
Keywords:flash-based database   index structure   delayed update   self-adaptive mechanism   cost estimate
本文献已被 万方数据 等数据库收录!
点击此处可从《计算机应用》浏览原始摘要信息
点击此处可从《计算机应用》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号