{"title":"A Method for Transforming Object-relational to Document-oriented Databases","authors":"A. Aggoune, Mohamed Sofiane Namoune","doi":"10.1109/ICMIT47780.2020.9047011","DOIUrl":null,"url":null,"abstract":"Object-relational databases have emerged to improve relational ones by adding properties of object-oriented approach such as references, polymorphism, inheritance, etc. However, these extended relational databases have become a huge amount of data and the database management systems (DBMS) cannot handle them. Due to the emergence of NoSQL databases for ensuring the storage and the processing of large data scale, it is necessary to propose a method for transforming object-relational to NoSQL databases. This paper presents a new method for transforming the object-relational database to one of the popular NoSQL data stores so-called document-oriented database. The proposed method is based on a set of matching between the schemata of object-relational and document-oriented databases. The method is terminated by the generation of a set of JSON files which represent collections of semi-structured documents. These files can be imported and represented by BSON format that will be managed by document-oriented DBMS such as MongoDB.","PeriodicalId":132958,"journal":{"name":"2020 2nd International Conference on Mathematics and Information Technology (ICMIT)","volume":"19 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2020-02-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"5","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2020 2nd International Conference on Mathematics and Information Technology (ICMIT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICMIT47780.2020.9047011","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 5
Abstract
Object-relational databases have emerged to improve relational ones by adding properties of object-oriented approach such as references, polymorphism, inheritance, etc. However, these extended relational databases have become a huge amount of data and the database management systems (DBMS) cannot handle them. Due to the emergence of NoSQL databases for ensuring the storage and the processing of large data scale, it is necessary to propose a method for transforming object-relational to NoSQL databases. This paper presents a new method for transforming the object-relational database to one of the popular NoSQL data stores so-called document-oriented database. The proposed method is based on a set of matching between the schemata of object-relational and document-oriented databases. The method is terminated by the generation of a set of JSON files which represent collections of semi-structured documents. These files can be imported and represented by BSON format that will be managed by document-oriented DBMS such as MongoDB.