Automatic Mapping of MySQL Databases to NoSQL MongoDB
Liana Stănescu, Marius Brezovan, Dumitru Dan Burdescu · Annals of Computer Science and Information Systems · 2016
The paper presents a framework that implements our original algorithm of automatic mapping a MySQL relational database to a MongoDB NoSQL database.The algorithm uses the metadata stored in the MySQL system tables.It takes into consideration the concepts from Entity-Relationship (ER) model: entity type represented by a relation in the Relational Model (RM), 1:1 and 1:M relationship type represented with Foreign Keys (FK) in the RM and N:M relationship type represented in RM with a join table that contains the Primary Keys (PK) from the original tables, each representing a FK and two 1:M relationships between the original tables and the join table.The initial results of our algorithm that was tested on small size databases (10-15 tables with many relationships and 100 records/ table) are presented in this paper.