[1]叶云霜,林伟华,刘福江,等.关系数据库中海量要素存储的分区优化研究[J].计算机技术与发展,2020,30(01):167-173.[doi:10. 3969 / j. issn. 1673-629X. 2020. 01. 030]
　YE Yun-shuang,LIN Wei-hua,LIU Fu-jiang,et al.Research on Partition Optimization of Massive Element Storage in Relational Database[J].Computer Technology and Development,2020,30(01):167-173.[doi:10. 3969 / j. issn. 1673-629X. 2020. 01. 030]
点击复制

关系数据库中海量要素存储的分区优化研究()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
30
期数:
2020年01期
页码:
167-173
栏目:
应用开发研究
出版日期:
2020-01-10

文章信息/Info

Title:
Research on Partition Optimization of Massive Element Storage in Relational Database
文章编号:
1673-629X(2020)01-0167-07
作者:
叶云霜; 林伟华; 刘福江; 董晓莹
中国地质大学(武汉) 信息工程学院,湖北 武汉 430000
Author(s):
YE Yun-shuang; LIN Wei-hua; LIU Fu-jiang; DONG Xiao-ying
School of Information Engineering,China University of Geosciences,Wuhan 430000,China
关键词:
海量要素图层; 关系数据库; 分区; 存储; 索引
Keywords:
massive feature layer; relational database; partition; storage; index
分类号:
TP391.9
DOI:
10. 3969 / j. issn. 1673-629X. 2020. 01. 030
摘要:
目前,关系数据库中的分区技术应用相当广泛,但是用分区策略管理海量要素图层数据的存储与索引没有比较系统的技术方法。采用不同管理方式、不同分区粒度、不同索引方式及其组合的分区技术来系统地管理海量空间图层数据,进一步研究了不同的分区粒度及索引方式对查询效率的影响,并通过实验验证了关系数据库中的分区技术对海量要素图层数据的存储与管理具有优化作用。 结果表明,在不使用分区键作为查询条件时,分区粒度越大查询效率越高;使用分区键作为查询条件时,本地分区索引查询效率更高等。 利用合理的分区方案使得海量要素图层数据存储和管理得以优化,对矢量大数据的存储和管理研究具有重要意义,为更好地应用分区技术来解决实际遇到的存储与检索效率问题提供决策支持。
Abstract:
At present,the partitioning technology in relational database is widely used,but there is no systematic technical method for managing the storage and indexing of massive feature layer data by partitioning strategy. The partitioning techniques of different management methods,different partition granularities,different indexing methods and their combinations? are used to systematically manage massive spatial layer data,and the effects of different partition granularity and indexing methods on query efficiency are further studied,and the relationship is verified by experiments. The partitioning technology in the database optimizes the storage and managementof massive feature layer data. The results show that the query efficiency is higher when the partition key is not used as the query condition. When the partition key is used as the query condition,the local partition index query is more efficient. Using reasonable partitioning schemes to optimize the storage and management of massive feature layer data is of great significance for the storage and management of vector big data,and provides a decision for better application of partitioning technology to solve the storage and retrieval efficiency problems actually encountered.

相似文献/References:

[1]李斌勇 李庆.基于NHibernate的ORM映射机制研究[J].计算机技术与发展,2009,(07):32.
　LI Bin-yong,LI Qing.Research on ORM Mapping Mechanism Based on NHibernate[J].Computer Technology and Development,2009,(01):32.
[2]洪伟 吴云 周国祥.基于树形结构的汽车试验集成系统数据库设计[J].计算机技术与发展,2008,(02):177.
　HONG Wei,WU Yun,ZHOU Guo-xiang.Design for Automobile Test Integration System Database Based on Tree- Like Structure[J].Computer Technology and Development,2008,(01):177.
[3]张华兵 杨路明 谢东 王佳宜.非一致性数据库的多关系聚集查询重写[J].计算机技术与发展,2008,(04):38.
　ZHANG Hua-bing,YANG Lu-ming,XIE Dong,et al.Multi- Relations Aggregation Query Rewritings in Inconsistent Databases[J].Computer Technology and Development,2008,(01):38.
[4]黄勇 刘锋.基于SQL的多值多层关联规则挖掘[J].计算机技术与发展,2008,(06):101.
　HUANG Yong,LIU Feng.SQL - Based Multi - Value Multilayer Mining Association Rules Excavation[J].Computer Technology and Development,2008,(01):101.
[5]史立军 侯红 祁方民.基于Schema的XML文档到关系数据库的转换[J].计算机技术与发展,2008,(10):71.
　SHI Li-jun,HOU Hong,QI Fang-min.Transformation from XML File Based on Schema to Relational Database[J].Computer Technology and Development,2008,(01):71.
[6]曹卫.基于XML的空间元数据系统的思考[J].计算机技术与发展,2010,(07):32.
　CAO Wei.The Thinking of Spatial Metadata System Based on XML[J].Computer Technology and Development,2010,(01):32.
[7]刘翔 程文青 刘威.一种从XML建立关系数据库的模式映射方法[J].计算机技术与发展,2007,(02):1.
　LIU Xiang,CHENG Wen-qing,LIU Wei.Method of Constructing Relational Database from XML Based on Schema- Mapping[J].Computer Technology and Development,2007,(01):1.
[8]陶皖 姚红燕.OWL本体关系数据库存储模式设计[J].计算机技术与发展,2007,(02):111.
　TAO Wan,YAO Hong-yan.Design of OWL Ontology Storage Schema in Relational Database[J].Computer Technology and Development,2007,(01):111.
[9]孟芝佳 董逸生.基于移动数据库SwiftDB的XML数据管理[J].计算机技术与发展,2007,(02):115.
　MENG Zhi-jia,BONG Yi-sheng.XML Management Based on Mobile Database SwiftDB[J].Computer Technology and Development,2007,(01):115.
[10]吕云屏 吴洁.主题地图在关系数据库中的应用研究[J].计算机技术与发展,2006,(02):87.
　LV Yun-ping,WU Jie.Application and Research of Topic Maps in Relational Database[J].Computer Technology and Development,2006,(01):87.

更新日期/Last Update: 2020-01-10