Agenda

17
Oct

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

General public Colloquium / Congress / Forum

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.


When? 17.10.2022 10:00
Where? PER 21 G230
Bd de Pérolles 90
1700 Fribourg
speaker Assistant Professor Tianzheng Wang, Simon Fraser University (SFU), Vancouver
Contact Département d'Informatique
Stéphanie Fasel
stephanie.fasel@unifr.ch
Bd de Pérolles 90
1700 Fribourg
0263008322
Attachment
backtolist