Randy Charles Rolfe from Prior Lake, MN, age 55

Resumes

Randy Rolfe

View page

Randy Rolfe

View page

Publications

Us Patents

Dependent Object Processing For Triggers

View page

US Patent:

6820080, Nov 16, 2004

Filed:

Mar 26, 2001

Appl. No.:

09/817602

Inventors:

Mark John Anderson - Oronoco MN
Kevin Robert Brettin - Rochester MN
Russell Edward Bruhnke - Rochester MN
Kyle Eric Gilbertson - Rochester MN
Ritchie Lee Nyland - Rochester MN
Richard Donald Parrott - Rochester MN
Kathy Lynn Passe - Oronoco MN
Randy Keith Rolfe - Rochester MN
Susan Liisa Romano - Rochester MN
Renee Kristin Saxman - Rochester MN
Kathryn Rose Steinbrink - Chatfield MN
Mark William Theuer - Rochester MN
Jonathan Lee Triebenbach - Rochester MN
Michael Alan Venz - Rochester MN
Jane Ann Vold - Byron MN

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4, 707 2, 707 3, 707101, 707102, 707103, 707104

Abstract:

Methods, systems and articles of manufacture are provided for setting a state of triggers between operative and inoperative. In an operative state the trigger may be called during triggering I/O operations such as Insert, Update and Delete. The inoperative state indicates that the system has detected a condition requiring user intervention. In a particular embodiment, a database management system (DBMS) will analyze the function being performed on a table (such as a rename of the table) and with dependent object data, the DBMS will determine if the trigger is self-referencing. If so, the trigger made inoperative. Making the trigger inoperative and requiring user intervention prevents the system from potentially producing undesired results. In another embodiment, a determination of dependency is made upon receiving a database command to affect an object. According to the type of command, the object and its dependents are either affected or unaffected.