Automatic SQL-to-NoSQL Schema Transformation over the MySQL and HBase Databases

被引:0
|
作者
Lee, Chao-Hsien [1 ]
Zheng, Yu-Lin [1 ]
机构
[1] Natl Taipei Univ Technol, Dept Elect Engn, Taipei, Taiwan
关键词
D O I
暂无
中图分类号
TM [电工技术]; TN [电子技术、通信技术];
学科分类号
0808 ; 0809 ;
摘要
The explosive growth of huge data lets cloud computing be more and more popular in recent years. Traditional web-based content management systems (CMS), e.g., phpBB, WordPress, and Joomla, store data using relational databases whose key advantage is the strong relationships among tables. However, regarding the flexibility and the feasibility of parallel processing, cloud computing adopts NoSQL databases that can support horizontal scaling to handle big data. Therefore, how to transform the existing SQL data into the NoSQL database becomes an emerging and necessary issue. This paper is motivated to propose an automatic SQL-to-NoSQL schema transformation mechanism over the MySQL and HBase databases. Based on our experimental results, the proposed mechanism is able to improve about 47% access performance.
引用
收藏
页码:426 / 427
页数:2
相关论文
共 12 条
  • [1] UMLtoNoSQL: Automatic Transformation of Conceptual Schema to NoSQL Databases
    Abdelhedi, Fatma
    Ait Brahim, Amal
    Atigui, Faten
    Zurfluh, Gilles
    [J]. 2017 IEEE/ACS 14TH INTERNATIONAL CONFERENCE ON COMPUTER SYSTEMS AND APPLICATIONS (AICCSA), 2017, : 272 - 279
  • [2] SQL-to-NoSQL Schema Denormalization and Migration: A Study on Content Management Systems
    Lee, Chao-Hsien
    Zheng, Yu-Lin
    [J]. 2015 IEEE INTERNATIONAL CONFERENCE ON SYSTEMS, MAN, AND CYBERNETICS (SMC 2015): BIG DATA ANALYTICS FOR HUMAN-CENTRIC SYSTEMS, 2015, : 2022 - 2026
  • [3] Automatic Mapping of MySQL Databases to NoSQL MongoDB
    Stanescu, Liana
    Brezovan, Marius
    Burdescu, Dumitru Dan
    [J]. PROCEEDINGS OF THE 2016 FEDERATED CONFERENCE ON COMPUTER SCIENCE AND INFORMATION SYSTEMS (FEDCSIS), 2016, 8 : 837 - 840
  • [4] Transformation of Schema from Relational Database (RDB) to NoSQL Databases
    Alotaibi, Obaid
    Pardede, Eric
    [J]. DATA, 2019, 4 (04)
  • [5] Automatic schema suggestion model for NoSQL document-stores databases
    Imam, Abdullahi Abubakar
    Basri, Shuib
    Ahmad, Rohiza
    Watada, Junzu
    Gonzalez-Aparicio, Maria T.
    [J]. JOURNAL OF BIG DATA, 2018, 5 (01)
  • [6] Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping
    Aftab, Zain
    Iqbal, Waheed
    Almustafa, Khaled Mohamad
    Bukhari, Faisal
    Abdullah, Muhammad
    [J]. SCIENTIFIC PROGRAMMING, 2020, 2020
  • [7] Physical Data Warehouse Design on NoSQL Databases OLAP Query Processing over HBase
    Scabora, Lucas C.
    Brito, Jaqueline J.
    Ciferri, Ricardo Rodrigues
    de Aguiar Ciferri, Cristina Dutra
    [J]. PROCEEDINGS OF THE 18TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1 (ICEIS), 2016, : 111 - 118
  • [8] Automatic transformation of SQL relational databases to owl ontologies
    Astrova, Irina
    Kalja, Ahto
    [J]. WEBIST 2008: PROCEEDINGS OF THE FOURTH INTERNATIONAL CONFERENCE ON WEB INFORMATION SYSTEMS AND TECHNOLOGIES, VOL 2, 2008, : 131 - 136
  • [9] Automatic Transformation of Data Warehouse Schema To NoSQL Data Base: Comparative Study
    Yangui, Rania
    Nabli, Ahlem
    Gargouri, Faiez
    [J]. KNOWLEDGE-BASED AND INTELLIGENT INFORMATION & ENGINEERING SYSTEMS: PROCEEDINGS OF THE 20TH INTERNATIONAL CONFERENCE KES-2016, 2016, 96 : 264 - 273
  • [10] A Comparison of NoSQL and SQL Databases over the Hadoop and Spark Cloud Platforms using Machine Learning Algorithms
    Lee, Chao-Hsien
    Shih, Zhe-Wei
    [J]. 2018 IEEE INTERNATIONAL CONFERENCE ON CONSUMER ELECTRONICS-TAIWAN (ICCE-TW), 2018,