Logo PTI
Polish Information Processing Society
Logo FedCSIS

Annals of Computer Science and Information Systems, Volume 8

Proceedings of the 2016 Federated Conference on Computer Science and Information Systems

Automatic Mapping of MySQL Databases to NoSQL MongoDB

, ,

DOI: http://dx.doi.org/10.15439/2016F45

Citation: Proceedings of the 2016 Federated Conference on Computer Science and Information Systems, M. Ganzha, L. Maciaszek, M. Paprzycki (eds). ACSIS, Vol. 8, pages 837840 ()

Full text

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), 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.


  1. http://www.datastax.com/nosql-databases
  2. https://www.thoughtworks.com/insights/blog/nosql-databases-overview
  3. https://leanpub.com/mongodbschemadesign/read
  4. http://code.tutsplus.com/articles/mapping-relational-databases-and-sql-to-mongodb--net-35650
  5. https://docs.mongodb.org/manual/core/data-modeling-introduction/
  6. https://dev.mysql.com/doc/refman/5.0/en/information-schema.html
  7. https://dev.mysql.com/doc/refman/5.5/en/introduction.html
  8. https://www.devbridge.com/articles/benefits-of-nosql/