Row triggers

Details Row triggers Row triggers

2003-12-15

2009-12-29

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C709S220000

Reexamination Certificate

active

07640229

ABSTRACT:
A method for processing a trigger are described. The trigger is associated with a subject table in a relational database and defines a triggering statement and one or more triggered actions. The method includes determining that a triggering statement of a trigger will execute on a subject table row of a subject table and requesting a transition table in response to determining that the triggering statement will execute. The transition table includes a transition table row. The transition table row includes a first value associated with the subject table row and a second value associated with the subject table row. The method further includes reading the transition table row from the transition table and identifying a processing unit to receive the transition table row and a triggered action of the trigger. The method also includes transmitting the transition table row and the triggered action to the identified processing unit to be processed.

REFERENCES:
patent: 5930795 (1999-07-01), Chen et al.
patent: 6122633 (2000-09-01), Leymann et al.
patent: 6374236 (2002-04-01), Chen et al.
patent: 6829616 (2004-12-01), Chen et al.
patent: 7516208 (2009-04-01), Kerrison et al.
patent: 2002/0138497 (2002-09-01), Chen et al.
patent: 2004/0236763 (2004-11-01), Krishnamoorthy et al.
patent: 2005/0216520 (2005-09-01), He et al.
patent: 1111516 (2001-06-01), None
Transition tables, IBM UDB documentation, pp. 1-2.
David DeWitt et al., Parallel Database Systems: The Future of High Performance Database Processing, Jun. 1992, pp. 1-26.

Affiliated with

Also associated with

Rating

Row 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 Row triggers, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Row triggers will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4126951