Abstract
Schema evolution is an important theme for many database users across a broad range of fields. This paper introduces a generic data management layer, GeneRelDB, which allows the schema of a relational database to evolve during run time without the need to rewrite database queries in the application code. It is designed to run as an abstraction layer, handling all communication (queries and data exchange) between the user interface and the database backend. The only restriction to the changes that can be made relate to data type conversion for existing columns in the database. Foreign key constraints are supported and referential integrity is maintained during evolution.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
MongoDB: The MongoDB 4.0 Manual (2019). https://docs.mongodb.com/manual/
Amazon Web Services: Amazon DynamoDB Developer Guide. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.html
Apache CouchDB: CouchDB Technical overview (2019). http://docs.couchdb.org/
Qiu, D., Li, B., Su, Z.: An empirical analysis of the co-evolution of schema and code in database applications. In: Foundations of Software Engineering, pp. 125–135. ACM (2013)
Rahm, E., Bernstein, P.A.: An online bibliography on schema evolution. SIGMOD Rec. 35 (4) (30–31) (2006)
Lin, Q., Pu, C., Lee, E.K.: A model-driven approach to manage evolving clinical and translational data in relational databases. In: International Conference on Bioinformatics and Biomedicine. IEEE (2008)
Curino, C.A., Moon, H.J., Deutsch, A., Zaniolo, C.: Update rewriting and integrity constraint maintenance in a schema evolution support system: PRISM++. Proc. VLDB Endowment 4(2), 117–128 (2010). https://doi.org/10.14778/1921071.1921078
de Jong, M., van Deursen, A., Cleve, A.: Zero-downtime SQL database schema evolution for continuous deployment. In: 39th International Conference on Software Engineering, pp. 143–152. IEEE (2017). https://doi.org/10.1109/icse-seip.2017.5
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
de Bhróithe, A.O. et al. (2020). A Generic Approach to Schema Evolution in Live Relational Databases. In: Borzemski, L., Świątek, J., Wilimowska, Z. (eds) Information Systems Architecture and Technology: Proceedings of 40th Anniversary International Conference on Information Systems Architecture and Technology – ISAT 2019. ISAT 2019. Advances in Intelligent Systems and Computing, vol 1050. Springer, Cham. https://doi.org/10.1007/978-3-030-30440-9_11
Download citation
DOI: https://doi.org/10.1007/978-3-030-30440-9_11
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-30439-3
Online ISBN: 978-3-030-30440-9
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)