Abstract
In the Internet of Things (IoT) area, the increase of data leads to the "Big data'' problem. The traditional relational database (RDB) is not being able to deal with processing big data. In contrast, the Not only SQL (NoSQL) database was created to deal with big data problems. Therefore, most organizations need to convert their data stored in RDB systems into NoSQL using flexible models and processes. Most research into the conversion of RDBs into newer database systems has concentrated on schemata transformation, RDB data publishing, whereas other little work focuses on data migration. This paper proposes an automatic approach to convert a database implemented in MySQL database management system into an equivalent database for the target MongoDB system, which is a leading NoSQL database system. This method can handle a large amount of existing data in RDBs without any loss or changes in data semantics and data instances. The solution takes an existing RDB as input, extracts its schema, and then analyzes the schema in an array to be converted with data instances according to the NoSQL target database structure. A system of the proposed approach has been designed. An experimental study was performed to evaluate the proposed approach. The experimental results show that the target database generated by the prototype and the target database generated by other methods were comparable and equivalent.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
