Patent ID: 7444344

Claim:
A method for providing notifications of changes in a database system, comprising: receiving a plurality of SQL query statements for querying a relational database system, each SQL query statement corresponding to a computing application that has subscribed to receive notification of changes in the database system affecting data retrieved from the database system by the computing application; creating a subscription template from the plurality of SQL query statements, the template not comprising any constants; generating a parameter table from the plurality of SQL query statements, the parameter table comprising for each SQL query statement a constant representing a query value, a subscription identification value uniquely identifying a subscription associated with the particular SQL query statement, and subscriber routing information; in response to a change in the data in the database, performing a join between said parameter table and said subscription template to generate a query; executing the query on the database system to identify SQL query statements in the plurality of SQL query statements affected by the change in the data in the database; and communicating notification to a computing application corresponding to an identified SQL query statement, said notification indicating a change in the data in the database has occurred.