Metadata-driven Data Migration from Object-relational Database to NoSQL Document-oriented Database
-
Published:2022-11-08
Issue:4
Volume:23
Page:
-
ISSN:2300-7036
-
Container-title:Computer Science
-
language:
-
Short-container-title:csci
Author:
Aggoune Aicha,Namoune Mohamed Sofiane
Abstract
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.
Publisher
AGHU University of Science and Technology Press
Subject
Artificial Intelligence,Computational Theory and Mathematics,Computer Graphics and Computer-Aided Design,Computer Networks and Communications,Computer Vision and Pattern Recognition,Modeling and Simulation,Computer Science (miscellaneous)
Cited by
1 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Metadata-Driven Cloud-Agnostic Data Integration Framework;2024 47th MIPRO ICT and Electronics Convention (MIPRO);2024-05-20