No 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.

The exponential growth of complex data in object-relational databases (ORDB) raises the need for efficient storage with scalability, consistency, and partition tolerance. The migration towards NoSQL (not only structured query language) datastores is the best fit for distributed complex data. Unfortunately, very few studies provide solutions for ORDB migration to NoSQL. This paper reports on how to achieve the migration of complex data from ORDB to a document-oriented NoSQL database. The proposed approach focused on the P3 process that involves three major stages: (P1) the preprocessing stage to access and extract the database features using SQL queries, (P2) the processing stage to provide the data mapping by using a list of mapping rules between the source and target models, and (P3) the post-processing stage to store and request the migrated data within the NoSQL context. A thorough experiments on two real-life databases veriðes the P3 process improves the performance of data migration with complex schema structures.