公开(公告)号：US20070226171A1

公开(公告)日：2007-09-27

申请号：US11387221

申请日：2006-03-23

Applicant: John Medicke ,  Feng-wei Russell ,  Michael Smith ,  Ray Tan

Inventor： John Medicke ,  Feng-wei Russell ,  Michael Smith ,  Ray Tan

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99953

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.

Abstract translation: 在数据处理系统中识别数据库触发器的系统。 收到请求以创建特定应用程序事件的数据库监视器，并响应于接收到创建数据库监视器的请求，创建数据库监视器。 然后，接收到一个请求以监视数据库内的特定应用程序事件，并响应于接收到监视特定应用程序事件的请求，创建数据库的复制数据库。 随后，在特定应用程序事件发生后，将数据库与复制数据库进行比较，以识别与特定应用程序事件相关联的数据库中的更改。 基于与特定应用程序事件相关联的数据库中所标识的更改，为数据库触发器确定最佳候选项。