Automatic mapping of MySQL databases to NoSQL MongoDB

Abstract

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), 11 and 1M relationship type represented with Foreign Keys (FK) in the RM and NM 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 1M 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.