Caching for disk based hybrid transactional analytical processing system

A computer-implemented method, comprising:

• receiving a query;
• in response to the query requiring a modification of data in a database table of a database, determining to load, from a disk into a memory, a first portion of a data page, the memory including a first cache for storing partial data pages and a second cache for storing full data pages;
• in response to determining to load the first portion of the data page, applying one or more cache replacement policies to evict a partial data page from the first cache, the loading of the first portion of the data page into the first cache evicting the partial data page from the first cache instead of evicting a full data page from the second cache;
• updating a first data structure to indicate that the first portion of the data page has been loaded into the first cache;
• in response to the first data structure indicating that the loading of the first portion of the data page loads the data page into the first cache in its entirety, applying the one or more cache replacement policies to evict the full data page from the second cache before transferring the data page from the first cache to the second cache;
• and
• in response to the first data structure indicating that one or more other portions of the data page are not present in the first cache, keeping the first portion of the data page in the first cache instead of transferring the first portion of the data page to the second cache.

A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:

• receiving a query;
• in response to the query requiring a modification of data in a database table of a database, determining to load, from a disk into a memory, a first portion of a data page, the memory including a first cache for storing partial data pages and a second cache for storing full data pages;
• in response to determining to load the first portion of the data page, applying one or more cache replacement policies to evict a partial data page from the first cache, the loading of the first portion of the data page into the first cache evicting the partial data page from the first cache instead of evicting a full data page from the second cache;
• updating a first data structure to indicate that the first portion of the data page has been loaded into the first cache;
• in response to the first data structure indicating that the loading of the first portion of the data page loads the data page into the first cache in its entirety, applying the one or more cache replacement policies to evict the full data page from the second cache before transferring the data page from the first cache to the second cache;
• and
• in response to the first data structure indicating that one or more other portions of the data page are not present in the first cache, keeping the first portion of the data page in the first cache instead of transferring the first portion of the data page to the second cache.