The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 16, 2010
Filed:
Mar. 28, 2003
Robert M. Howard, Snoqualmie, WA (US);
Michael J. Pizzo, Bellevue, WA (US);
Adam W. Smith, Redmond, WA (US);
Pablo Castro, Bellevue, WA (US);
Robert M. Howard, Snoqualmie, WA (US);
Michael J. Pizzo, Bellevue, WA (US);
Adam W. Smith, Redmond, WA (US);
Pablo Castro, Bellevue, WA (US);
Microsoft Corporation, Redmond, WA (US);
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.