Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2006-03-01
2010-12-21
Laneau, Ronald (Department: 3714)
Data processing: database and file management or data structures
Database design
Database and data structure management
C707S804000, C707S821000
Reexamination Certificate
active
07856455
ABSTRACT:
System, method and program product for generating a trigger program that updates an entry in a dependent column in a table in response to a request to update a corresponding entry in a parent column in the table. A trigger program template is provided. The trigger program template includes program steps which indicate a type of update to an entry in an unspecified parent column which triggers an update to a corresponding entry in an unspecified dependent column. The trigger program template also indicates a type of the unspecified dependent column to update upon the update to the entry in the unspecified parent column. The table is automatically scanned to identify one or more dependent columns of the type. In response to identification of the one or more dependent columns of the type, a name of a parent column, corresponding to the one or more dependent columns, is inserted in the trigger program template steps to identify the corresponding parent column as the unspecified parent column and identify the one or more dependent columns as the unspecified dependent columns. Names of the one or more dependent columns comprise the name of the specified parent column and respective suffixes indicating the types of the dependent columns.
REFERENCES:
patent: 6820080 (2004-11-01), Anderson et al.
patent: 2003/0004952 (2003-01-01), Nixon et al.
patent: 2004/0148474 (2004-07-01), Cuomo et al.
patent: 2004/0236744 (2004-11-01), Desai et al.
patent: 2004/0267824 (2004-12-01), Pizzo et al.
patent: 2005/0154695 (2005-07-01), Gonzalez et al.
Sybase Inc. ©, “Chapter 6 Using Referential Integrity Triggers”, Sybase® PowerDesigner® Physical Data Model Getting Started Version 9.0; Nov. 2001; pp. 61-74.
Bhogal, Kulvir, Enforcing Business Logic Using DB2 Triggers, Java UDFs, and the JavaMail API, May 9, 2002 (pp. 1-5).
Martinez Andrea C.
Matula Charles
Starke David H.
Wiley Gregory R. E.
Harper Tramar
International Business Machines - Corporation
Laneau Ronald
Samodovitz Arthur J.
LandOfFree
System, method and program product for generating triggers... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System, method and program product for generating triggers..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System, method and program product for generating triggers... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4152692