传统RDBMS向非关系型MongoDB数据模型转换与数据迁移方法研究

摘要

为解决关系型数据库在大数据处理中遇到的瓶颈问题,满足企业对大数据处理的需求,提出将关系型数据库迁移到NoSQL文档型数据库中.针对RDBMS中的关系模型向MongoDB中的集合模型转换方法进行了研究,提出了表示关系间参照完整性的有向图表示模型,以及基于关系型数据模型向MongoDB文档模型自动转换算法,实现了RDBMS中迁移数据到MongoDB的插入算法.针对上述方案和算法,结合典型开源RDBMS-MySQL实例,对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证,实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中.%In order to solve the bottleneck problem encountered in the large data processing of relational database and satisfy the demand of large data processing for enterprises,this paper proposed a method that migrated the relational database to NoSQL document database.It studied the set model transformation method in MongoDB for the relational model in RDBMS,and proposed a directed graph representation model that expressed the referential integrity of the relationship,and automatically transformed the MongoDB document model based on the relational data model.It realized the insertion algorithm that the RDBMS migrated data into MongoDB's.Aiming at the above scheme and algorithm,combined with the typical open source RDBMS-MySQL example,this paper validated the generation of directed graph model,the transformation algorithm based on directed graph model and the application of data migration algorithm.The experimental results show that the RDBMS can be smoothly migrated to MongoDB according to a certain data structure.