How to get online transactional schema evolution (almost) for free in snapshot databases

Kolloquium / Kongress / Forum
Breite Öffentlichkeit
17.10.2022 10:00

Modern database applications often change/evolve their schema, which is a necessary yet often an operation described as "dicey" or "dangerous" due to insufficient support in existing systems. More often than not, application developers find themselves using ad hoc schema evolution features that are provided by DBMS vendors as "patches" to an existing system that is not designed with transactional schema evolution in mind. This leads to various issues such as missing features, poor performance and corner cases that require manual intervention by the application developers. In this talk, we revisit the problem and solve the problem with a new data-definition-as-modification (DDaM) approach that makes online transactional schema evolution a first-class citizen in the database engine level. DDaM fits nicely with MVCC and allows us to seamlessly model schema evolution as table modification operations without the aforementioned drawbacks. We will then describe the Tesseract system, a realization of DDaM with optimizations on a modern multi-versioned main memory OLTP engine, and discuss future directions in this line of work.
17.10.2022 10:00
Standort PER 21 / Raum G230
Bd de Pérolles 90, 1700 Fribourg
Département d'Informatique
Stéphanie Fasel
Bd de Pérolles 90
1700 Fribourg
Vortragende / Mitwirkende
Assistant Professor Tianzheng Wang, Simon Fraser University (SFU), Vancouver