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

传统RDBMS向非关系型MongoDB数据模型转换与数据迁移方法研究
引用本文:曾海峰,王淑营,董钦钰. 传统RDBMS向非关系型MongoDB数据模型转换与数据迁移方法研究[J]. 计算机应用研究, 2017, 34(11)
作者姓名:曾海峰  王淑营  董钦钰
作者单位:西南交通大学信息科学与技术学院,西南交通大学信息科学与技术学院,四川宁江山川机械有限责任公司
基金项目:国家科技支撑计划资助项目(No. 2015BAF19F02、2015BAF19F01)。Foundation item(s):Project supported by The National Key Technology R D Program(No. 2015BAF19F02、2015BAF19F01)。
摘    要:为解决关系型数据库在大数据处理中遇到的瓶颈问题,满足企业对大数据处理的需求,提出将关系型数据库迁移到NoSQL文档型数据库中。针对RDBMS中的关系模型向MongoDB中的集合模型转化方法进行了研究,提出了表示关系间参照完整性的有向图表示模型,和基于关系型数据模型向MongoDB文档模型自动转化算法;实现了RDBMS中迁移数据到MongoDB的插入算法。针对上述方案和算法,结合典型开源RDBMS--MySQL实例,对上述关系有向图模型的生成、基于有向图模型的转化算法以及数据迁移算法应用验证。实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中。

关 键 词:RDBMS  NoSQL  MongoDB  关系有向图  模型转换  数据迁移
收稿时间:2017-02-06
修稿时间:2017-03-10

Research on Data Conversion and Migration Method from Traditional RDBMS to NoSQL Database MongoDB
Zeng Haifeng,WANG Shuying and Dong Qinyu. Research on Data Conversion and Migration Method from Traditional RDBMS to NoSQL Database MongoDB[J]. Application Research of Computers, 2017, 34(11)
Authors:Zeng Haifeng  WANG Shuying  Dong Qinyu
Affiliation:School of Information Science and Technology,Southwest Jiaotong University,,
Abstract:In order to solve the bottleneck problem encountered in the large data processing of relational database and satisfy the demand of large data processing, this paper propose to migrate the relational database to NoSQL document database. This paper study the set model transformation method in MongoDB for the relational model in RDBMS, and propose a directed graph representation model that expresses the referential integrity of the relationship, and automatically transforms the MongoDB document model based on the relational data model. The RDBMS Migrate data into MongoDB''s insertion algorithm. Aiming at the above scheme and algorithm, combined with the typical open source RDBMS - MySQL example, the generation of directed graph model, the transformation algorithm based on directed graph model and the application of data migration algorithm are validated. The experimental results show that the RDBMS can be smoothly migrated to MongoDB according to a certain data structure.
Keywords:RDBMS   NoSQL   MongoDB   Directed Graph of Relations   Model Conversion   Data Migration
点击此处可从《计算机应用研究》浏览原始摘要信息
点击此处可从《计算机应用研究》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

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