System and method for intelligent write management of disk pages in cache checkpoint operations

A computer implemented application with improved write operation efficiency for handling checkpoint operations with respect to a data cache, comprising:

• a disk system configured to have a plurality of disk pages, a portion of these disk pages being used to store a file that includes data that is accessed by a plurality of users;
• a first subsystem configured to manage user access to the file data using a cache, the cache being configured to store at least a portion of the file data and provide an interface between the users and the file data stored in the file on the disk system;
• and
• a second subsystem coupled to the disk system and communicating with the cache subsystem, the second subsystem being configured to handle write operations to the disk system during checkpoint operations;
• wherein the disk pages are assigned and write data stored in the cache as write requests for the file data are received from users, each write request including write data to be written to the file on the disk system in a write operation;
• and
• wherein assigned disk pages are re-mapped upon the occurrence of a checkpoint operation to make more efficient the write operations associated with the write data stored in cache.

A database system with intelligent management of disk pages for cache checkpoint operations, comprising:

• a disk system configured to have a plurality of disk pages;
• a database stored as a file on the disk system, the database file utilizing a portion of the disk pages and including data that is accessed by a plurality of database users;
• a database application server coupled to the disk system and managing the database file, the database application server being configured to communicate with a plurality of client user systems, the database application server, comprising:
• a cache subsystem configured to manage user access to the file data using a cache, the cache being configured to store at least a portion of the file data and provide an interface between the users and the file data stored in the file on the disk system;
• and
• an input/output (I/O) subsystem configured to handle write operations to the disk system during checkpoint operations;
• wherein the disk pages are assigned and write data stored in the cache subsystem as write requests for the file data are received from users, each write request including write data to be written to the file on the disk system in a write operation;
• and
• wherein assigned disk pages are re-mapped upon the occurrence of a checkpoint operation to make more efficient the write operations associated with the write data stored in cache.