Basser Seminar Series

Immortal DB: A Compelling Case for Transaction Time Database Systems

Speaker: Dr David Lomet
Principal Researcher, Microsoft Research

Time: Monday 27 April 2009, 5:00-6:00pm Note, different day and time
Refreshments will be available from 4:30pm

Location: The University of Sydney, School of IT Building, Lecture Theatre (Room 123), Level 1

Add seminar to my diary

Abstract

Immortal DB is a transaction time database that is built into the kernel of a commercial database system, Microsoft SQL Server. The Immortal DB goal was to have performance comparable to that of an unversioned current time database, while providing the benefit of being able to access all historical database states with good performance. This ability to access historical database states is an important part of audit functionality, which Immortal DB supplements by being able to identify the user responsible for each transaction. Immortal DB versioning is a high performance implementation of snapshot isolation versioning as well. Further, Immortal DB supports high availability via fast removal of the effects of bad user transactions, which lead to long outages with conventional techniques. The combination of excellent performance with audit and high availability functionality is unique to Immortal DB.

Speaker's biography

David Lomet has been a principal researcher managing the Microsoft Research Database Group at Microsoft Research since 1995. Earlier, he spent seven and a half years at Digital Equipment Corporation. He has been at IBM Research in Yorktown and a Professor at Wang Institute. Dr. Lomet spent a sabbatical at University of Newcastle-upon-Tyne working with Brian Randell. He has a Computer Science Ph.D from the University of Pennsylvania.

Dr. Lomet has done research and product development in architecture, programming languages, and distributed systems. His primary interest is database systems, focusing on access methods, concurrency control, and recovery. He is one of the inventors of the transaction concept and is an author of over 90 papers and 35 patents. Two papers won SIGMOD "best paper" awards.

Dr. Lomet has served on program committees, including ICDE, SIGMOD, VLDB, and PODS. He was ICDE'2000 PC co-chair and VLDB 2006 PC core chair. He is a member of the ICDE Steering Committee and VLDB Board. He is editor-in-chief of the Data Engineering Bulletin since 1992 and past editor of ACM TODS and the VLDB Journal. Dr. Lomet is IEEE Golden Core Member and received IEEE Outstanding Contribution and Meritorious Service Awards. Dr. Lomet is both ACM Fellow and IEEE Fellow.