Systems and methods for automatic database or file system maintenance and repair

Abstract

The present invention relates generally to database and file system management and, more particularly, to automatic database and file system maintenance and repair to ensure data reliability. Various aspects of the present invention relate to responding and correcting data corruptions at a data page level for all data page types, as well as to recovery (including rebuild or restore operations) for various scenarios including, without limitation, index page corruptions (clustered and non-clustered), data page corruptions, and page corruptions in the log file.

1 . A system for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said system comprising: 
 a subsystem for aborting said transaction and attempting a page level restoration; and    a subsystem for determining whether the page level restoration fails or is unavailable, further comprising: 
 a subsystem for attempting an index recovery when the failure is for an index page;  
 a subsystem for attempting a data page recovery when the failure is for a data page;  
 a subsystem for attempting an emergency repair when the failure is due to a log page error; and  
 a subsystem for attempting to restore the entire database when the failure is an unrecoverable error.  
   
     
     
         2 . A method for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said method comprising: 
 aborting said transaction and attempting a page level restoration; and    if the page level restoration fails or is unavailable, then: 
 if the failure is for an index page, attempting an index recovery;  
 if the failure is for a data page, attempting a data page recovery;  
 if the failure is due to a log page error, attempting an emergency repair; and  
 if the failure is an unrecoverable error, attempting to restore the entire database.  
   
     
     
         3 . A computer-readable medium comprising computer-readable instructions for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said computer-readable instructions comprising instructions for: 
 aborting said transaction and attempting a page level restoration; and    if the page level restoration fails or is unavailable, then: 
 if the failure is for an index page, attempting an index recovery;  
 if the failure is for a data page, attempting a data page recovery;  
 if the failure is due to a log page error, attempting an emergency repair; and  
 if the failure is an unrecoverable error, attempting to restore the entire database.