Systems and methods for reading only durably committed data in a system that otherwise permits lazy commit of transactions

A "lazy commit" allows database transactions to be committed faster by not waiting for log records of the transaction to be written to disk. When a system crash occurs during the commit process, transactions may be lost because the log data is not available to recreate the transaction. Whi...

Full description

Saved in:
Bibliographic Details
Main Authors KATHURIA VISHAL, KODAVALLA HANUMANTHA, ZWILLING MICHAEL J
Format Patent
LanguageEnglish
Published 21.09.2010
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A "lazy commit" allows database transactions to be committed faster by not waiting for log records of the transaction to be written to disk. When a system crash occurs during the commit process, transactions may be lost because the log data is not available to recreate the transaction. While lazy commits speed up processing, they also increase the potential for data inconsistency. This invention introduces the concept of "durable reads"-transactions that require isolation from lazy commit transactions and which must be guaranteed to read only durably committed data. When durable read transaction attempts to read data changed by a lazy commit transaction, the system ensures the lazy commit transaction's changes are first made durable.
Bibliography:Application Number: US20040782988