Patent ID: 8601007

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