Standard

Continuous deployment and schema evolution in SQL databases. / de Jong, Michael ; Van Deursen, Arie.

Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015. Institute of Electrical and Electronics Engineers (IEEE), 2015. p. 16-19 7169446.

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

Harvard

de Jong, M & Van Deursen, A 2015, Continuous deployment and schema evolution in SQL databases. in Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015., 7169446, Institute of Electrical and Electronics Engineers (IEEE), pp. 16-19, 3rd International Workshop on Release Engineering, RELENG 2015, Florence, Italy, 19/05/15. https://doi.org/10.1109/RELENG.2015.14

APA

de Jong, M., & Van Deursen, A. (2015). Continuous deployment and schema evolution in SQL databases. In Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015 (pp. 16-19). [7169446] Institute of Electrical and Electronics Engineers (IEEE). https://doi.org/10.1109/RELENG.2015.14

Vancouver

de Jong M, Van Deursen A. Continuous deployment and schema evolution in SQL databases. In Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015. Institute of Electrical and Electronics Engineers (IEEE). 2015. p. 16-19. 7169446 https://doi.org/10.1109/RELENG.2015.14

Author

de Jong, Michael ; Van Deursen, Arie. / Continuous deployment and schema evolution in SQL databases. Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015. Institute of Electrical and Electronics Engineers (IEEE), 2015. pp. 16-19

BibTeX

@inproceedings{3534d831f60b460198258dde69edf12b,
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.",
author = "{de Jong}, Michael and {Van Deursen}, Arie",
year = "2015",
doi = "10.1109/RELENG.2015.14",
language = "English",
pages = "16--19",
booktitle = "Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015",
publisher = "Institute of Electrical and Electronics Engineers (IEEE)",
address = "United States",
note = "3rd International Workshop on Release Engineering, RELENG 2015 ; Conference date: 19-05-2015",

}

RIS

TY - GEN

T1 - Continuous deployment and schema evolution in SQL databases

AU - de Jong, Michael

AU - Van Deursen, Arie

PY - 2015

Y1 - 2015

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=84962284951&partnerID=8YFLogxK

U2 - 10.1109/RELENG.2015.14

DO - 10.1109/RELENG.2015.14

M3 - Conference contribution

AN - SCOPUS:84962284951

SP - 16

EP - 19

BT - Proceedings - 3rd International Workshop on Release Engineering, RELENG 2015

PB - Institute of Electrical and Electronics Engineers (IEEE)

T2 - 3rd International Workshop on Release Engineering, RELENG 2015

Y2 - 19 May 2015

ER -

ID: 7471618