METHOD AND SYSTEM FOR PROVIDING FASTER CRASH RECOVERY IN DATA BASE MANAGEMENT SYSTEMS TECHNICAL FIELD

摘要

The present disclosure provides a computer-implemented method for performing recovery in a database associated with a database management system during a system failure by utilizing a modified write ahead logging technique is provided. The computer- implemented method includes pushing one or more log records for a corresponding one or more queries from a log record buffer to a log buffer memory associated with a buffer cache, triggering a random flushing of the one or more log records for the corresponding one or more queries from the log buffer memory to the database and enabling recovery of the one or more log records in the database after the system failure. The pushing of the one or more log records is done by splitting the one or more log records into one or more log files. The splitting is done based on a pre-determined criterion.