摘要
为解决关系型数据库在大数据处理中遇到的瓶颈问题,满足企业对大数据处理的需求,提出将关系型数据库迁移到No SQL文档型数据库中。针对RDBMS中的关系模型向Mongo DB中的集合模型转换方法进行了研究,提出了表示关系间参照完整性的有向图表示模型,以及基于关系型数据模型向Mongo DB文档模型自动转换算法,实现了RDBMS中迁移数据到Mongo DB的插入算法。针对上述方案和算法,结合典型开源RDBMSMy SQL实例,对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证,实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到Mongo DB中。
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 RD- BMS-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.
出处
《计算机应用研究》
CSCD
北大核心
2017年第11期3339-3344,共6页
Application Research of Computers
基金
国家科技支撑计划资助项目(2015BAF19F02
2015BAF19F01)
