Conceptual Mappings to Convert Relational into NoSQL Databases

Sometimes, data belonging to Relational databases need to be transferred to NoSQL ones. However, the data conversion process between Relational to NoSQL databases is considered as not trivial, since it is necessary to have considerable knowledge about the data models at hand. Regarding the structural heterogeneity underlying this problem, we propose an approach, named as R2NoSQL, which defines conceptual mappings to enhance the data conversion process. In this paper, we present our approach and some implementation and experimental results, which show that, by using the defined conceptual mappings, we obtain a consistent target NoSQL database with respect to a source Relational one.

[1]  Minal Nerkar,et al.  Database Migration from Structured Database to non-Structured Database , 2015 .

[2]  John Sharp,et al.  Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence , 2013 .

[3]  Zijing Li,et al.  Schema Conversion Model of SQL Database to NoSQL , 2014, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing.

[4]  Steve Ataky Tsham Mpinda,et al.  From Relational Database to Column-Oriented NoSQL Database: Migration Process , 2015 .

[5]  Prashant Malik,et al.  Cassandra: a decentralized structured storage system , 2010, OPSR.

[6]  Gustavo Alonso,et al.  A flexible hash table design for 10GBPS key-value stores on FPGAS , 2013, 2013 23rd International Conference on Field programmable Logic and Applications.

[7]  Guan Le,et al.  Survey on NoSQL database , 2011, 2011 6th International Conference on Pervasive Computing and Applications.

[8]  Guntis Arnicans,et al.  Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation , 2015, 2015 7th International Conference on Computational Intelligence, Communication Systems and Networks.