Methods and systems for filtering data for interactive display of database data
First Claim
1. 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 toaccess 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.
2 Assignments
0 Petitions
Accused Products
Abstract
Interactive database viewing is provided. A server associated with a database accesses a stored result set from a database query. The server presents a portion of the result set in a list view to a client device remote from the server and the cache memory, where the portion presented is based on filter selection based on fields of the data. In response to changes to the filter selection, the server can dynamically alter the list view without having to again access the database. If a change to the filter selection requests data outside the cached result set, the server accesses the database and updates the cached result set. Inline editing of the data in the list view can be applied back to the database by the server.
132 Citations
20 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method comprising:
-
accessing with a server a cached result set of a query on a database, the result set including multiple rows of data each having columns representing fields of the data, the result set being cached in a memory local to the server; presenting a portion of the result set including selected rows of the multiple rows in a list view to a client device remote from the server and the memory, the portion based on filter selection that generates a filtered result set of rows of data based on fields of the data; receiving at the server a change to the filter selection from the client device; and dynamically altering 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, caching the new result set, and generating an updated filtered result set of rows of data based on fields of the data from the new result set, and otherwise, generating an updated filtered result set of rows of data based on fields of the data from the cached result set without generating a new query on the database. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. An article of manufacture comprising a non-transitory computer readable storage medium having content stored thereon, which when executed, cause a machine to perform operations including:
-
accessing with a server a cached result set of a query on a database, the result set including multiple rows of data each having columns representing fields of the data, the result set being cached in a memory local to the server; presenting a portion of the result set including selected rows of the multiple rows in a list view to a client device remote from the server and the memory, the portion based on filter selection that generates a filtered result set of rows of data based on fields of the data; receiving at the server a change to the filter selection from the client device; and dynamically altering 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, caching the new result set, and generating an updated filtered result set of rows of data based on fields of the data from the new result set, and otherwise, generating an updated filtered result set of rows of data based on fields of the data from the cached result set without generating a new query on the database. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification