Generating continuous query notifications

Details Generating continuous query notifications Generating continuous query notifications

2008-08-08

2011-10-11

Nguyen, Cam-Linh (Department: 2161)

Data processing: database and file management or data structures

Data integrity

Triggers, stored procedures, user defined function

C707S713000, C707S736000

Reexamination Certificate

active

08037040

ABSTRACT:
Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.

REFERENCES:
patent: 5768532 (1998-06-01), Megerian
patent: 6366915 (2002-04-01), Rubert et al.
patent: 2002/0042789 (2002-04-01), Michalewicz et al.
patent: 2002/0128897 (2002-09-01), Nelson et al.
patent: 2002/0169747 (2002-11-01), Chapman et al.
patent: 2003/0144980 (2003-07-01), Holmgren
patent: 2004/0205048 (2004-10-01), Pizzo et al.
patent: 2005/0039049 (2005-02-01), Chang et al.
patent: 2005/0055384 (2005-03-01), Ganesh et al.
patent: 2005/0091287 (2005-04-01), Sedlar
patent: 2006/0206532 (2006-09-01), MacLaurin
patent: 2008/0215528 (2008-09-01), Sedlar
patent: 2010/0036803 (2010-02-01), Vemuri et al.
N. Gehani et al., “OdeFs: A File System Interface to an Object-Oriented Database”, At&T Bell Laboratories, New Jersey, 1989.

Affiliated with

Also associated with

Rating

Generating continuous query notifications does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Generating continuous query notifications, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generating continuous query notifications will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4278555