Database caching in a database system

1. A computer system including a database system, the system comprising:

at least one processor;

a set of database storage devices for the database system, the set of database storage devices being volatile memory storage devices;

at least one main memory cache storage device defining a cache area for the set of database storage devices;

master database tables for storing configuration details defining an intermediate non-volatile cache memory layer; and

a memory in communication with the at least one processor storing program instructions, the at least one processor operative with the program instructions to:

configure, based on the configuration details, an intermediate non-volatile cache memory layer for caching pages of a set of databases stored on the set of database storage devices of the database system, the intermediate non-volatile cache memory layer being configured to communicate with the 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;

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;

identify the first page associated with the requested content; and

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.

2. The system of claim 1 , wherein the at least one processor is further operative with the program instructions to generate a first stored procedure for configuring the intermediate non-volatile cache memory layer.

3. The system of claim 1 , wherein the configuring of the intermediate non-volatile cache memory layer is performed by invoking the first stored procedure, the first stored procedure including the configuration details.

4. The system of claim 1 , wherein the in-memory non-volatile metadata cache comprises data structure buffers to store metadata associated with a database page.

5. The system of claim 1 , wherein the metadata associated with a database page stored in the in-memory non-volatile metadata cache points to a location where the database page is stored on the non-volatile disk portion of the intermediate non-volatile cache memory layer.

6. The system of claim 1 , wherein the intermediate non-volatile cache memory layer is independent of the at least one main memory cache storage device.

7. 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.

8. The method of claim 7 , further comprising generating a first stored procedure for configuring the intermediate non-volatile cache memory layer.

9. The method of claim 7 , wherein the configuring of the intermediate non-volatile cache memory layer is performed by invoking a first stored procedure, the first stored procedure including the configuration details.

10. The method of claim 7 , wherein the in-memory non-volatile metadata cache comprises data structure buffers to store metadata associated with a database page.

11. The method of claim 7 , wherein the metadata associated with a database page stored in the in-memory non-volatile metadata cache points to a location where the database page is stored on the non-volatile disk portion of the intermediate non-volatile cache memory layer.

12. The method of claim 7 , wherein the intermediate non-volatile cache memory layer is independent of the at least one main memory cache storage device.

13. 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.

14. The medium of claim 13 , further comprising instructions to generate a first stored procedure for configuring the intermediate non-volatile cache memory layer.

15. The medium of claim 13 , wherein the configuring of the intermediate non-volatile cache memory layer is performed by invoking a first stored procedure, the first stored procedure including the configuration details.

16. The medium of claim 13 , wherein the in-memory non-volatile metadata cache comprises data structure buffers to store metadata associated with a database page.

17. The medium of claim 13 , wherein the metadata associated with a database page stored in the in-memory non-volatile metadata cache points to a location where the database page is stored on the non-volatile disk portion of the intermediate non-volatile cache memory layer.