Database caching in a database system

A computer-implemented method, the method comprising:

• configuring, by a processor based on configuration details, an intermediate non-volatile cache memory layer for caching pages of a set of databases stored on a set of database storage devices of a database system, the intermediate non-volatile cache memory layer being configured to communicate with at least one main memory cache storage device and the set of database storage devices and includes an in-memory non-volatile metadata cache portion to store metadata associated with a database page and a non-volatile disk portion to persist corresponding data of the database page, the in-memory non-volatile metadata cache and the non-volatile disk portion of the intermediate non-volatile cache memory layer being separate and distinct from each other;
• receiving, at the intermediate non-volatile cache memory layer, a request associated with the at least one main memory storage device to execute an operation on content stored in a first database of the set of databases, the content being associated with a first page of a plurality of database pages;
• identifying, by the processor, the first page associated with the requested content;
• and
• executing, by the processor, a caching operation on the intermediate non-volatile cache memory layer for the requested operation, the execution of the requested operation being based on an evaluation of metadata associated with the identified first page stored in the in-memory non-volatile metadata cache of the intermediate non-volatile cache memory layer.

A non-transitory computer-readable medium storing program instructions thereon, the medium comprising:

• instructions to configure, based on configuration details, an intermediate non-volatile cache memory layer for caching pages of a set of databases stored on a set of database storage devices of a database system, the intermediate non-volatile cache memory layer being configured to communicate with at least one main memory cache storage device and the set of database storage devices and includes an in-memory non-volatile metadata cache portion to store metadata associated with a database page and a non-volatile disk portion to persist corresponding data of the database page, the in-memory non-volatile metadata cache and the non-volatile disk portion of the intermediate non-volatile cache memory layer being separate and distinct from each other;
• instructions to receive, at the intermediate non-volatile cache memory layer, a request associated with the at least one main memory storage device to execute an operation on content stored in a first database of the set of databases, the content being associated with a first page of a plurality of database pages;
• instructions to identify the first page associated with the requested content;
• and
• instructions to execute a caching operation on the intermediate nonvolatile cache memory layer for the requested operation, the execution of the requested operation being based on an evaluation of metadata associated with the identified first page stored in the in-memory non-volatile metadata cache of the intermediate non-volatile cache memory layer.