Transactional access to records on secondary storage in an in-memory database

A computing system, comprising:

• a processor;
• memory that comprises primary storage, the primary storage comprises a first subset of records of a database, the database being an in-memory database;
• and
• a data store that comprises secondary storage, the secondary storage comprises a second subset of the records of the database;
• the memory further comprises:
• an update memo that comprises timestamp notices specifying statuses for at least a portion of the second subset of the records of the database in the secondary storage;
• and
• a database management system that is executable by the processor, the database management system processes a transaction, the database management system further comprises:
• a storage interface that accesses a record of the database for the transaction based on at least one of the timestamp notices of the update memo.

A method of performing one or more operations on records of a database, a memory comprises a primary storage and a data store comprises a secondary storage, the primary storage comprises a first subset of the records of the database and the secondary storage comprises a second subset of the records of the database, the method comprising:

• checking an access filter in the memory to identify whether to access the secondary storage for a record, the access filter comprises a summary of contents of at least a portion of the secondary storage;
• responsive to the access filter indicating to access the secondary storage for the record, retrieving the record from the secondary storage;
• and
• inserting the record into a private cache for a transaction, the memory comprises the private cache reserved for the transaction.