×

Net change notification based cached views with linked attributes

  • US 8,601,007 B2
  • Filed: 05/17/2011
  • Issued: 12/03/2013
  • Est. Priority Date: 05/17/2011
  • Status: Active Grant
First Claim
Patent Images

1. A method executed at least in part in a computing device for caching view data with linked attributes based on net change notification, the method comprising:

  • submitting a query to a server for the view data, the query including;

    combining conditions on related table columns of server-side view data with an “

    and”

    operation;

    applying the combined conditions on timestamp attributes of the related table columns;

    retrieving query results in batches and returning a minimum active row version associated with a first batch from the batches;

    merging the query results by applying a “

    sort by ID”

    filter on “

    ID”

    attributes that are unique and immutable for objects corresponding to an entity type;

    updating a client-side view data cache based on the merged results;

    in response to at least one of the objects in the server-side view data satisfying a “

    viewDefinition”

    filter for a predetermined period depending on a frequency of updating the client-side view data cache, providing a guarantee that the at least one of the objects coincide with at least one corresponding row in the client-side view data cache; and

    picking up a possible missed row between the batches on a subsequent update of the client-side view data cache.

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