Living in parallel realities - Co-existing schema versions with a bidirectional database evolution language
Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/Gutachten › Beitrag in Konferenzband › Beigetragen › Begutachtung
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
Originalsprache | Englisch |
---|---|
Titel | SIGMOD '17: Proceedings of the 2017 ACM International Conference on Management of Data |
Herausgeber (Verlag) | Association for Computing Machinery (ACM), New York |
Seiten | 1101-1116 |
Seitenumfang | 16 |
ISBN (Print) | 978-1-4503-4197-4 |
Publikationsstatus | Veröffentlicht - 9 Mai 2017 |
Peer-Review-Status | Ja |
Publikationsreihe
Reihe | MOD: International Conference on Management of Data (SIGMOD) |
---|
Konferenz
Titel | 2017 ACM SIGMOD International Conference on Management of Data, SIGMOD 2017 |
---|---|
Dauer | 14 - 19 Mai 2017 |
Stadt | Chicago |
Land | USA/Vereinigte Staaten |
Externe IDs
ORCID | /0000-0001-8107-2775/work/142253569 |
---|
Schlagworte
ASJC Scopus Sachgebiete
Schlagwörter
- Co-existing schema versions, Database evolution