Data Transformation from SQL to NoSQL MongoDB Based on R Programming Language

2021 5th International Symposium on Multidisciplinary Studies and Innovative Technologies (ISMSIT) Pub Date : 2021-10-21 DOI:10.1109/ISMSIT52890.2021.9604548

F. Hasan, Muhamad Shahbani Abu Bakar

{"title":"Data Transformation from SQL to NoSQL MongoDB Based on R Programming Language","authors":"F. Hasan, Muhamad Shahbani Abu Bakar","doi":"10.1109/ISMSIT52890.2021.9604548","DOIUrl":null,"url":null,"abstract":"Owing to their high availability and scalability, NoSQL databases are becoming more popular for Big data applications in web analytics and supporting large websites. Moreover, each NoSQL system has its API which does not support industry standards like SQL and JDBC, integrating these systems with other enterprise and reporting software takes more time. The main requirements of Big data and data analytics are transforming the data from SQL databases to NoSQL data structures to represent the data. In this work, we presented a method to transform the data from different types of SQL databases to the desired NoSQL database based on the R programming language. The proposed work is based on the R environment used to handle the data from the source system to the target databases and meet the data quality requirements in data transformation. The results confirmed that the development provided a good solution for the data transformation from SQL to NoSQL by taking into account the data quality requirements.","PeriodicalId":120997,"journal":{"name":"2021 5th International Symposium on Multidisciplinary Studies and Innovative Technologies (ISMSIT)","volume":"34 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-10-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 5th International Symposium on Multidisciplinary Studies and Innovative Technologies (ISMSIT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ISMSIT52890.2021.9604548","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 4

Abstract

Owing to their high availability and scalability, NoSQL databases are becoming more popular for Big data applications in web analytics and supporting large websites. Moreover, each NoSQL system has its API which does not support industry standards like SQL and JDBC, integrating these systems with other enterprise and reporting software takes more time. The main requirements of Big data and data analytics are transforming the data from SQL databases to NoSQL data structures to represent the data. In this work, we presented a method to transform the data from different types of SQL databases to the desired NoSQL database based on the R programming language. The proposed work is based on the R environment used to handle the data from the source system to the target databases and meet the data quality requirements in data transformation. The results confirmed that the development provided a good solution for the data transformation from SQL to NoSQL by taking into account the data quality requirements.

查看原文

微信好友朋友圈 QQ好友复制链接

本刊更多论文

基于R编程语言的MongoDB从SQL到NoSQL的数据转换

由于其高可用性和可扩展性，NoSQL数据库在web分析和支持大型网站的大数据应用中越来越受欢迎。此外，每个NoSQL系统都有自己的API，这些API不支持SQL和JDBC等行业标准，将这些系统与其他企业和报表软件集成需要更多的时间。大数据和数据分析的主要要求是将数据从SQL数据库转换为NoSQL数据结构来表示数据。在这项工作中，我们提出了一种基于R编程语言将不同类型的SQL数据库中的数据转换为所需的NoSQL数据库的方法。建议的工作基于R环境，用于处理从源系统到目标数据库的数据，并满足数据转换中的数据质量要求。结果表明，该开发兼顾了数据质量要求，为从SQL到NoSQL的数据转换提供了较好的解决方案。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文去求助

来源期刊

2021 5th International Symposium on Multidisciplinary Studies and Innovative Technologies (ISMSIT)

自引率

0.00%

发文量