Migrating University’s Database to the Cloud - Framework and Validation

Lydiah W. Gachanja^1, and Andrew M Kahonge¹

¹Department of Computing and Informatics, University of Nairobi, Kenya

Cite this paper:
Lydiah W. Gachanja and Andrew M Kahonge. Migrating University’s Database to the Cloud - Framework and Validation. American Journal of Computing Research Repository. 2016; 4(1):1-6. doi: 10.12691/ajcrr-4-1-1

Abstract

All migration projects require careful planning and good methodology to ensure proper execution. Migrating enterprise data to cloud is a difficult task. Efforts to standardize cloud data migration has been going on and several frameworks have been proposed; most of them are technology-dependent and vendor-dependent frameworks. In an attempt to tackle this problem a technology-vendor-independent database migration is presented. It is achieved by adapting and revising several migration methodologies. To realize the framework, dummy MySQL database and a web-based data migration tool was used to migrate data to Google public cloud. It emerges that the framework is worth pursuing, because ensures most critical aspects of cloud migration are put into consideration. The framework will be of significant contribution to cloud data migration maturity and standardization and will help educational establishments in migrating their database to cloud because all security aspects are put into consideration. The tool used did not support the last two step of the proposed framework therefore we propose further work on designing a tool that supports the framework.

Keywords:
higher education framework database as a service cloud database cloud computing

This work is licensed under a Creative Commons Attribution 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by/4.0/

References:

[1]	Andrikopoulos, V., Binz, T., Leymann, F. and Strauch, S. (2013) ‘How to adapt applications for the cloud environment’, in Computing, Vol. 95, No. 6, pp.493-535, Springer.
[2]	Armbrust, M. et al. (2009) ‘Above the clouds: a Berkeley view of cloud computing’, Technical Report UCB/EECS-2009-28, EECS Department, University of California, Berkeley.
[3]	Elmore, A. Curino, C, Agrawal, D, & Abbadi, A (2013) ‘Towards Database Virtualization for Database as a Service’, proceedings of VLDB Endowment, Vol. 6, No. 11, viewed 23rd June 2014 db.disi.unitn.ed/pages/VLDBprogram/pdf/tutorial/tut.pdf.
[4]	Jain, A & Pandey, U(2013), Role of Cloud Computing in Higher Education, International Journal of Advanced Research in Computer Science and Software Engineering 3(7), pp. 966-972, viewed 2nd June 2014 www.ijarcsse.com.
[5]	Jamshidi, P., Ahmed, A. and Pahl, C. (2013) Cloud Migration Research – A Systematic Review. IEEE Transactions of Cloud Computing, Vol. 1, Issue 2, viewed 12th July 2015 http://doras.dcu.ie/19636/1/TCC-AuthorsVersion.pdf.
[6]	Laszewski, T. and Nauduri, P. (2011), Migrating to the cloud- Oracle Client Server Modernization, viewed on 17th July 2015 http://www.oracle.com/technetwork/articles/cloudcomp/migrating-to-the-cloud-chap-3-495856.pdf.
[7]	Masud, A, Yong J, & Huang, X (2012), ‘Cloud Computing for Higher Education: A Roadmap.’ Proceedings of the IEEE 16th International Conference on Computer Supported Cooperative work in design, viewed 21st June 2014 https://www.researchgate.net/publication/234801620_Cloud_Computing_for_Higher_Education_A_Roadmap.
[8]	Morris, J. (2012), Practical Data Migration, 2nd Edition , BSD The Chartered Institute for IT UK.
[9]	Paul, N (2009), Why use stored procedures? Viewed on 12th June 2014 http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/wh y-use-stored-procedures.aspx.
[10]	Sabalage, P.J. and Fowler, M. (2012) NoSQL Distilled: A brief Guide to the Emerging World of Polyglot Persistence, viewed 2th July 2015 http://bigbe.su/lectures/2014/15.3.pdf.
[11]	Strauch, S., Andrikopoulos, V., Bachman, T. and Leyman, F. (2013a) migrating application data to the cloud using cloud data patterns, in proceedings of CLOSER’13 SciTepress viewed on 12th July 2015 http://www.iaas.uni-stuttgart.de/RUS-data/INPROC-2013-16%20-%20Migrating%20Application%20 Data%20to%20the%20Cloud%20Using%20Cloud%20Data%20Patterns.pdf.
[12]	Strauch S., Andrikopoulos V., Karastoyanova D., Leymann F. (2014), Migrating Enterprise Application to Cloud: Methodology and Evaluation, International Journal of Big Data Intelligence viewed 14th June 2015 www.innderscience.com/ijbdi.
[13]	Varia, J. (2010) Migrating your Existing Application to AWS cloud. A Phase Driven Approach to Cloud Migration, viewed 12th July 2015 http://media.amazonwebservices.com/CloudMigration-main.pdf.
[14]	Victor, RK, Sigar, KO, Odongo GY (2013), Meta-Modelling Cloud Computing Architecture in Distance Learning, International Journals of Computer science issues, Vol. 10, Issue 3, No. 1, viewed 16th October 2014 http://ijcsi.org/papers/IJCSI-10-3-1-66-72.pdf.
[15]	Waleed, A (2013), Cloud database: database as a service, International Journal of Database Management Systems ( IJDMS ) Vol.5, No.2, viewed 24th June airccse.org/journal/ijdms/papers/5213ijdms01.pdf.