Cached database and synchronization system for providing dynamic linked panels in user interface

Patent metadata

Field	Value
Publication number	US-12204845-B2
Application number	US-202318299507-A
Country	US
Kind code	B2
Filing date	Apr 12, 2023
Priority date	Jul 21, 2016
Publication date	Jan 21, 2025
Grant date	Jan 21, 2025

Abstract

A system is configured to provide a dashboard creation system. Panels associated with queries for retrieving information from a database are shown in a user interface. Various other user interfaces show query code, panel display settings, function code, dependencies, etc. Queries in a first query format access a data source. Queries in a second query format access a cache database that is synchronized with the data source.

First claim

What is claimed is:

1. A computer system comprising:
one or more processors configured to execute code to cause the computer system to:
cause display of a first user interface including:
a panel associated with code to query a first dataset, wherein the panel is configured to render a visualization of the first dataset based on display settings associated with the panel;

request, from a data synchronization server, synchronization statuses of a plurality of datasets between a cache and a data source;
receive, in response to the request, the synchronization statuses of the plurality of datasets between the cache and the data source, the synchronization statuses including a synchronization status of the first dataset between the cache and the data source;
cause display of a second user interface including:
the code to query the first dataset; and
an indication of the synchronization status of the first dataset between the cache and the data source; and

generate, in response to a modification of data included in the first dataset,

a synchronization request to synchronize the first dataset between the cache and the data source.

2. The computer system of claim 1 , wherein the second user interface further includes:
a listing of the plurality of datasets; and
data included in the first dataset.

3. The computer system of claim 2 , wherein the one or more processors are further configured to execute code to cause the computer system to:
receive user input indicating a selected dataset from among the plurality of datasets; and
generate a synchronization request to synchronize the selected dataset between the cache and the data source.

4. The computer system of claim 1 , wherein the indication of the synchronization status of the first dataset includes a time of a last synchronization event.

5. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the computer system to:
receive, in the second user interface, user input changing a format of the query.

6. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the computer system to:
in response to a user interaction with a dataset name in the code in the second interface, display a dataset helper menu showing autocorrected or autocompleted names based on the dataset name, wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.

7. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the computer system to:
display, in a third user interface, a visualization showing at least one of: which documents use the first dataset, or other datasets dependent on the first dataset.

8. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the computer system to:
display an indication of a cache or data store that the first dataset is located in.

9. A computer-implemented method comprising:
causing display of a first user interface including:
a panel associated with code to query a first dataset, wherein the panel is configured to render a visualization of the first dataset based on display settings associated with the panel;

requesting, from a data synchronization server, synchronization statuses of a plurality of datasets between a cache and a data source;
receiving, in response to the request, the synchronization statuses of the plurality of datasets between the cache and the data source, the synchronization statuses including a synchronization status of the first dataset between the cache and the data source;
causing display of a second user interface including:
the code to query the first dataset; and
an indication of the synchronization status of the first dataset between the cache and the data source; and
generating, in response to a modification of data included in the first dataset, a synchronization request to synchronize the first dataset between the cache and the data source.

10. The computer-implemented method of claim 9 , wherein the second user interface further includes:
a listing of the plurality of datasets; and
data included in the first dataset.

11. The computer-implemented method of claim 10 further comprising:
receiving user input indicating a selected dataset from among the plurality of datasets; and
generating a synchronization request to synchronize the selected dataset between the cache and the data source.

12. The computer-implemented method of claim 9 , wherein the indication of the synchronization status of the first dataset includes a time of a last synchronization event.

13. The computer-implemented method of claim 9 further comprising:
receiving, in the second user interface, user input changing a format of the query.

14. The computer-implemented method of claim 9 further comprising:
in response to a user interaction with a dataset name in the code in the second interface, causing display of a dataset helper menu showing autocorrected or autocompleted names based on the dataset name, wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.

15. The computer-implemented method of claim 9 further comprising:
causing display, in a third user interface, of a visualization showing at least one of: which documents use the first dataset, or other datasets dependent on the first dataset.

16. The computer-implemented method of claim 9 further comprising:
causing display of an indication of a cache or data store that the first dataset is located in.

Assignees

• Palantir Technologies Inc

Inventors

• Sanches Jacob
• Fernandez Calvin
• Imamoglu Cihat
• De Holanda Diogo Bonfim Moraes Morant
• Cameron Geoffrey
• Korus Hannah
• Chen Noah
• Ducott Rick
• Li Sixin
• Yu Stephanie

Classifications

• G06F16/172

  Caching, prefetching or hoarding of files · CPC title

• G06F16/178

  Techniques for file synchronisation in file systems · CPC title

• G06F40/186

  Templates · CPC title

• G06F40/166

  Editing, e.g. inserting or deleting · CPC title

• G06F16/2425

  Iterative querying; Query formulation based on the results of a preceding query · CPC title