Abstract: 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.

Abstract: The present invention relates to systems and methods for saving results generated from database queries such as raw data, objects, queryable data sets, full or partial web responses, in memory for current and subsequent utilization and invaliding the saved results when they become inconsistent to mitigate employing inconsistent results. The saved results can be employed by one or more components and are typically utilized when a subsequent query would return substantially similar results. Thus, the system and methods mitigate performing substantially redundant queries that can reduce performance and consume resources. When a database change occurs that affect the consistency of the saved results and/or expiration period lapses, an invalidation message can be transmitted, wherein the message is employed to invalidate the saved results. Thus, the systems and methods mitigate employing inconsistent saved results.

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.