Title
Continuous Deployment and Schema Evolution in SQL Databases
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.
Year
DOI
Venue
2015
10.1109/RELENG.2015.14
RELENG@ICSE
Field
DocType
ISBN
SQL,Persistent data structure,Software deployment,Computer science,Database schema,Foreign key,Downtime,Schema evolution,Schema (psychology),Database
Conference
978-1-4503-4399-2
Citations 
PageRank 
References 
2
0.38
0
Authors
2
Name
Order
Citations
PageRank
Michael de Jong160.78
A. van Deursen24034254.98