在資料表關連架構轉換過程中有效保留約束條件以強化從MySQL至HBase的資料庫轉移程序

Constraints Preserving in Schema Transformation to Enhance Database Migration from MySQL to HBase

馬英妲(Intan Maghfirah)

指導教授 ： 鍾葉青

國立清華大學/電機資訊學院/資訊系統與應用研究所/碩士(2014年)

摘要

In the last few years, the number of Internet users and the number of data transactions on the web applications are not as much as today. Current and existing relational database is sufficient to set the data transaction. Today, more and more users are active on the internet and use applications that are also connected to the Internet. Then data that must be managed by a database increases. It make relational database difficult to manage it continuously then will lead to data processing problem. Finally, NoSQL is developed as a new data management system to issue this problem. Both of these database, RDBMS (Relational Database Management System) and NoSQL, have their own advantages and disadvantages in managing data. Many studies had been done to utilize advantages that provided by relational database and NoSQL database. Database migration is also an option for companies or organization to migrate big data into NoSQL database and use NoSQL functionality to handle this data. Whereas migrating data, some of information about integrity constraint that define in relational database is missing. During the migration, information of the previous database from relational database to another database can be stored in a well-designed data structure such as XML. Therefore database migration consists of two phases: schema transformation and data migration. Schema transformation could transform the integrity constraints and manage it. In this study, database migration is purpose from MySQL to HBase. Data migration tool is used to transfer data from MySQL to HBase. Furthermore, this study focuses more on maintaining the integrity constraints that lost from the data migrating process by generating schema file in HBase independently. In the end, this schema information could validate query from user based on integrity constraints that preserved.

關鍵字

完整性約束 ； 數據庫遷移 ； HBase

並列摘要

無資料

並列關鍵字

integrity constraints ； database migration

參考文獻

[8] "Sqoop," The Apache Software Foundation, 2014. [Online]. Available: http://sqoop.apache.org/.

[9] I. T. Varley, "No Relation: The Mixed Blessing of Non-Relational Databases," 2009.

[11] R. Fagin, L. M. Haas, M. Hernandez, R. J. Mileer, L. Popa and Y. Velegrakis, "Clio: Schema Mapping Creation and Data Exchange," Lecture Notes in Computer Science Vol. 5600, pp.198-236, 2009.

[12] X. Yang and G. Wang, "Mapping Refrential Integrity Constriants from Relational Database to XML," Lecture Notes in Computer Science, vol. 2118, pp. 329-340, 2001.

[13] S. Subramaniam, S.-C. Haw and P. K. Hoong, "s-XML: An Efficient Mapping Scheme to Bridge XML and Relational Database," Knowledge Based System, vol. 27, pp. 369-380, 2012.