Living in parallel realities - Co-existing schema versions with a bidirectional database evolution language

Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/GutachtenBeitrag in KonferenzbandBeigetragenBegutachtung

Beitragende

Abstract

We introduce end-to-end support of co-existing schema versions within one database. While it is state of the art to run multiple versions of a continuously developed application concurrently, it is hard to do the same for databases. In order to keep multiple co-existing schema versions alive-which are all accessing the same data set-developers usually employ handwritten delta code (e.g. views and triggers in SQL). This delta code is hard to write and hard to maintain: if a database administrator decides to adapt the physical table schema, all handwritten delta code needs to be adapted as well, which is expensive and error-prone in practice. In this paper, we present InVerDa: developers use the simple bidirectional database evolution language BiDEL, which carries enough information to generate all delta code automatically. Without additional effort, new schema versions become immediately accessible and data changes in any version are visible in all schema versions at the same time. InVerDa also allows for easily changing the physical table design without affecting the availability of co-existing schema versions. This greatly increases robustness (orders of magnitude less lines of code) and allows for significant performance optimization. A main contribution is the formal evaluation that each schema version acts like a common full-fledged database schema independently of the chosen physical table design.

Details

OriginalspracheEnglisch
TitelSIGMOD '17: Proceedings of the 2017 ACM International Conference on Management of Data
Herausgeber (Verlag)Association for Computing Machinery (ACM), New York
Seiten1101-1116
Seitenumfang16
ISBN (Print)978-1-4503-4197-4
PublikationsstatusVeröffentlicht - 9 Mai 2017
Peer-Review-StatusJa

Publikationsreihe

ReiheMOD: International Conference on Management of Data (SIGMOD)

Konferenz

Titel2017 ACM SIGMOD International Conference on Management of Data, SIGMOD 2017
Dauer14 - 19 Mai 2017
StadtChicago
LandUSA/Vereinigte Staaten

Externe IDs

ORCID /0000-0001-8107-2775/work/142253569

Schlagworte

ASJC Scopus Sachgebiete

Schlagwörter

  • Co-existing schema versions, Database evolution