Conceptual Mappings to Convert Relational into NoSQL Databases

Myller Claudino de Freitas, Damires Yluska Souza, Ana Carolina Salgado

Abstract

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.

References

  1. Han, J., Haihong, E., Le, G., Du, J., 2011. Survey on NoSQL database. In: Pervasive computing and applications (ICPCA), 2011 6th international conference on. IEEE. p. 363-366.
  2. Istvan, Z., Alonso, G., Blott, M., Vissers, K., A flexible hash table design for 10Gbps key-value stores on FPGAs. In: Field Programmable Logic and Applications (FPL), 2013 23rd International Conference on. IEEE. p. 1-8.
  3. Karnitis, G. and Arnicans, G., 2015. Migration of relational database to document-oriented database: Structure denormalization and data transformation. Communication Systems and Networks (CICSyN), 7th International Conference on Computational Intelligence. p. 114-118.
  4. Lakshman, A., Malik, P., 2010. Cassandra: a decentralized structured storage system. ACM SIGOPS Operating Systems Review, v. 44, n. 2, p. 35-40.
  5. McMurtry, D., Oakley, A., Sharp, J., Subramanian, M., and Zhang, H., 2013. Data access for highly-scalable solutions: Using sql, nosql, and polyglot persistence. Microsoft patterns & practices.
  6. MongoDB, 2015. Available at https://www.mongodb.org/. Last access on December, 2015.
  7. Mpinda, S. A. T., Maschietto, L. G., and Bungama, P. A., 2015. From relational database to columnoriented nosql database: Migration process. International Journal of Engineering Research & Technology (IJERT), 4. p. 399-403.
  8. Neo4j, 2015. Available at http://neo4j.com. Last access on December, 2015.
  9. Potey, M., Digrase, M., Deshmukh, G., and Nerkar, M., 2015. Database migration from structured database to non-structured database. International Conference on Recent Trends & Advancements in Engineering Technology (ICRTAET 2015), p. 1-3.
  10. Redis, 2015. Available at http://redis.io/. Last access on December, 2015.
  11. Zhao, G., Lin, Q., Li, L., Li, Z. 2014. Schema Conversion Model of SQL Database to NoSQL. In: P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), 2014 Ninth International Conference on. IEEE. p. 355-362.
Download


Paper Citation


in Harvard Style

Freitas M., Souza D. and Salgado A. (2016). Conceptual Mappings to Convert Relational into NoSQL Databases . In Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-187-8, pages 174-181. DOI: 10.5220/0005836301740181


in Bibtex Style

@conference{iceis16,
author={Myller Claudino de Freitas and Damires Yluska Souza and Ana Carolina Salgado},
title={Conceptual Mappings to Convert Relational into NoSQL Databases},
booktitle={Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2016},
pages={174-181},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005836301740181},
isbn={978-989-758-187-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Conceptual Mappings to Convert Relational into NoSQL Databases
SN - 978-989-758-187-8
AU - Freitas M.
AU - Souza D.
AU - Salgado A.
PY - 2016
SP - 174
EP - 181
DO - 10.5220/0005836301740181