Data processing: database and file management or data structures – Data integrity – Triggers – stored procedures – user defined function
Reexamination Certificate
2003-03-28
2010-11-16
Morrison, Jay A (Department: 2168)
Data processing: database and file management or data structures
Data integrity
Triggers, stored procedures, user defined function
C707S758000, C707S769000, C707S770000
Reexamination Certificate
active
07836031
ABSTRACT:
The present invention relates to systems and methods for employing a trigger based mechanism to detect changes in a database table, providing a notification when the database table changes and registering to receive the notification. The systems and methods employ a listeners table to store information associated with registered database tables. Alter a database table changes, a trigger mechanism associated with the database change facilitates a search of the listeners table for a parameter associated with the changed database table. If the changed database table is registered, the information from the listeners table is provided to a delivery service which transmits a message indicating the registered database table changed. After receiving the message, a notification runtime service can route a notification to a client(s) registered to receive the notification. The foregoing mitigates performing time intensive queries and utilizing inconsistent query results.
REFERENCES:
patent: 5133075 (1992-07-01), Risch
patent: 5418943 (1995-05-01), Borgida et al.
patent: 5592664 (1997-01-01), Starkey
patent: 5721825 (1998-02-01), Lawson et al.
patent: 5826253 (1998-10-01), Bredenberg
patent: 5940820 (1999-08-01), Kagiwada
patent: 6026413 (2000-02-01), Challenger et al.
patent: 6256712 (2001-07-01), Challenger et al.
patent: 6434554 (2002-08-01), Asami et al.
patent: 6442541 (2002-08-01), Clark et al.
patent: 6567809 (2003-05-01), Santosuosso
patent: 6584548 (2003-06-01), Bourne et al.
patent: 6732360 (2004-05-01), Seo et al.
patent: 6799208 (2004-09-01), Sankaranarayan et al.
patent: 6910070 (2005-06-01), Mishra et al.
patent: 2002/0128897 (2002-09-01), Nelson et al.
Paul H. Kim, Notification in the THOR Database System, May 24, 2002, 45 pages.
J. Myers SMTP Service Extention for Authentication, Mar. 1999 RFC 2554.
T. Berners-Lee et al. Hypertext Transfer Protocol Http/1.0 May 1996 p. 46-57.
Wen-Syan Li, K. Selcuk Candan, Wang-Pin Hsiung, and Divyakant Agrawal. Web Accleration for E-Commerce Web Applications. Poster Proceedings of the 10th World Wide Web Conference pp. 166-167, 2001.
Krithi Ramamritham, Raju Sivasankaran, John A. Stankovic, Don T. Towsley, and Ming Xiong. Integrating Temporal, Real-Time, and Active Databases. SIGMOD Record vol. 25 No. 1, pp. 8-12, 1996.
Eric N. Hanson, Chris Carnes, Lan Huang, Mohan Konyala, Lloyd Noronha, Sashi Parthasarathy, J.B. Park, Albert Vernon. Scalable Trigger Processing. Proceedings of the 15th International Conference on Data Engineering, pp. 266-275, 1999.
Kapali P. Eswaran. Aspects of a Trigger Subsystem in an Integrated Database System. Proceedings of the 2nd International Conference on Software Engineering, pp. 243-250, 1976.
Castro Pablo
Howard Robert M.
Pizzo Michael J.
Smith Adam W.
Microsoft Corporation
Morrison Jay A
Workman Nydegger
LandOfFree
Systems and methods for employing a trigger-based mechanism... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Systems and methods for employing a trigger-based mechanism..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for employing a trigger-based mechanism... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4191839