Annals of Computer Science and Information Systems · 2016 · 39 citations · 0 references
ComputingComputer ScienceInformation TechnologyData ManagementDatabasesStorage SystemsDatabase ManagementEntity-relationship ModelingNosql DatabasesRelational AlgebraRelational Data ModelRelational DatabasesJoinJoin AlgorithmsJoin OrderingKey-value StoresKeysRelational Database Systems
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.