Hierarchical triggers for database

Details Hierarchical triggers for database Hierarchical triggers for database

2007-10-08

2010-10-19

Stace, Brent (Department: 2161)

Data processing: database and file management or data structures

Data integrity

Triggers, stored procedures, user defined function

C707S687000

Reexamination Certificate

active

07818305

ABSTRACT:
The present invention introduces the concept of a super-trigger to allow for multi-level hierarchical triggers in a database application. The super-trigger may be created by identifying one or more triggers as sub-triggers, and defining a condition in the super-trigger, the result of the condition depending from a result of one or more of the sub-triggers. Upon execution, information may be retrieved regarding a result for each of the sub-triggers. The condition may then be evaluated using these results, and an action may be performed if the condition is met.

REFERENCES:
patent: 6006224 (1999-12-01), McComb et al.
patent: 6144967 (2000-11-01), Nock
patent: 6405212 (2002-06-01), Samu et al.
patent: 6594656 (2003-07-01), Arlein et al.
patent: 6804819 (2004-10-01), Bates et al.
Feuerstein, Steven, “Oracle PL/SQL Developer's Workbook” May 2000, O'Reilly <http://oreilly.com/catalog/ordevworkbook/chapter/ch16s.html>, p. 1-9.

Affiliated with

Also associated with

Rating

Hierarchical triggers for database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Hierarchical triggers for database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Hierarchical triggers for database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4202304