A Method for Transforming Object-relational to Document-oriented Databases

Aggoune, Aicha; Namoune, Mohamed Sofiane

doi:10.1109/icmit47780.2020.9047011

Cited by 7 publications

(7 citation statements)

References 14 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…1000, 5000, and 10000 tweet/records through the proposed middleware, KUNDERA, Spring Data, ODBAPI, and CDPort frameworks as seen in reading of Table V. The total time taken to perform these operations were compared which depicted that middleware performs at par to all these frameworks [40] as can be seen in Fig. 6 and Fig.…”

Section: Results and Evaluationmentioning

confidence: 95%

“…A detailed description of the middleware implementation is given in [39]. It was observed that leveraging the middleware makes it quite easy for the user to achieve the data portability decreasing user"s efforts greatly [40]. We have experimentally evaluated the industry ready ONDMs namely KUNDERA and Spring Data as well as academic ODNMs namely CDPort and ODBAPI against SQL and NoSQL (MongoDB and Cassandr data-stores [40].…”

Section:  Portability Of Applications In the Context Ofmentioning

confidence: 99%

“…It was observed that leveraging the middleware makes it quite easy for the user to achieve the data portability decreasing user"s efforts greatly [40]. We have experimentally evaluated the industry ready ONDMs namely KUNDERA and Spring Data as well as academic ODNMs namely CDPort and ODBAPI against SQL and NoSQL (MongoDB and Cassandr data-stores [40]. The four candidate methodologies have been evaluated using Twitter dataset and implementing different migration scenarios.…”

Section:  Portability Of Applications In the Context Ofmentioning

confidence: 99%

See 2 more Smart Citations

A Comparative Study of Cloud Data Portability Frameworks for Analyzing Object to NoSQL Database Mapping from ONDM's Perspective

Bharany,

Kaur,

Eltaher

et al. 2023

IJACSA

View full text Add to dashboard Cite

Cloud computing revolves around storing and retrieving data in a portable manner. However, practical data portability across multiple Database-as-a-service (DBaaS) cloud data stores is challenging. This becomes even more complicated when data needs to be migrated between different types of data storage, such as SQL and NoSQL databases. NoSQL databases have gained significant popularity among developers due to their ability to provide high availability, fault tolerance, and scalability, making them suitable for managing big data in largescale infrastructures. However, the varied data models in NoSQL databases make it difficult to migrate or port data among data repositories. Object to NoSQL database mappers (ONDMs) solves this problem. However, only a few ONDMs are available for C#.NET development, and the ONDM market used in Java development could be more stable. To address this issue, we propose building a middleware solution using the .NET framework to support cloud data portability, leveraging the capabilities of ONDMs. In this study, we evaluate several frameworks and compare them to our suggested middleware solution through empirical research. Our middleware solution can perform open network data management (ONDM) and object-relational mapping (ORM).

show abstract

Section: Results and Evaluationmentioning

confidence: 95%

Section:  Portability Of Applications In the Context Ofmentioning

confidence: 99%

Section:  Portability Of Applications In the Context Ofmentioning

confidence: 99%

See 1 more Smart Citation

A Comparative Study of Cloud Data Portability Frameworks for Analyzing Object to NoSQL Database Mapping from ONDM's Perspective

Bharany,

Kaur,

Eltaher

et al. 2023

IJACSA

View full text Add to dashboard Cite

show abstract

“…[Aicha AGGOUNE, and al. 2020] authors of [27] developed a new method to transform an object-relational database (ORDB) into a document-oriented database (DODB). The proposed method is mainly composed of three modules.…”

Section: Related Workmentioning

confidence: 99%

New Structural and Semantic Transformation of Relational Databases to MongoDB

Erraji¹,

Maizate²,

Ouzzif³

2023

IJETAE

View full text Add to dashboard Cite

Currently, data and its exploitation play a very important role in the life of individuals and organizations, without forgetting that through data management tools these organizations store their data history, which guides them at the operational and strategic levels. Considering the explosion of data at huge sizes, the old relational system has several shortcomings in managing this information, which justifies the need for data migration to NoSQL systems, which manage BigData efficiently. In this sense, this article fits to find a new transformation of relational databases to MongoDB, as a wellchosen NoSQL system for this transformation. This article presents the problem of this transformation, so that it can be discussed based on related works, then enlightened by presenting the storage philosophy and the semantics of the two systems source and destination of this transformation, which will be chained by our approach which defining a set of transformation rules to keep the same data and advantages of relational systems under a structure adequate to the concept of MongoDB and finally our conclusion of this work.

show abstract

“…Second, we maintained the benefits of both the object-relational and NoSQL technologies (such as scalability to handle huge amount of data and integrity constraints to ensure data quality). The authors have presented a preliminary proposal that pays less attention to the problem of data migration from an object-relational E a r l y b i r d database (ORDB) to a NoSQL database [2]; thus, it does not study integrity constraint management from the data-migration perspective.…”

Section: Overview Of Metadata-driven Data-migration Approachmentioning

confidence: 99%

Metadata-driven Data Migration from Object-relational Database to NoSQL Document-oriented Database

Aggoune

Namoune

2022

csci

View full text Add to dashboard Cite

The object-relational databases (ORDB) are powerful for managing complex data, but they suffer from problems of scalability and managing large-scale data. Therefore, the importance of the migration of ORDB to NoSQL derives from the fact that the large volume of data can be handled in the best way with high scalability and availability. This paper reports our metadata-driven approach for the migration of the ORDB to document-oriented NoSQL database. Our data migration approach involves three major stages: a preprocessing stage, to extract the data and the schema's components, a processing stage, to provide the data transformation, and a post-processing stage, to store the migrated data as BSON documents. The approach maintains the benefits of Oracle ORDB in NoSQL MongoDB by supporting integrity constraint checking. To validate our approach, we developed OR2DOD (Object Relational to Document-Oriented Databases) system, and the experimental results confirm the effectiveness of our proposal.

show abstract

A Method for Transforming Object-relational to Document-oriented Databases

Cited by 7 publications

References 14 publications

A Comparative Study of Cloud Data Portability Frameworks for Analyzing Object to NoSQL Database Mapping from ONDM's Perspective

A Comparative Study of Cloud Data Portability Frameworks for Analyzing Object to NoSQL Database Mapping from ONDM's Perspective

New Structural and Semantic Transformation of Relational Databases to MongoDB

Metadata-driven Data Migration from Object-relational Database to NoSQL Document-oriented Database

Contact Info

Product

Resources

About