×

System and method for database change notification

  • US 20040267741A1
  • Filed: 06/24/2003
  • Published: 12/30/2004
  • Est. Priority Date: 06/24/2003
  • Status: Active Grant
First Claim
Patent Images

1. A method for notifying a client of a change to data stored at a database, the method comprising:

  • receiving a subscription from the client, the subscription selecting a first subset of data from within a set of data;

    generating a subscription plan for filtering the first subset from within the set of data;

    receiving a query to be executed at the database, the query changing a second subset of data within the set of data;

    generating a query plan for executing the query, the query plan for filtering the second subset from within the set of data;

    matching the subscription to the query based on the set of data;

    supplementing the query plan with the subscription plan;

    executing the supplemented query plan whereby the query changes the second subset of data and the subscription filters the first subset of data from within the second subset of data to form a third subset of data;

    determining whether the third subset of data is non-empty; and

    if the third subset of data is non-empty, then generating a notification of the change to the third subset of data.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×