Business Process Based Database Recovery and Experimental Results

In this research paper we have explained and presented the results of a novel database recovery method. Taking into account that most data servers today are becoming increasingly autonomic and business process oriented, there is a need to develop a new model where it is possible to do a database recovery based on the occurrence of a business process rather than non intuitive data like time, log file name/location or system change number. The advantage of this recovery model is that the user will no longer be required to remember non intuitive data like timestamp up to which the data has to be restored, log file name/location or system change number. Moreover the database server has built in intelligence to identify transaction behaviour, study the pattern among these batches and then storing recovery information specific to these business process to be used later for recovery. Another advantage is that the down time needed for restoring the database is reduced drastically since the trial and error approach followed by conventional data servers in the absence of accurate recovery information is eliminated. We have also simulated the Idea using JAVA API’s and Apache Derby and presented the experimental results for reference..