Method to increase subscription scalability

A computer readable storage medium having computer readable instructions to instruct a computer to perform a method for providing notifications of changes in a database system comprising:

• receiving a plurality of SQL query plans for querying a relational database system, each SQL query plan corresponding to a computing application that has subscribed to receive notification of changes in the database system effecting output from the database system to the computing application;
• creating a subscription template from the plurality of SQL subscription plans, the template not comprising any constants;
• generating a parameter table from the plurality of SQL query plans, the parameter table comprising for each SQL query plan a constant representing a query value, a subscription plan identification value uniquely identifying a subscription associated with the particular query plan, 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 plans in the plurality of SQL query plans affected by the change in the data in the database;
• and
• communicating notification to a computing application corresponding to an identified SQL query plan, said notification indicating the change in the data in the database has occurred.

A system to increase subscription scalability in an electronic database environment comprising:

• a computing processor;
• computing memory communicatively coupled to said computing processor, said computing memory having stored thereon instructions executable by said computing processor for providing the following:
• a relational database system, the database system capable of accepting and processing subscriptions by cooperating services and/or computing applications, the subscriptions offering query templates for execution on database system to retrieve desired data;
• a notification manger, the notification manager operating on the database system to identify changes in data in the database system and to provide notifications to the cooperating services and/or computing applications of database system changes;
• an optimization module, the optimization module using SQL queries originating from subscribers to create subscription templates, the templates not comprising any constants and being paramterized to create a parameter table, said parameter table comprising for each query a constant representing a query value, a subscription identification value uniquely identifying a subscription associated with a particular SQL query, and subscriber routing information,
• wherein said notification manager is adapted to:
• join the parameter table with at least one of the subscription templates to generate a notification query,
• execute the notification query on the database system to identify SQL queries affected by changes in the database system, and
• communicate notification to a computing application corresponding to an identified SQL query, said notification indicating a change in the data in the database has occurred.

A method for increasing subscription scalability in electronic data environments comprising:

• accepting subscriptions from cooperating services and/or computing applications by a relational database system, the subscriptions comprising SQL queries for querying the database system;
• processing the SQL queries to generate query templates, the query templates having queries and not comprising any constants;
• parameterizing the query templates to generate a parameter table, said parameter table comprising for each query a constant representing a query value, a subscription identification value uniquely identifying a subscription associated with the particular query, and subscriber routing information;
• in response to a change in the data in the database, joining the parameter table with the query templates to generate a notification query;
• executing the notification query on the database system to identify SQL queries affected by the change in the data in the database;
• and
• communicating notification to a computing application corresponding to an identified SQL query, said notification indicating the change in the data in the database has occurred.

A computer readable storage medium having computer readable instructions to instruct a computer to perform a method for increasing subscription scalability in electronic data environments comprising:

• accepting subscriptions from cooperating services and/or computing applications by a relational database system, the subscriptions comprising SQL queries for querying the database system;
• processing the SQL queries to generate query templates, the query templates not comprising any constants and being formed as a database table;
• parameterizing the query templates to generate a parameter table, said parameter table comprising for each query a constant representing a query value, a subscription identification value uniquely identifying a subscription associated with the particular query, and subscriber routing information;
• in response to a change in the data in the database, joining the parameter table with the query templates to generate a notification query;
• executing the notification query on the database system to identify SQL queries affected by the change in the data in the database;
• and
• communicating notification to a computing application corresponding to an identified SQL query, said notification indicating the change in the data in the database has occurred.