Continuous deployment and schema evolution in SQL databases

Michael de Jong, Arie Van Deursen

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

7 Citations (Scopus)
196 Downloads (Pure)

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.

Original languageEnglish
Title of host publicationProceedings - 3rd International Workshop on Release Engineering, RELENG 2015
PublisherIEEE
Pages16-19
Number of pages4
ISBN (Electronic)978-1-4673-7070-7
DOIs
Publication statusPublished - 2015
Event3rd International Workshop on Release Engineering, RELENG 2015 - Florence, Italy
Duration: 19 May 2015 → …

Conference

Conference3rd International Workshop on Release Engineering, RELENG 2015
Country/TerritoryItaly
CityFlorence
Period19/05/15 → …

Fingerprint

Dive into the research topics of 'Continuous deployment and schema evolution in SQL databases'. Together they form a unique fingerprint.

Cite this