Patent ID: 8538930

Claim:
A method of database system recovery, the method comprising: building a business process catalog, wherein the building of the business process catalog includes creating and storing at least one set of business process batches in the business process catalog using a pattern analysis of historical data of a database system and building the business process catalog further comprises: logging a first set of statements for a plurality of transactions of a first business process batch; comparing the first set of statements with a second set of statements stored in the business process catalog responsive to the pattern analysis of historical data of the database system, the second set of statements having been executed, wherein the at least one set of business process batches that is created and stored in the business process catalog includes a second business process batch having the second set of statements; finding, in an instance of the comparing, a match between the first set of statements and the second set of statements stored in the business process catalog, wherein for the instance of finding the match, the building of the business process catalog further comprises: updating the business process catalog with corresponding metadata of the second business process batch to indicate another executed instance of the stored second set of statements; and storing corresponding updated recovery information of the second business process batch in the business process catalog; and wherein the method of database system recovery further comprises: performing database system recovery using the updated business process catalog.