IP Library Granted Patent US 11,436,264
Granted Patent B2
US 11,436,264 · App. 16/830,096 · Granted Sep 6, 2022

Graphical user interface for a database system

Inventors: Michael Shelton (New York, NY); Radu-Andrei Szasz (London, GB); Walker Burgin (Seattle, WA); Zhen Dai (Brooklyn, NY)
Assignee: Palantir Technologies Inc.
G06F16/3328G06F3/048G06F16/24578G06F16/3349G06F16/489
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,436,264
App. No.
16/830,096
Granted
Sep 6, 2022
Kind
B2
Abstract

Systems and methods are provided for improved interactive graphical user interfaces. The system allows users to visually construct queries of a database. The system can dynamically generate visual representations of supplemental data and cumulative data. Users can share annotations related to user input queries via the graphical user interface.

Claims (61)

1. A computer-implemented method, comprising:

by a computer system comprising one or more computer hardware processors and one or more storage devices,

receiving, from a user interface, first user input comprising a plurality of item related query parameters;

executing a query based at least on the plurality of item related query parameters to retrieve item results;

causing presentation, in the user interface, of a visualization of the item results, wherein the visualization of the items results comprises (i) a graph and (ii) a time axis showing the graph over a period of time;

receiving, from the user interface, second user input indicating a request for supplemental data;

determining a first efficacy indicator based at least in part on the second user input, supplemental data, and a first item associated with the item results, wherein the supplemental data is different from the item results, and wherein the first efficacy indicator is associated with a first time period;

determining a second efficacy indicator based at least in part on the second user input, supplemental data, and a second item associated with the item results, wherein the second efficacy indicator is associated with a second time period; and

causing presentation, in the user interface, of an updated visualization of the item results and the first efficacy indicator, wherein the updated visualization of the item results and the first efficacy indicator comprises (i) the graph, (ii) a first visual representation corresponding to the first efficacy indicator, the first visual representation showing the first efficacy indicator associated with the first time period on the time axis, and (iii) a second visual representation corresponding to the second efficacy indicator, the second visual representation showing the second efficacy indicator associated with the second time period on the time axis.

2. The computer-implemented method of claim 1 , further comprising:

generating the first visual representation with a height relative to the first efficacy indicator, wherein presentation of the first visual representation includes the height.

3. The computer-implemented method of claim 2 , wherein generating the first visual representation further comprises:

calculating the height from at least the first efficacy indicator and a default height.

4. The computer-implemented method of claim 1 , wherein causing presentation of the updated visualization further comprises arranging the first visual representation as partially overlapping the second visual representation.

5. The computer-implemented method of claim 1 , wherein the item results comprise a plurality of first data value pairs, the computer-implemented method further comprising:

receiving, from the user interface, third user input comprising a cumulative option selection;

calculating a plurality of cumulative data value pairs, wherein calculating the plurality of cumulative data value pairs comprises:

calculating a current cumulative value from (i) a previous cumulative value and (ii) a current data value from the plurality of first data value pairs; and

presenting, in the user interface, the plurality of cumulative data value pairs as a cumulative graph.

6. The computer-implemented method of claim 1 , wherein determining the first efficacy indicator further comprises:

determining a first metric for a first time period and the first item;

determining a historical metric for another time period different than the first time period and the first item; and

determining a difference value between the first metric and the historical metric, wherein the first efficacy indicator is based at least in part on the difference value.

7. The computer-implemented method of claim 1 , further comprising:

constructing the query, wherein constructing the query further comprises:

identifying a data source indicated by one of the plurality of item related query parameters; and

determining a query field indicated by one of the plurality of item related query parameters,

wherein the query comprises the query field, and

wherein executing the query is directed towards the data source.

8. A system comprising:

a non-transitory computer storage medium configured to at least store computer-executable instructions; and

one or more computer hardware processors in communication with the non-transitory computer storage medium, the one or more computer hardware processors configured to execute the computer-executable instructions to at least:

receive, from a user interface, first user input comprising a plurality of item related query parameters;

execute a query based at least on the plurality of item related query parameters to retrieve item results;

cause presentation, in the user interface, of a visualization of the item results, wherein the visualization of the items results comprises (i) a graph and (ii) a time axis showing the graph over a period of time;

receive, from the user interface, second user input indicating a request for supplemental data;

determine a first efficacy indicator based at least in part on the second user input, supplemental data, and a first item associated with the item results, wherein the supplemental data is different from the item results, and wherein the first efficacy indicator is associated with a first time period; and

determine a second efficacy indicator based at least in part on the second user input, supplemental data, and a second item associated with the item results, wherein the second efficacy indicator is associated with a second time period;

cause presentation, in the user interface, of an updated visualization of the item results and the first efficacy indicator, wherein the updated visualization of the item results and the first efficacy indicator comprises (i) the graph, (ii) a first visual representation corresponding to the first efficacy indicator, the first visual representation showing the first efficacy indicator associated with the first time period on the time axis, and (iii) a second visual representation corresponding to the second efficacy indicator, the second visual representation showing the second efficacy indicator associated with the second time period on the time axis.

9. The system of claim 8 , wherein the one or more computer hardware processors are configured to execute further computer-executable instructions to at least:

generate the first visual representation with a height relative to the first efficacy indicator, wherein presentation of the first visual representation includes the height.

10. The system of claim 9 , wherein generating the first visual representation further comprises:

calculating the height from at least the first efficacy indicator and a default height.

11. The system of claim 8 , wherein causing presentation of the updated visualization further comprises:

determining a ranking of the first efficacy indicator and the second efficacy indicator; and

arranging, in the user interface, the first visual representation and the second visual representation according to the ranking.

12. The system of claim 8 , wherein the item results comprise a plurality of first data value pairs, and wherein the one or more computer hardware processors are configured to execute further computer-executable instructions to at least:

receive, from the user interface, third user input comprising a cumulative option selection;

calculate a plurality of cumulative data value pairs, wherein calculating the plurality of cumulative data value pairs comprises:

calculating a current cumulative value from (i) a previous cumulative value and (ii) a current data value from the plurality of first data value pairs; and

present, in the user interface, the plurality of cumulative data value pairs as a cumulative graph.

13. The system of claim 8 , wherein determining the first efficacy indicator further comprises:

determining a first metric for the first time period and the first item;

determining a historical metric for another time period different than the first time period and the first item; and

determining a difference value between the first metric and the historical metric, wherein the first efficacy indicator is based at least in part on the difference value.

14. The system of claim 8 , wherein the one or more computer hardware processors are configured to execute further computer-executable instructions to at least:

construct the query, wherein constructing the query further comprises:

identifying a data source indicated by one of the plurality of item related query parameters; and

determining a query field indicated by one of the plurality of item related query parameters,

wherein the query comprises the query field, and

wherein executing the query is directed towards the data source.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 14, 2023
From: SHELTON, MICHAEL; SZASZ, RADU-ANDREI; BURGIN, WALKER; DAI, ZHEN
To: PALANTIR TECHNOLOGIES INC.
Reel/Frame 064908/0953 →
SECURITY INTEREST Recorded Jul 3, 2022
From: PALANTIR TECHNOLOGIES INC.
To: WELLS FARGO BANK, N.A.
Reel/Frame 060572/0506 →
Continuity (3)
Continuation 15677977 · Aug 15, 2017
Provisional Application 62509634 · May 22, 2017
Related Publication 20200327154A1 · Oct 15, 2020