一种RDBMS到MongoDB数据迁移方法

A Data Migration Method for RDBMS to MongoDB

随着物联网、云计算技术出现,大数据广泛存在,关系数据库处理海量数据力不从心,无法满足高并发性、高吞吐量和低延时等,基于No SQL技术的Mongo DB数据库凭借高并发、非结构化存储和高可拓展性等优点得到青睐。提出一种把关系数据库表映射为集合、记录映射为文档、表列属性映射为字段,"父表-子表"连接采用文档嵌套结构将子表数据直接嵌入到父表中,实现数据从关系数据库平滑过渡到Mongo DB数据库的数据迁移方法。实验结果表明,随着数据规模不断增大,该方法查询效率显著提高,对关系数据库向No SQL数据库数据迁移具有参考性。

As the Internet of things, cloud computing, big data is widespread, relational database handle huge amounts of data and cannot meet the high concurrency, high throughput and low delay, etc., the MongoDB database with high concurrency, unstructured storage and the advantages of high scalable based on the NoSQL technology. Proposes a relational database table mapping collection, record mapping document, table column properties mapping field, parent table-child table document nested structure is used to connect the child table data directly embedded into the parent table method, implement the data from a relational database is smooth transition into the mongo database data mi- gration method. The experimental results show that with the increasing of data size, the query efficiency is improved significantly, there is a reference to the data migration of relational database to NoSQL database.