Research On Data Conversion And Migration Method From Traditional RDBMS To NoSQL Database MongoDB

In the past few years, the relational database provides a complete and mature management functions, but with the Web2.0 and large data applications continue to land, the growing Internet applications require massive and multi-type data for effective management, At the same time the system performance, scalability, consistency, etc. have different needs. The traditional relational database management system (RDBMS) in the processing of massive data seems powerless. Compared with the traditional RDBMS, the non-relational database(No-only SQL, NoSQL) represented by MongoDB, Redis, CouchDB and so on has the advantages of strong expansibility, high flexibility and good performance in dealing with massive data is favored by the enterprise.Many of the current applications are built on the RDBMS application, with NoSQL theory and application becoming mature, many companies began to consider the data stored in the RDBMS to the NoSQL database, or part of the large and non-structural data to store in the NoSQL database, which uses a relational and non-relational hybrid architecture.In this paper,with the requirements of RDBMS application to the document-oriented NoSQL application migration and hybrid architecture application , the relationship between RDBMS to MongoDB in the collection of conversion methods were studied, combined with MongoDB in the relationship between the referential integrity of the proposed method to refer to the relationship between the reference integrity And the establishment of the relational data model based on the directed graph model to the MongoDB document model to provide automatic support for the automatic conversion of the MongoDB data schema for the traditional RDBMS data model. The data for the MySQL is applied to the MongoDB application Migration algorithm, proposed a log-based traditional MySQL to MongoDB data migration program, to achieve the RDBMS to MongoDB synchronization algorithm. Aiming at the above scheme and algorithm, combining with the typical open source RDBMS - MySQL example, the MySQL to MongoDB data migration adapter is designed and developed. The generation of the directed graph model, the conversion algorithm based on the directed graph model and the data migration algorithm are validated, MySQL to MongoDB migration and data synchronization methods were implemented and verified.