Metadata-driven data migration from object-relational database to nosql document-oriented database

• Autorzy: Aggoune Aicha , Namoune Mohamed Sofiane

Identyfikatory

DOI

10.7494/csci.2022.23.4.4375

• Języki publikacji: EN

Abstrakty

EN

Object-relational databases (ORDB) are powerful tools 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 a metadata-driven approach for the migration of ORDB to a document-oriented NoSQL database. Our data-migration approach involves three major stages: a pre-processing stage (to extract data and a schema’s components), a processing stage (to provide data transformation), and a post-processing stage (to store migrated data as BSON documents). This approach maintains the benefits of Oracle ORDB in NoSQL MongoDB by supporting integrity constraint checking. To validate our approach, we developed the OR2DOD (object relational to document-oriented database) system, and the experimental results confirm the effectiveness of our proposal.

Słowa kluczowe

EN

NoSQL document-oriented database; object-relational database; data migration; mapping rules; metadata

• Wydawca: Wydawnictwa AGH
• Czasopismo: Computer Science
• Rocznik: 2022
• Tom: T. 23 (4)
• Strony: 495--519
• Opis fizyczny: Bibliogr. 33 poz., rys., tab.

Twórcy

autor

Aggoune Aicha

• University of 8th of May, 1945, Computer Science Department, LabSTIC Laboratory, Guelma, Algeria

autor

Namoune Mohamed Sofiane

• University of 8th of May, 1945, Computer Science Department, Guelma, Algeria

Bibliografia

