{"title":"RDB到NoSQL DB的转换","authors":"Jeang-Kuo Chen, Wei-Zhe Lee","doi":"10.1109/taai54685.2021.00042","DOIUrl":null,"url":null,"abstract":"In the past, Relational Database (RDB) is widely used to access data quickly because of high data accuracy and consistency. However, the Big Data era forces many industries to change RDB in order to process a huge amount of data in time. NoSQL (Not only SQL) database (NoSQL DB) is a tailor-made DB. Various industries can choose a suitable NoSQL DB to enhance their competitiveness according to their operational needs. But the data in RDB still need to be saved for company’s operation. How to convert data from RDB to NoSQL DB is an important issue. This paper proposes an algorithm to transfer an RDB to the Wide Column Store DB (WCSDB), one of the most popular NoSQL databases. The experiment results show that WCSDB performs better than RDB.","PeriodicalId":343821,"journal":{"name":"2021 International Conference on Technologies and Applications of Artificial Intelligence (TAAI)","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-11-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"The Transformation of RDB to NoSQL DB\",\"authors\":\"Jeang-Kuo Chen, Wei-Zhe Lee\",\"doi\":\"10.1109/taai54685.2021.00042\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In the past, Relational Database (RDB) is widely used to access data quickly because of high data accuracy and consistency. However, the Big Data era forces many industries to change RDB in order to process a huge amount of data in time. NoSQL (Not only SQL) database (NoSQL DB) is a tailor-made DB. Various industries can choose a suitable NoSQL DB to enhance their competitiveness according to their operational needs. But the data in RDB still need to be saved for company’s operation. How to convert data from RDB to NoSQL DB is an important issue. This paper proposes an algorithm to transfer an RDB to the Wide Column Store DB (WCSDB), one of the most popular NoSQL databases. The experiment results show that WCSDB performs better than RDB.\",\"PeriodicalId\":343821,\"journal\":{\"name\":\"2021 International Conference on Technologies and Applications of Artificial Intelligence (TAAI)\",\"volume\":\"1 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-11-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2021 International Conference on Technologies and Applications of Artificial Intelligence (TAAI)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/taai54685.2021.00042\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 International Conference on Technologies and Applications of Artificial Intelligence (TAAI)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/taai54685.2021.00042","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
在过去,关系型数据库(RDB)由于具有较高的数据准确性和一致性,被广泛用于快速访问数据。然而,大数据时代迫使许多行业改变RDB,以便及时处理大量数据。NoSQL (Not only SQL)数据库(NoSQL DB)是一种量身定制的数据库。各行业可以根据自身的运营需要,选择合适的NoSQL数据库来提升自身的竞争力。但是RDB中的数据仍然需要保存,以供公司运营使用。如何将数据从RDB转换为NoSQL数据库是一个重要的问题。本文提出了一种将RDB传输到最流行的NoSQL数据库之一宽列存储数据库(WCSDB)的算法。实验结果表明,WCSDB的性能优于RDB。
In the past, Relational Database (RDB) is widely used to access data quickly because of high data accuracy and consistency. However, the Big Data era forces many industries to change RDB in order to process a huge amount of data in time. NoSQL (Not only SQL) database (NoSQL DB) is a tailor-made DB. Various industries can choose a suitable NoSQL DB to enhance their competitiveness according to their operational needs. But the data in RDB still need to be saved for company’s operation. How to convert data from RDB to NoSQL DB is an important issue. This paper proposes an algorithm to transfer an RDB to the Wide Column Store DB (WCSDB), one of the most popular NoSQL databases. The experiment results show that WCSDB performs better than RDB.