Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases

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.

[1]  Danilo Ardagna,et al.  Issues in Handling Complex Data Structures with NoSQL Databases , 2012, 2012 14th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing.

[2]  Sathiamoorthy Manoharan,et al.  A performance comparison of SQL and NoSQL databases , 2013, 2013 IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM).

[3]  Wumuti Naheman,et al.  Review of NoSQL databases and performance testing on HBase , 2013, Proceedings 2013 International Conference on Mechatronic Sciences, Electric Engineering and Computer (MEC).

[4]  B. B. Meshram,et al.  Implementing Joins over HBase on Cloud Platform , 2014, 2014 IEEE International Conference on Computer and Information Technology.

[5]  Ching-Hsien Hsu,et al.  Correlation Aware Technique for SQL to NoSQL Transformation , 2014, 2014 7th International Conference on Ubi-Media Computing and Workshops.