Abstract
Since the typical feature of a real-world application is evolution, i.e. changes in user requirements, the problem of change propagation is an important task. In this paper we study its specific part – evolution of a relational database schema and its impact on related SQL queries. The proposed approach shows an ability to model database queries together with a database schema. The feature then provides a solution how to adapt database queries related to the evolved database schema. The proposal was implemented within a complex evolution framework called DaemonX and various experiments proving the concept were carried out.
This work was supported by the grant SVV-2013-267312 and GAUK grant no. 1416213.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
SPARQL Query Language for RDF. W3C (2008), http://www.w3.org/TR/rdf-sparql-query/
Adventure Works team. Adventure Works 2008R2 (November 2010), http://msftdbprodsamples.codeplex.com
Chytil, M.: Adaptation of Relational Database Schema. Master’s thesis, Charles University in Prague (2012), http://www.ksi.mff.cuni.cz/~holubova/dp/Chytil.pdf
DaemonX-Team. DaemonX (June 2001), http://daemonx.codeplex.com
Korovin, K.: CNF and Clausal Form. In: Logic in Computer Science, Lecture Notes (2006)
Miller, J., Mukerji, J.: MDA Guide Version 1.0.1 (2003), http://www.omg.org/mda/mda_files/MDA_Guide_Version1-0.pdf
Papastefanatos, G., Vassiliadis, P., Simitsis, A., Aggistalis, K., Pechlivani, F., Vassiliou, Y.: Language Extensions for the Automation of Database Schema Evolution. In: Cordeiro, J., Filipe, J. (eds.) ICEIS (1), pp. 74–81 (2008)
Papastefanatos, G., Vassiliadis, P., Vassiliou, Y.: Adaptive Query Formulation to Handle Database Evolution. In: Proceedings of the CAiSE Forum (2006)
W3 Consortium. XQuery 1.0: An XML Query Language, W3C Working Draft (November 12, 2003), http://www.w3.org/TR/xquery/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Chytil, M., Polák, M., Nečaský, M., Holubová, I. (2014). Evolution of a Relational Schema and Its Impact on SQL Queries. In: Zavoral, F., Jung, J., Badica, C. (eds) Intelligent Distributed Computing VII. Studies in Computational Intelligence, vol 511. Springer, Cham. https://doi.org/10.1007/978-3-319-01571-2_2
Download citation
DOI: https://doi.org/10.1007/978-3-319-01571-2_2
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-01570-5
Online ISBN: 978-3-319-01571-2
eBook Packages: EngineeringEngineering (R0)