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

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.

Cite this article

PAN Ming-yang , GAO Li-jia , SONG Ping-liang , ZHAO Li-ning . MongoDB based ship database construction and batch migration technology of its data[J]. Journal of Dalian Maritime University, 2016 , 42(1) : 39 -44 . DOI: 10.16411/j.cnki.issn1006-7736.2016.01.008

References

[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)
Outlines

/