A Method for Transforming Object-relational to Document-oriented Databases
- 1 February 2020
- conference paper
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE) in 2020 2nd International Conference on Mathematics and Information Technology (ICMIT)
Abstract
Object-relational databases have emerged to improve relational ones by adding properties of object-oriented approach such as references, polymorphism, inheritance, etc. However, these extended relational databases have become a huge amount of data and the database management systems (DBMS) cannot handle them. Due to the emergence of NoSQL databases for ensuring the storage and the processing of large data scale, it is necessary to propose a method for transforming object-relational to NoSQL databases. This paper presents a new method for transforming the object-relational database to one of the popular NoSQL data stores so-called document-oriented database. The proposed method is based on a set of matching between the schemata of object-relational and document-oriented databases. The method is terminated by the generation of a set of JSON files which represent collections of semi-structured documents. These files can be imported and represented by BSON format that will be managed by document-oriented DBMS such as MongoDB.Keywords
This publication has 14 references indexed in Scilit:
- Data adapter for querying and transformation between SQL and NoSQL databaseFuture Generation Computer Systems, 2016
- Relational Database to NoSQL Conversion by Schema Migration and MappingInternational Journal of Computer Engineering in Research Trends, 2016
- Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data TransformationPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2015
- Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databasesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2015
- A Framework for Migrating Relational Datasets to NoSQL 1Procedia Computer Science, 2015
- Schema Conversion Model of SQL Database to NoSQLPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2014
- Correlation Aware Technique for SQL to NoSQL TransformationPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2014
- MapReduce join strategies for key-value storagePublished by Institute of Electrical and Electronics Engineers (IEEE) ,2014
- MySQL to NoSQLPublished by Association for Computing Machinery (ACM) ,2012
- Transforming relational database into HBase: A case studyPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2010