Print Email Facebook Twitter Continuous deployment and schema evolution in SQL databases Title Continuous deployment and schema evolution in SQL databases Author de Jong, Michael (Student TU Delft) van Deursen, A. (TU Delft Software Technology) Department Software Technology Date 2015 Abstract Continuous Deployment is an important enabler of rapid delivery of business value and early end user feedback. While frequent code deployment is well understood, the impact of frequent change on persistent data is less understood and supported. SQL schema evolutions in particular can make it expensive to deploy a new version, and may even lead to downtime if schema changes can only be applied by blocking operations. In this paper we study the problem of continuous deployment in the presence of database schema evolution in more detail. We identify a number of shortcomings to existing solutions and tools, mostly related to avoidable downtime and support for foreign keys. We propose a novel approach to address these problems, and provide an open source implementation. Initial evaluation suggests the approach is effective and sufficiently efficient. To reference this document use: http://resolver.tudelft.nl/uuid:3534d831-f60b-4601-9825-8dde69edf12b DOI https://doi.org/10.1109/RELENG.2015.14 Publisher IEEE ISBN 978-1-4673-7070-7 Source Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015 Event 3rd International Workshop on Release Engineering, RELENG 2015, 2015-05-19 → , Florence, Italy Part of collection Institutional Repository Document type conference paper Rights © 2015 Michael de Jong, A. van Deursen Files PDF TUD_SERG_2015_013.pdf 379.9 KB Close viewer /islandora/object/uuid:3534d831-f60b-4601-9825-8dde69edf12b/datastream/OBJ/view