A study of data migration from relational database to cloud database

• Main Authors: Chun-ting Chen, 陳俊廷
• Other Authors: Ming-Chuan Hong
• Format: Others
• Language: zh-TW
• Published: 2012
• Online Access: http://ndltd.ncl.edu.tw/handle/94574912437002841166

碩士 === 逢甲大學 === 工業工程與系統管理學研究所 === 100 === Cloud computing is the delivery of computing and storage capacity as a service to a community of the end-users. For the Internet era of information explosion, the general applications frequently encounter the many problems of the network traffic. Most enterprises must install the high-price server and extend their network bandwidth. Thus, the cloud computing become one of feasible solutions, but the database schema is very different between relationship database and cloud database. How to migrate the data from traditional relationship database to the cloud computing, it is a key problem. This thesis proposed an effective and feasible approach to migrate the data from RDBMS to cloud database. For a case study from MySQL DB to Apache HBase, how to maintain the relational database tables with its attributes for migration. The HBase is based on column oriented which is not support SQL commands to successfully retrieve data from the relationship tables using join calculation. We design a simple RDBMS application to generate a huge data and to simulate the database data migration. In the experiments, we verify the integrity and correctness of the migrated data using Hive and Sqoop tools. At the same time, we compare the query performance between the relational database and cloud database, the results approved the cloud database is really better than traditional relational database. Therefore, we confirm the proposed is an effective and feasible approach, it will be able to assist the enterprises to migrate the legacy DB system to the cloud DB.