Supporting transient snapshot with coordinated/uncoordinated commit protocol

Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated....

Full description

Saved in:
Bibliographic Details
Main Authors Canim, Mustafa, Hamedani, Mohammad S, Storm, Adam J, Bhattacharjee, Bishwaranjan, Ross, Kenneth A
Format Patent
LanguageEnglish
Published 07.08.2018
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.
Bibliography:Application Number: US201414509683