Systems and methods for requesting and receiving database change notifications

The present invention relates to systems and methods for providing a notification when subsequent query results from a registered database query change due to a database change. The systems and methods employ a service broker to facilitate storing database query registration information associated w...

Full description

Saved in:
Bibliographic Details
Main Authors KLEINERMAN CHRISTIAN, PIZZO MICHAEL J, SUNDARESAN SHARAD, PAMULAPATI RAMAKRISHNA P, CASTRO PABLO
Format Patent
LanguageEnglish
Published 14.10.2004
Edition7
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The present invention relates to systems and methods for providing a notification when subsequent query results from a registered database query change due to a database change. The systems and methods employ a service broker to facilitate storing database query registration information associated with a registered database query in a queue(s) and activating a notification delivery service(s). During an activation period, the notification delivery service(s) can access the queue(s) to obtain the database query registration information. Then the notification delivery service(s) can construct and transmit a change message(s). The change message(s) can be employed to facilitate notifying a component(s) registered to receive notification when the query results change and/or invalidate saved query results. The present invention can be employed with various database registration, database change detection, and database change message reception mechanisms. Furthermore, the present invention can be employed in a client-server environment such as an SQL based environment.
Bibliography:Application Number: US20030402025