Patent ID: 8719243

Claim:
A system comprising: a database including hardware and software components to implement a database; a cache memory device local to the database, and remote from a client device; a server implemented on hardware components local to the database to store a query result set on the cache memory device as a cached result set obtained in response to a user query, the server to access the cached result set, the result set including multiple rows of data each having columns representing fields of the data; present a portion of the result set including selected rows of the multiple rows in a list view to the client device remote from the server and the cache memory, the portion based on filter selection that generates a filtered result set of rows of data based on fields of the data; receive a change to the filter selection from the client device; and dynamically alter the list view based on the changed filter selection, wherein in response to the changed filter selection requesting a row of data not cached in the memory, generating a new query on the database for a new result set including the requested row of data, cache the new result set, and generate an updated filtered result set of rows of data based on fields of the data from the new result set, and otherwise, generate an updated filtered result set of rows of data based on fields of the data from the cached result set without generate a new query on the database.