BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//UNIFR/WEBMASTER//NONSGML v1.0//EN
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART;VALUE=DATE:20221017T100000
DTEND;VALUE=DATE:20221017T100000
UID:12224@agenda.unifr.ch
DESCRIPTION: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.
SUMMARY:How to get online transactional schema evolution (almost) for free in snapshot databases
CATEGORIES:Colloque / Congrès / Forum
LOCATION:PER 21\, G230\, Bd de Pérolles 90\, 1700 Fribourg
URL;VALUE=URI:https://agenda.unifr.ch/e/fr/12224
END:VEVENT
END:VCALENDAR