Patent ID: 7512631
Filing Date: 2009-03-31
Classification: G06F,Y10S

Abstract:
1. A computer implemented method to identify database triggers in a data processing system, the computer implemented method comprising: responsive to receiving a request to create a database monitor for a specific application event, creating the database monitor; responsive to receiving a request to monitor the specific application event within a database, creating a replicate database of the database; monitoring the specific application event; comparing the database to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event; recording the identified changes in the database associated with the specific application event; identifying a best candidate for a database trigger based upon the identified changes in the database associated with the specific application event; listing recommended database triggers for the specific application event in a table in decreasing priority order; creating a user defined function stub for the recommended database triggers; and sending the listed recommended database triggers and created user defined function stubs, along with a statistical analysis of the recorded identified changes in the database associated with the specific application event.