Patent ID: 8560496
Filing Date: 2013-10-15
Classification: G06F

Abstract:
1. A method for server-side processing in a database query management environment, wherein the database query management environment comprises a database comprising the capability to store at least one item and the capability to store at least one index, and a server comprising the capability to process database queries to the database, the method comprising: receiving, from a client, a database query comprising a received database query; accessing an index stored in the database, wherein the index that is accessed comprises an accessed index, and outputting the accessed index in response to the received database query, wherein the outputted index identifies at least one item stored in the database in its appropriate position for a predefined search order of at least one item stored in the database; storing the accessed index in a server local cache and sending the accessed index to the client to be stored in a client local cache by a client controller; receiving an item request for an item comprising a received item request, the item request having been generated at the client according to the accessed index stored at the client local cache; accessing an item stored in the database in response to a received item request wherein the item that is accessed comprises an accessed item; outputting the accessed item in response to the received item request; storing items that are output by the server, including the accessed item, in the server local cache; flushing the server local cache of at least one item output by the server, the flushing in response to receiving a database query close message, wherein the item that is flushed from the server local cache comprises an item identified in the accessed index and identified as closed in the received database query close message; and generating and outputting a change notification that identifies a change to the accessed index comprising the deletion of the index entry from the accessed index.