Graphical user interface for a database system

Patent metadata

Field	Value
Publication number	US-11436264-B2
Application number	US-202016830096-A
Country	US
Kind code	B2
Filing date	Mar 25, 2020
Priority date	May 22, 2017
Publication date	Sep 6, 2022
Grant date	Sep 6, 2022

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.

First claim

What is claimed is:

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

Assignees

• Palantir Technologies Inc

Inventors

• Shelton Michael
• Szasz Radu-Andrei
• Burgin Walker
• Dai Zhen

Classifications

• G06F16/3328 Primary

  using graphical result space presentation or visualisation · CPC title

• G06F16/3349

  Reuse of stored results of previous queries · CPC title

• G06F16/489

  using time information · CPC title

• G06F16/24578

  using ranking · CPC title

• G06F3/048

  Interaction techniques based on graphical user interfaces [GUI] · CPC title