Workload-aware page management for in-memory databases in hybrid main memory systems

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations comprising:

• receiving a sorted list of pages, each page corresponding to a fixed-length contiguous block of virtual memory, and being associated with a respective state, each state indicating a number of off-chip accesses determined for a respective page;
• and
• executing an application, which queries an in-memory database provided with a hybrid memory system, and, during execution of the application:
• identifying at least one page in the sorted list of pages as a page that is to-be-locked during execution of the application based on a threshold, and
• locking the at least one page in main memory to inhibit swapping of the at least one page by an operating system.

A system, comprising:

• a computing device;
• and
• a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations comprising:
• receiving a sorted list of pages, each page comprising a fixed-length contiguous block of virtual memory, and being associated with a respective state, each state indicating a number of off-chip accesses determined for a respective page;
• and
• executing an application, which queries an in-memory database provided with a hybrid memory system, and, during execution of the application:
• identifying at least one page in the sorted list of pages as a page that is to-be-locked during execution of the application based on a threshold, and
• locking the at least one page in main memory to inhibit swapping of the at least one page by an operating system.