• [1] Aggoune A.: Intelligent data integration from heterogeneous relational databases containing incomplete and uncertain information, Intelligent Data Analysis, vol. 26(1), pp. 75–99, 2022.
• [2] Aggoune A., Namoune M.S.: A method for transforming object-relational to document-oriented databases. In: 2020 2nd International Conference on Mathematics and Information Technology (ICMIT), pp. 154–158, IEEE, 2020.
• [3] Alotaibi O., Pardede E.: Transformation of Schema from Relational Database (RDB) to NoSQL Databases, Data, vol. 4(4), 2019.
• [4] Anderson M.J.: Distance-based tests for homogeneity of multivariate dispersions, Biometrics, vol. 62, pp. 245–253, 2006.
• [5] Chen X., Liu Z., Sun M.: A unified model for word sense representation and disambiguation. In: Proceedings of the 2014 Conference on Empirical Methods in Natural Language Processing (EMNLP), pp. 1025–1035, 2014.
• [6] Chodorow K.: MongoDB: the definitive guide: powerful and scalable data storage, O’Reilly Media, 2013.
• [7] Chung W.C., Lin H.P., Chen S.C., Jiang M.F., Chung Y.C.: JackHare: a framework for SQL to NoSQL translation using MapReduce, Automated Software Engineering, vol. 21, pp. 489–508, 2014.
• [8] Corbellini A., Mateos C., Zunino A., Godoy D., Schiaffino S.: Persisting big-data: The NoSQL landscape, Information Systems, vol. 63, pp. 1–23, 2017.
• [9] Date C.J., Darwen H.: Foundation for Object/Relational Databases: the third manifesto, Addison Wesley Longman Publishing, 1998.
• [10] Davoudian A., Chen L., Liu M.: A survey on NoSQL stores, ACM Computing Surveys (CSUR), vol. 51, pp. 1–43, 2018.
• [11] Delmal P.: SQL2-SQL3: applications `a Oracle, De Boeck Sup´erieur, 2000.
• [12] Devarakonda R.S.: Object-relational database systems the road ahead, XRDS: Crossroads, The ACM Magazine for Students, vol. 7, pp. 15–18, 2001.
• [13] Eder J., Kanzian S.: Logical Design of Generalizations in Object-relational Databases. In: ADBIS (Local Proceedings), 2004.
• [14] Eisenberg A., Melton J.: SQL: 1999, formerly known as SQL3, ACM Sigmod Record, vol. 28, pp. 131–138, 1999.
• [15] Fouad T., Mohamed B.: Model Transformation From Object Relational Database to NoSQL Document Database. In: Proceedings of the 2nd International Conference on Networking, Information Systems & Security, pp. 1–5, 2019.
• [16] Hibernate: OMG. http://www.hibernate.org.
• [17] Kreines D.C.: Oracle SQL: the essential reference, O’Reilly Media, 2000.
• [18] Kuszera E.M., Peres L.M., Del Fabro M.D.: Exploring data structure alternatives in the RDB to NoSQL document store conversion process, Information Systems, vol. 105, 2022.
• [19] Kuszera E.M., Peres L.M., Fabro M.D.D.: Toward RDB to NoSQL: transforming data with metamorfose framework. In: Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing, pp. 456–463, 2019.
• [20] Laender A.H.F., Ribeiro-Neto B.A., Da Silva A.S., Teixeira J.S.: A brief survey of web data extraction tools, ACM Sigmod Record, vol. 31, pp. 84–93, 2002.
• [21] Lee K.K.Y., Tang W.C., Choi K.S.: Alternatives to relational database: comparison of NoSQL and XML approaches for clinical data storage, Computer Methods and Programs in Biomedicine, vol. 110, pp. 99–109, 2013.
• [22] Liao Y.T., Zhou J., Lu C.H., Chen S.C., Hsu C.H., Chen W., Jiang M.F., Chung Y.C.: Data adapter for querying and transformation between SQL and NoSQL database, Future Generation Computer Systems, vol. 65, pp. 111–121, 2016.
• [23] Mansouri Y., Babar M.A.: The Impact of Distance on Performance and Scalability of Distributed Database Systems in Hybrid Clouds, arXiv preprint arXiv:200715826, 2020.
• [24] Marcos E., Vela B., Cavero J.M.: A Methodological Approach for ObjectRelational Database Design using UML, Software and Systems Modeling, vol. 2, pp. 59–72, 2003.
• [25] Ouanouki R., April A., Abran A., Gomez A., Desharnais J.M.: Toward building RDB to HBase conversion rules, Journal of Big Data, vol. 4, pp. 1–21, 2017.
• [26] Piech M., Marcjan R.: A new approach to storing dynamic data in relational databases using JSON, Computer Science, vol. 19, 2018.
• [27] Reniers V., Van Landuyt D., Rafique A., Joosen W.: Object to NoSQL Database Mappers (ONDM): A systematic survey and comparison of frameworks, Information Systems, vol. 85, pp. 1–20, 2019.
• [28] Roberts P.: Seamlessness as a desirable aspect of quality for MDE: the contribution of object-relational database stuctures. In: 2010 Seventh International Conference on the Quality of Information and Communications Technology, pp. 253–258, IEEE, 2010.
• [29] Rocha L., Vale F., Cirilo E., Barbosa D., Mour˜ao F.: A framework for migrating relational datasets to NoSQL, Procedia Computer Science, vol. 51, pp. 2593–2602, 2015.
• [30] Singh S.: Security Analysis of MongoDB, International Journal of Digital Society (IJDS), vol. 10(4), pp. 1556–1561, 2019.
• [31] Soutou C.: Modeling relationships in object-relational databases, Data & Knowledge Engineering, vol. 36, pp. 79–107, 2001.
• [32] Stanescu L., Brezovan M., Burdescu D.D.: An algorithm for mapping the relational databases to MongoDB – a case study, International Journal of Computer Science & Applications, vol. 14, pp. 65–79, 2017.
• [33] Strozzi C.: NoSQL: a non-SQL RDBMS. http://www.strozzi.it/cgi-bin/CSA/ tw7/I/en US/nosql/Home%20Page.

Uwagi

PL

Opracowanie rekordu ze środków MEiN, umowa nr SONP/SP/546092/2022 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2022-2023).