Method and System for Database Recovery

摘要

A method, a system and a computer program of database system recovery are disclosed. The method includes building a business process catalog using a pattern analysis of historical data of the database system and also includes deploying the built business process catalog to perform the database system recovery. The method further includes logging a first set of statements corresponding to a plurality of transactions of a first business process batch and comparing the first set of statements with a second set of statements wherein the second set of statements is included in a second business batch process being stored in the business process catalog. The business process catalog is updated based on the comparison of the first set of statements and the second set of statements. The method further includes deploying the built business process catalog to identify and present business process batches to the database system user to select a business process batch. The selected business process batch is used to perform the database system recovery. Also disclosed are a system and a computer program for database system recovery.