Supporting transient snapshot with coordinated/uncoordinated commit protocol

A computer program product for supporting transient snapshot, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method comprising:

• maintaining an in-page log for records in each of a plurality of data pages of a multi-version database;
• adding record update information to the in-page log when a corresponding one of the records is deleted or updated;
• 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;
• and
• spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full;
• wherein the data pages comprise any of row-oriented data pages and column-oriented data pages.

A computer program product for supporting transient snapshot, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method comprising:

• maintaining an in-page log for records in each of a plurality of data pages of a database;
• adding record update information to the in-page log when a corresponding one of the records is deleted or updated;
• 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;
• and
• splitting, by a processor-based overflow manager, a given data page of data into a first page and a second page with at least a portion of the data and at least a portion of the in-page log on the first page and a remainder of the data and a remainder of the in-page log on the second page when the in-page log on the given data page is full;
• wherein the data pages comprise any of row-oriented data pages and column-oriented data pages.

A system, comprising:

• a processor-based in-page log manager for maintaining an in-page log for records in each of a plurality of data pages of a multi-version database, adding record update information to the in-page log when a corresponding one of the records is deleted or updated, and 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;
• and
• a processor-based overflow manager for spilling to overflow pages when the in-page log is full or splitting a given data page of data into a first page and a second page with at least a portion of the data and at least a portion of the in-page log on the first page and a remainder of the data and a remainder of the in-page log on the second page when the in-page log on the given data page is full;
• wherein the data pages comprise any of row-oriented data pages and column-oriented data pages.