Inventors:
John Medicke - Raleigh NC, US
Feng-wei Russell - Cary NC, US
Michael Smith - Raleigh NC, US
Ray Tan - Austin TX, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 17/30
Abstract:
A system to identify database triggers in a data processing system. A request is received to create a database monitor for a specific application event and in response to receiving the request to create the database monitor, the database monitor is created. Then, a request is received to monitor the specific application event within a database and in response to receiving the request to monitor the specific application event, a replicate database of the database is created. Subsequently, the database is compared to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event. A best candidate is identified for a database trigger based upon the identified changes in the database associated with the specific application event.