Method and System for Database Recovery

A method of relational database system recovery, the method comprising:

• building a business process catalog, wherein the business process catalog includes a set of business process batches created using a pattern analysis of historical data of a relational database system;
• performing relational database system recovery using the business process catalog;
• logging a first set of statements corresponding to a plurality of transactions of a first business process batch;
• assigning a system assigned name generated by the relational database system to the first business process batch, wherein the assigning is done when all the transactions of the first business process batch are complete;
• comparing the first set of statements with a second set of statements, wherein the second set of statements is included in a second business process batch and the second business process batch being stored in the business process catalog;
• storing the first business process batch in the business process catalog and storing corresponding recovery information of the first business process batch, if a match is not found between the first set of statements and the second set of statements;
• updating the business process catalog with corresponding metadata of the second business process batch, and storing corresponding updated recovery information of the second business process batch in the business process catalog, if a match is found between the first set of statements and the second set of statements;
• prompting a relational database system user to assign a user assigned name to the second business process batch and updating the business process catalog with the user assigned name, wherein prompting is performed if a match is found between the first set of statements and the second set of statements and if a frequency of occurrence of the second business process batch is greater than a pre-defined threshold during a pre-defined time interval;
• identifying a set of business process batches in response to a request for recovery of the relational database system using the business process catalog;
• presenting the set of identified business process batches to a relational database system user;
• enabling the relational database system user to select a business process batch from the presented set of identified business process batches;
• fetching recovery information corresponding to the selected business process batch;
• and
• executing the relational database system recovery using the selected business process batch and the corresponding recovery information.