Converting Relational Database to Document-Oriented NoSQL Cloud Database

Dabowsa, Nisreen I. Abo; Maatuk, Abdelsalam M.; Elakeili, Salwa; Ali, Muhammad

doi:10.1109/mi-sta52233.2021.9464488

Cited by 7 publications

(2 citation statements)

References 20 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…One of the approaches in transforming data models is the use of relational algebra and set theory [17]. This adapts methods of relational algebra and set theory for convenient use in the context of database models and schemas.…”

Section: Choice Of Methodsmentioning

confidence: 99%

Research of Methods to Support Data Migration Between Relational and Document Data Storage Models

Peretiatko

Shirokopetleva

Lesna

2022

ITSSI

View full text Add to dashboard Cite

The subject matter of the article is heterogeneous model-inhomogeneous data migration between relational and document-oriented data storage models, existing strategies and methods to support such migrations, the use of relational algebra and set theory in the context of databases in building a new data migration algorithm. The goal of the work is to consider the features and procedure of data migration, explore methods to support data migration between relational and documentary data models, build a mathematical model and algorithm for data migration. The following methods were used: analysis and comparison of existing approaches to data migration, choice of strategy for further use in compiling the migration algorithm, mathematical modeling of the algorithm of heterogeneous model-inhomogeneous data migration, formalization of the data migration algorithm. The following tasks were solved in the article: consideration of the concept and types of data migration, justification for choosing a document-oriented data model as a target for data migration, analysis of existing literature sources on methods and strategies of heterogeneous model data migration from relational to document-oriented data model, highlighting advantages and disadvantages existing methods, choosing an approach to the formation of the data migration algorithm, compiling and describing a mathematical model of data migration using relational algebra and set theory, presentation of the data migration algorithm, which is based on the focus on data queries. The following results were obtained: the possibilities of relational algebra and set theory in the context of data models and queries are used, as well as in model redesign, the strategy of migration of data models is chosen, which provides relational and document-oriented data models, the algorithm of application of this method is described. Conclusions: because of the work, the main methods of migration support for different data storage models are analyzed, with the help of relational algebra, set theory a mathematical model is built, and an algorithm for transforming a relational data model into a document-oriented data model is taken into account. The obtained algorithm is suitable for use in real examples, and is the subject of further research and possible improvements, analysis of efficiency in comparison with other methods.

show abstract

Section: Choice Of Methodsmentioning

confidence: 99%

Research of Methods to Support Data Migration Between Relational and Document Data Storage Models

Peretiatko

Shirokopetleva

Lesna

2022

ITSSI

View full text Add to dashboard Cite

show abstract

“…Different technical details and developments are proposed to convert the structural relational datasets into document oriented models [Abdelhedi et al 2022, Namdeo et al 2012]. Other researchers attempted to design an advisor for schema design to migrate from RDBMS to NoSQL [Dabowsa et al 2021]. However, why migrate from RDBMS to NoSQL systems?…”

Section: Related Workmentioning

confidence: 99%

A Comparison Between Nosql and Rdbms: Storage and Retrieval

Fadhel¹,

Jameel²

2022

MINAR Journal

View full text Add to dashboard Cite

Relational database management systems (RDBMS) emerged as the solution for data storage in the past decades. All data storage systems and applications utilize a RDBMS in the heart of the system to store and retrieve the data. In the past few years a new data storage model, named Not Only Structured Query Language (NOSQL), has emerged to produce less complex data storage systems and to tackle the data's massive volume performance degradation of used systems. In this work, a comparison study is conducted between MySQL as an example of RDBMS and Monogodb as an example of NOSQL systems using threading and machine resources to show the differences for developers to select one of these models for their applications. The results show that the performance of NoSQL is less than MySQL for small datasets and few database operations, such as few thousands of records and hundreds of operations per day. However, with the introduction of threads and volumes of data, the performance of Mongodb overcomes My Structured Query Language (MySQL). In addition, the results have shown that Mongodb requires more memory usage and CPU resources than MySQL to complete their tasks. Finally, the images were saved as byte data inside both platforms. The storing process for this data inside Mongodb was faster than the MySQL platform

show abstract

A Novel Approach for Migrating Relational Databases into Graph Databases

Eldrrat,

Maatuk

2023

2023 3rd International Conference on Emerging Smart Technologies and Applications (eSmarTA)

View full text Add to dashboard Cite

Converting Relational Database to Document-Oriented NoSQL Cloud Database

Cited by 7 publications

References 20 publications

Research of Methods to Support Data Migration Between Relational and Document Data Storage Models

Research of Methods to Support Data Migration Between Relational and Document Data Storage Models

A Comparison Between Nosql and Rdbms: Storage and Retrieval

A Novel Approach for Migrating Relational Databases into Graph Databases

Contact Info

Product

Resources

About