Method and System for Identifying Database Triggers
0 Assignments
0 Petitions
Accused Products
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.
31 Citations
20 Claims
-
1-11. -11. (canceled)
-
12. A data processing system comprising:
-
a bus system; a storage device connected to the bus system, wherein the storage device includes a set of instructions; and a processing unit connected to the bus system, wherein the processing unit executes the set of instructions to create a database monitor in response to receiving a request to create the database monitor for a specific application event;
create a replicate database of a database in response to receiving a request to monitor the specific application event within the database;
to monitor the specific application event;
to compare the database to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event;
to record the identified changes in the database associated with the specific application event;
to identify a best candidate for a database trigger based upon the identified changes in the database associated with the specific application events;
to list recommended database triggers for the specific application event in a table in decreasing priority order;
to create a user defined function stub for the recommended database triggers; and
to send 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.
-
-
13. (canceled)
-
14. A computer usable medium having computer usable program code embodied therein to identify database triggers in a data processing system, the computer usable program code comprising:
-
computer usable program code configured to create a database monitor in response to receiving a request to create the database monitor for a specific application event; computer usable program code configured to create a replicate database of a database in response to receiving a request to monitor the specific application event within the database; computer usable program code configured to monitor the specific application event; computer usable program code configured to compare the database to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event; computer usable program code configured to record the identified changes in the database associated with the specific application event; computer usable program code configured to identify a best candidate for a database trigger based upon the identified changes in the database associated with the specific application event; computer usable program code configured to list recommended database triggers for the specific application event in a table in decreasing priority order; computer usable program code configured to create a user defined function stub for the recommended database triggers; and computer usable program code configured to send 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. - View Dependent Claims (16, 17, 18, 19, 20)
-
-
15. (canceled)
Specification