Optimization of application of transactional information for a hybrid transactional and analytical processing architecture

A method, comprising:

• maintaining, at an analytical database implemented by one or more compute nodes organized into a node cluster, a representation of at least a portion of a table comprising data items, wherein:
• the table is stored in a separate transactional database, implemented via one or more computing devices;
• and
• the maintaining comprises:
• receiving respective snapshots of segments of the at least a portion of the table of the separate transactional database;
• receiving checkpoints relative to the respective snapshots, wherein:
• the checkpoints comprise transactional changes that have been applied at the separate transactional database;
• the transactional changes of a given checkpoint comprise two or more delete events;
• and
• the transactional changes are labeled with respective primary keys corresponding to respective rows that the transactional changes occur at in the separate transactional database;
• and
• implementing the transactional changes of the given checkpoint to its corresponding snapshot, wherein the implementing comprises:
• committing the two or more delete events to a shadow table;
• and
• responsive to the shadow table having a given threshold of committed delete events of the two or more delete events, committing the committed delete events in the shadow table to the corresponding snapshot;
• and
• providing, responsive to receiving an incoming analytical query, the results of the incoming analytical query based, at least in part, on the committed delete events in the shadow table.

One or more non-transitory, computer-readable storage media storing program instructions that when executed on or across one or more processors, cause the one or more processors to:

• maintain, at an analytical database, a representation of at least a portion of a table comprising data items, wherein:
• the at least the portion of the table is stored at a separate transactional database;
• and
• to maintain comprises:
• receive respective snapshots of segments of the at least a portion of the table of the separate transactional database;
• receive checkpoints relative to the respective snapshots, wherein:
• the checkpoints comprise transactional changes that have been applied at the separate transactional database;
• the transactional changes of a given checkpoint comprise two or more delete events;
• and
• the transactional changes are labeled with respective primary keys corresponding to respective rows that the transactional changes occur at in the separate transactional database;
• and
• implement the transactional changes of the given checkpoint to its corresponding snapshot, wherein the implementation of the transactional changes comprises:
• commit the two or more delete events to a shadow table;
• and
• responsive to the shadow table having a given threshold of committed delete events of the two or more delete events, commit the committed delete events in the shadow table to the corresponding snapshot;
• and
• provide, responsive to receiving an incoming analytical query, the results of the incoming analytical query based, at least in part, on the committed delete events in the shadow table.