τMySQL

Overview

Transaction-time support in MySQL comes as a module which can be added to a preexisting installation of MySQL. The original programs and procedures will work as before, with the added feature of being able to refer to modified/deleted data once this temporal support is applied to MySQL.

Certain tables can be designated as transaction-time tables. All the regular commands work for for those tables. However, internally all previous data in the table is retained. At a later date these changes can be brought to light, therefore checking for mistakes or malicious intent. This functionality helps in preventing or at least detecting corporate fraud and malpractice. Transaction-time support gives the authorized person complete information about what was changed in the table and when.

People

Faculty:
Christian S. Collberg
Richard T.Snodgrass (Director)

Graduate Students:

Previous Graduate Students:
Natasha Gaitonde
Supratik Maitra
Manigantan Sethuraman
Shilong (Stanley) Yao

Webmaster: Qing Ju