基于MongoDB的船舶数据库构建与数据批量迁移技术

潘明阳; 高立佳; 宋平亮; 赵丽宁

doi:10.16411/j.cnki.issn1006-7736.2016.01.008

大连海事大学学报 >

2016 , Vol. 42 >Issue 1: 39 - 44

DOI: https://doi.org/10.16411/j.cnki.issn1006-7736.2016.01.008

船舶与海洋工程

基于MongoDB的船舶数据库构建与数据批量迁移技术

潘明阳 ,
高立佳 ,
宋平亮 ,
赵丽宁

展开

(大连海事大学航海学院，辽宁大连 116026)

潘明阳*(1975-),男,博士,副教授,E-mail:panmingyang@dlmu.edu.cn.

收稿日期: 2015-08-16

修回日期: 2015-11-03

网络出版日期: 2016-03-11

基金资助

中央高校基本科研业务费专项基金资助项目（3132014309）；辽宁省教育厅科学研究一般项目（L2015063）.

收起

MongoDB based ship database construction and batch migration technology of its data

PAN Ming-yang ,
GAO Li-jia ,
SONG Ping-liang ,
ZHAO Li-ning

Expand

（Navigation College,Dalian Maritime University, Dalian 116026,China）

Received date: 2015-08-16

Revised date: 2015-11-03

Online published: 2016-03-11

Fold

摘要

基于目前最流行的一种非关系型数据库MongoDB，对非关系型的船舶数据库构建进行深入研究，包括可行性分析、数据模型和地理索引等，为海量船舶数据管理提供了新思路，并以Spring Batch批处理框架为基础设计和实现了Oracle 到MongoDB的数据批量迁移程序，为关系型数据库到非关系型数据库的过渡提供了高效灵活且稳定的解决方案.

关键词： MongoDB; 船舶数据库; Spring Batch; 数据迁移

本文引用格式

潘明阳 , 高立佳 , 宋平亮 , 赵丽宁 . 基于MongoDB的船舶数据库构建与数据批量迁移技术[J]. 大连海事大学学报, 2016 , 42(1) : 39 -44 . DOI: 10.16411/j.cnki.issn1006-7736.2016.01.008

Abstract

Based on MongoDB, one of the most popular NoSQL databases, the construction of NoSQL ship database was studied, including feasibility analysis, data models and geospatial indexes, etc, which provided a new solution for ship data management. Furthermore, the ship data migration program from Oracle database to MongoDB database was designed and implemented based on the Spring Batch framework, which provided a stable and flexible solution for the transition from SQL to NoSQL ship database.

Key words： MongoDB; ship database; Spring Batch; data migration

参考文献

[1]王树茂. 船舶自动识别系统(AIS)［J］. 中国海事, 2010(5):15-16.
WANG Shumao. Ship’s automatic identification system (AIS). China Maritime Safety, 2010(5): 15-16. (in Chinese)
[2]CHANG F, DEAN J, SANJAY G, et al. Bigtable: a distributed storage system for structured data［C］// OSDI ’06: 7th USENIX Symposium on Operating Systems Design and Implementation. Seattle: USENIX Association, 2006: 205-218.
[3]DECANDIA G, HASTORUN D, JAMPANI M, et al. Dynamo: amazon’s highly available key-value store［C］// Proceedings of the 21st ACM Symposium on Operating Systems Principles. 2007: 205-220.
[4]BANKER K. MongoDB in action［M］. Greenwich, CT: Manning Publications Co., 2011.
[5]吴飞. 基于MongoDB的LBS数据管理系统关键技术研究［J］. 测绘通报, 2014(7): 121-124.
WU Fei. Key technology sesearch of LBS data management system based on MongoDB［J］. Bulletin of Surveying and Mapping, 2014(7): 121-124. (in Chinese)
[6]Leaf in the wild: scaling China’s largest car service App with MongoDB［EB/OL］. ［2014-12-12］ .https://www.mongodb.com/blog/post/leaf-wild-scaling-greater-chinas-largestcar-service-app-mongodb.
[7]每天200亿次查询– MongoDB在奇虎360 ［EB/OL］. ［2015-03-11］.http://www.mongoing.com/archives/715.
[8]毛应爽. EXCEL到MongoDB数据迁移解决方案［J］. 信息通信, 2013(7): 87-88.
MAO Ying-shuang.Data migration solution from Excel to MongoDB［J］. Information & Communications, 2013(7): 87-88. (in Chinese)
[9]赵艳妮,郭华磊. 基于XML的数据迁移技术在信息系统升级中的研究与实现［J］. 计算机应用与软件, 2014,31(12): 52-54.
ZHAO Yan-ni, GUO Hua-lei. On XML-based data migration technology in information system upgrade and its implementation［J］. Computer Applications and Software, 2014, 31(12): 52-54. (in Chinese)
[10]黄伟钗. MongoDB的形式化模型和研究［D］.广州:中山大学, 2013.
HUANG Wei-cha. Towards formalization of MongoDB［D］.Guangzhou: Sun Yat-sen University, 2013. (in Chinese)
[11]杨寒冰,赵龙,贾金原. HBase数据库迁移工具的设计与实现［J］. 计算机科学与探索, 2013,7(3): 236-246.
YANG Han-bing, ZHAO Long, JIA Jin-yuan. Design and realization of HBase migration tool［J］. Journal of Frontiers of Computer Science and Technology, 2013, 7(3): 236-246. (in Chinese)
[12]王博然. PostgreSQL与MongoDB的数据迁移与应用适配［J］. 北京工业职业技术学院学报, 2013,12(2): 26-30.
WANG Bo-ran. Data migration and application adaptation between PostgreSQL and MongoDB［J］. Journal of Beijing Polytechnic College, 2013,12(2): 26-30. (in Chinese)

Options

文章导航

模态框（Modal）标题

摘要

本文引用格式

Abstract

参考文献