Abstract
This paper reports on an early experience of partially migrating a legacy systems’ relational database to a NoSQL database in the Amazon cloud. The migration process involved converting part of the relational database data to the schema-less format supported by the target NoSQL database, and adapting the two software applications that make up the system (developed using Grails and Groovy, respectively) to transparently access both the relational database on-premise and the NoSQL database in the cloud. The required software adaptations were performed using a non-intrusive approach based on aspect-oriented programming (in the case of the Grails application) and meta-programming features (in the case of the Groovy application). This approach allowed the system to be easily adapted and tested, without the need to change its source code directly.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
Notes
- 1.
It is out of the scope of this paper to address the consequences of the data normalization loss.
- 2.
The other table fields were left out since they are irrelevant to understand the solution.
- 3.
References
Costa, C.H., Filho, J., Maia, P.H.M., Oliveira, F.: Sharding by Hash partitioning. A database scalability pattern to achieve evenly sharded database clusters. In: International Conference on Enterprise Information Systems (2015)
Sadalage, P., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley, Reading (2013)
Sivasubramanian, S.: Amazon dynamoDB: a seamlessly scalable non-relational database service. In: ACM SIGMOD International Conference on Management of Data (2012)
Jamshidi, P., Ahmad, A., Pahl, C.: Cloud migration research: a systematic review. IEEE Trans. Cloud Comput. 1, 142–157 (2013)
Schram, A., Anderson, K.M.: MySQL to NoSQL: data modeling challenges in supporting scalability. In: 3rd Annual Conference on Systems, Programming, and Applications: Software for Humanity (2012)
Vu, Q.H., Asal, R.: Legacy application migration to the cloud: practicability and methodology. In: IEEE Eighth World Congress on Services (2012)
Chauhan, M.A., Babar, M.A.: Migrating service-oriented system to cloud computing: an experience report. In: IEEE 4th International Conference on Cloud Computing (2011)
Vasconcelos, M., Mendonça, N.C., Maia, P.H.M.: Cloud detours: a non-intrusive approach for automatic software adaptation to the cloud. In: Dustdar, S., et al. (eds.) ESOCC 2015. LNCS, vol. 9306, pp. 181–195. Springer, Heidelberg (2015)
Knig, D., Laforge, G., King, P., Champeau, C., D’Arcy, H., Pragt, E., Skeet, J.: Groovy in Action. Manning Publications Co., Greenwich (2007)
Fischer, R.: Grails Persistence with GORM and GSQL. Apress, Berkeley (2009)
Kiselev, I.: Aspect-Oriented Programming with AspectJ. Sams, Indianapolis (2012)
McClean, J.: Painless AOP with Groovy. InfoQ, October 2006. http://www.infoq.com/articles/aop-with-groovy. Accessed on 28 March 2016
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Costa, C.H., Maia, P.H.M., Mendonça, N.C., Rocha, L.S. (2016). Supporting Partial Database Migration to the Cloud Using Non-intrusive Software Adaptations: An Experience Report. In: Celesti, A., Leitner, P. (eds) Advances in Service-Oriented and Cloud Computing. ESOCC 2015. Communications in Computer and Information Science, vol 567. Springer, Cham. https://doi.org/10.1007/978-3-319-33313-7_18
Download citation
DOI: https://doi.org/10.1007/978-3-319-33313-7_18
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-33312-0
Online ISBN: 978-3-319-33313-7
eBook Packages: Computer ScienceComputer Science (R0)