Fast load of dashboards using data caching
AssigneeServiceNow, Inc.
InventorsDastagirireddy Ramireddy Gari, Oriol Arbonés, Wellington Avelino Dos Santos, Marko Maric, Willian Wilmar Cieslak, Subramani Thandayuthapani Prabhakaran, Olga Sergiyivna Redkina
Life of this patent
Estimating the term…
Abstract
Systems and methods disclosed herein for improving data retrieval for dashboards using data caching. The system may implement a cache memory to store results for executed queries and/or anticipated queries, allowing for data to be retrieved asynchronously, and may implement a request queue to distribute the queries among processing nodes.
Claims20
A method comprising:
- obtaining, from a cache memory storing data of a database, a data table comprising a plurality of entries, wherein each entry of the plurality of entries comprises a respective key and respective results to a query;
- determining that a particular entry of the plurality of entries satisfies an expiration condition;
- executing the respective query of the particular entry to obtain refreshed results to the respective query;
- and
- storing the refreshed results with the respective key in the particular entry of the data table.
A system, comprising:
- processing circuitry;
- and
- memory, accessible by the processing circuitry, and storing instructions that, when executed by the processing circuitry, cause the processing circuitry to perform operations comprising:
- obtaining, from a cache memory storing data of a database, a data table comprising a plurality of entries, wherein each entry of the plurality of entries comprises a respective key and respective results to a query;
- determining that a particular entry of the plurality of entries satisfies an expiration condition;
- executing the respective query of the particular entry to obtain refreshed results to the respective query;
- and
- storing the refreshed results with the respective key in the particular entry of the data table.
A tangible, non-transitory, computer-readable medium instructions that, when executed by processing circuitry, cause the processing circuitry to perform operations comprising:
- obtaining, from a cache memory storing data of a database, a data table comprising a plurality of entries, wherein each entry of the plurality of entries comprises a respective key and respective results to a query;
- determining that a particular entry of the plurality of entries satisfies an expiration condition;
- executing the respective query of the particular entry to obtain refreshed results to the respective query;
- and
- storing the refreshed results with the respective key in the particular entry of the data table.
Dependencies are inferred from the claim text.