# US 2018/0024701 A1 · Cached database and synchronization system for providing dynamic linked panels in user interface

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2018/0024701 A1
- Document ID: US20180024701A1
- Status: Published application
- Kind: A1
- Application number: 15/660,193
- Filed: 2017-07-26
- Published: 2018-01-25
- Earliest claimed: 2016-07-21
- Assignees: Palantir Technologies Inc.
- Applicants: Palantir Technologies Inc.
- Inventors: Jacob Sanches; Calvin Fernandez; Cihat Imamoglu; Diogo Bonfim Moraes Morant De Holanda; Geoffrey Cameron; Hannah Korus; Noah Chen; Rick Ducott; Sixin Li; Stephanie Yu
- Web page: https://patentgrep.com/patent/US20180024701A1

## CPC

- G06F 40/143: Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
- G06F 3/0481: based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F 16/172: Caching, prefetching or hoarding of files
- G06F 16/178: Techniques for file synchronisation in file systems
- G06F 16/2425: {Iterative querying; Query formulation based on the results of a preceding query}
- G06F 40/166: Editing, e.g. inserting or deleting
- G06F 40/186: Templates
- G09G 5/14: Display of multiple viewports
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G09G: ARRANGEMENTS OR CIRCUITS FOR CONTROL OF INDICATING DEVICES USING STATIC MEANS TO PRESENT VARIABLE INFORMATION (arrangements for transferring data between digital computers and displays G06F3/14; static indicating arrangements comprising an association of a number of separate sources or light control cells G09F9/00; static indicating arrangements comprising integral associations of a number of light sources H01J, H01K, H10H, H05B33/12; scanning, transmission or reproduction of documents or the like, e.g. facsimile transmission, details thereof H04N1/00)

## 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.

## Claims

### Claim 1

A computer system comprising:
one or more processors configured to execute code to cause the system to:
display a first user interface comprising:
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;
display a second user interface comprising:
the code to query the first dataset;
request, from a data synchronization server, a synchronization status of datasets between a cache and a data source;
receive, in response to the request, synchronization statuses of a plurality of datasets, the plurality of datasets including the first dataset;
display, as part of one or more user interfaces:
a listing of the plurality of datasets;
data included in the first dataset; and
information about a synchronization of the first dataset between a cache and a data source; and
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.

### Claim 2 (depends on 1)

The computer system of claim 1, wherein the information about the synchronization of the first dataset includes a time of a last synchronization event.

### Claim 3 (depends on 1)

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

### Claim 4 (depends on 1)

The computer system of claim 1, wherein the one or more processors are further configured to execute code to cause the 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.

### Claim 5 (depends on 4)

The computer system of claim 4, wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.

### Claim 6 (depends on 1)

The computer system of claim 1, wherein the one or more processors are further configured to execute code to cause the system to:
generate, in response to a modification of the data included in the first dataset, a synchronization request to synchronize the first dataset between the cache and the data source.

### Claim 7 (depends on 1)

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

### Claim 8 (depends on 1)

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

### Claim 9 (depends on 1)

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

### Claim 10

A computer-implemented method comprising:
displaying a first user interface comprising:
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;
displaying a second user interface comprising:
the code to query the first dataset;
requesting, from a data synchronization server, a synchronization status of datasets between a cache and a data source;
receiving, in response to the request, synchronization statuses of a plurality of datasets, the plurality of datasets including the first dataset; and
displaying, as part of one or more user interfaces:
a listing of the plurality of datasets;
data included in the first dataset; and
information about a synchronization of the first dataset between a cache and a data source.

### Claim 11 (depends on 10)

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.

### Claim 12 (depends on 10)

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

### Claim 13 (depends on 10)

The computer-implemented method of claim 10, further comprising:
in response to a user interaction with a dataset name in the code in the second interface, displaying a dataset helper menu showing autocorrected or autocompleted names based on the dataset name.

### Claim 14 (depends on 13)

The computer system of claim 13, wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.

### Claim 15 (depends on 10)

The computer-implemented method of claim 10, further comprising:
generating, in response to a modification of the data included in the first dataset, a synchronization request to synchronize the first dataset between the cache and the data source.

### Claim 16 (depends on 10)

The computer-implemented method of claim 10, further comprising:
displaying, in a third user interface, a visualization showing which documents use the first dataset.

### Claim 17 (depends on 10)

The computer-implemented method of claim 10, further comprising:
displaying, in a third user interface, a visualization showing other datasets dependent on the first dataset.

### Claim 18 (depends on 10)

The computer-implemented method of claim 10, further comprising:
displaying an indication of a cache or data store that the first dataset is located in.