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.

[1] M. Michalewicz, B. Clouse and J. McHugh , "Oracle Real Application Clusters (RAC)," 2013.
[2] J. Zhu, "Data Modeling for Big Data," CA Technologies, 2012. [Online]. Available: http://www.ca.com/us/~/media/Files/Articles/ca-technology-exchange/data-modeling-for-big-data-zhu-wang.pdf.
[3] J. Roijackers, "Bridging SQL and NoSQL," 2012.
[4] "MongoDB," MongoDB, Inc, 2014. [Online]. Available: http://www.mongodb.com/customers/foursquare.
[5] M. Kjellman, "MySQL to Cassandra Migrations," 2014. [Online].
[6] Basho, "Riak Data Migration," Basho Technologies, Inc., 19 November 2013. [Online].
[7] C. Li, "Transforming Relational Database into HBase: A Case Study," Software Engineering and Service Science (ICSESS), IEEE International Conference, pp. 683-687, 2010.
[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.
[10] L. Popa, Y. Velegrakis, M. A. Hernandez, R. J. Miller and R. Fagin, "Translating Web Data," in The 28th International conference on Very Large Database (VLDB'02), 2002.
[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.
[14] R. Kaur, "A Novel Algorithm for Transforming Row-Oriented Database into Column-Oriented Database," Master Thsesis, Department of Computer Science and Engineering, Thapar University, Patiala, 2013.
[15] "MySQL," Oracle Corporation and/or its affiliates, 2014. [Online]. Available: http://www.mysql.com/.
[16] R. Cattel, "Scalable SQL and NoSQL Data Store," in SIGMOD Rec. 39, 2011.
[17] "Apache Phoenix," Apache Software Foundation , 2014. [Online]. Available: http://phoenix.apache.org/index.html.
[18] R. Elmasari and S. B. Navathe, Fundamentals of Database Systems, Boston, MA, USA: Addison-Weasley Longman Publishing Co., Inc, 2006.
[19] "Fusion Forge," Fusion Forge, [Online]. Available: http://pgfoundry.org/projects/dbsamples/.