基于B+树的电力大数据混合索引设计分析  

Design and analysis of hybrid index of power big data based on B+tree

作　　者：张小陆 ZHANG Xiaolu(Information Center of Guangdong Power Grid Co.,Ltd.,Guangzhou 510300,China)

机构地区：[1]广东电网有限责任公司信息中心,广东广州510300

出　　处：《电子设计工程》2020年第22期7-10,15,共5页Electronic Design Engineering

基　　金：国家重点研发计划项目(2017YFB0903504)。

摘　　要：针对大规模数据检索查询效率较低的问题,提出了基于B+树的电力大数据混合索引结构,使用层次化混合索引思想,划分数据集中数据属性与属性值,实现索引并行化,使数据索引创建时间与检索速度得到提高。首先,对B+树数据库索引结构进行分析,研究B+树的关系表,分析B+树的索引效果。之后,分析B+树的电力大数据混合索引的设计思想和原理,通过设计思想设计混合索引的结构。最后,对混合索引的性能进行分析。分析结果表明,该文所设计基于B+树的数据混合索引方法能够满足用户实际需求,提高索引效率。In view of the low efficiency of large⁃scale data retrieval,a hybrid index structure of electric power big data based on B+tree is proposed.Using the idea of hierarchical hybrid index,data attributes and attribute values are divided into data sets,and index parallelism is realized,so that the creation time and retrieval speed of data index are improved.Firstly,the index structure of B+tree database is analyzed,the relational table of B+tree is studied,and the index effect of B+tree is analyzed.Then,the design idea and principle of hybrid index of power big data based on B+tree are analyzed,and the structure of hybrid index is designed by the design idea.Finally,the performance of hybrid index is analyzed.The analysis results show that the hybrid index method based on B+tree designed in this paper can meet the actual needs of users and improve the index efficiency.

关 键 词：数据检索 电力大数据 混合索引 B+树 

分 类 号：TN91[电子电信—通信与信息系统]