Automatically generating graphical data displays based on structured descriptions

• US 10,642,853 B2
• Filed: 09/21/2017
• Issued: 05/05/2020
• Est. Priority Date: 12/14/2016
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Mallah, Amr Al, Visbal, Alexander, Philipson, David, Thompson, James, D'Souza, Natasha, Xie, Ryan, Spiegel, Wayne Chen
• Primary Examiner(s): Spratt, Beau D
• Application Number:
  US15/711,712
• Publication Number:
  US 20190079980A1
• Time in Patent Office: 957 Days
• Field of Search: None
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: 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
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces

Abstract

In one embodiment, a data processing method comprises, using a first computer, in response to detecting a change in a data source: automatically generating a dataset comprising a subset of data from the data source, generating a unique dataset identifier, and associating the dataset identifier with the dataset in digital data storage; generating a display description that comprises: the dataset identifier; and for each particular graphical data display widget among one or more graphical data display widgets, instructions that specify a widget type, an order and one or more widget configuration values for the particular graphical data display widget; transmitting the display description to a second computer.

Claims

1. A method comprising:

using a first computer, in response to detecting a change in data stored in a data source;

automatically generating a dataset comprising a subset of data from the data source based upon the detected change in the data, generating a unique dataset identifier, and associating the unique dataset identifier with the dataset in digital data storage;

generating a display description, wherein the display description comprises;

the unique dataset identifier; and

for each particular graphical data display widget among one or more graphical data display widgets, instructions that specify a widget type, an order and one or more widget configuration values for the particular graphical data display widget;

formatting the dataset to conform with a data format defined by the one or more widget configuration values of the one or more graphical data display widgets, and storing the formatted dataset and the associated unique dataset identifier in the data source;

wherein the formatted dataset comprises data values representing content to be presented within the one or more graphical data display widgets;

wherein the data format defined by the one or more widget configuration values comprises at least one of a data format for one or more columns that make up the content, data values that make up the content, or names for the set of columns that make up the content; and

transmitting the display description to a second computer.

2. The method of claim 1, wherein the widget type of the particular data display widget specifies one of:

a line chart, a key value chart, or a bar chart.

3. The method of claim 1, wherein the instructions of the display description further comprise a structured query language (SQL) statement that specifies a database query configured to retrieve data for display using the particular graphical data display widget.

4. The method of claim 1, wherein the widget type of the particular data display widget specifies a line chart having an X axis and a Y axis, and wherein the instructions of the display description further comprise a structured query language (SQL) statement that specifies a database query configured to retrieve data for display using the particular graphical data display widget and including a first column value of the dataset for use in rendering the X axis and a second column value of the dataset for use in rendering the Y axis.

5. The method of claim 1 wherein the instructions of the display description specify one or more of a title, subtitle, format, labeling features, grouping and sorting of data, axis display parameters, line display parameters, units and display formats.

6. The method of claim 1, further comprising generating the display description comprising the unique dataset identifier, and for each particular graphical data display widget among two or more graphical data display widgets, the instructions that specify a widget type, one or more widget configuration values for the particular graphical data display widget, wherein the instructions comprise a set of first instructions of a first widget specify a first ordinal value that is higher in order than a second ordinal value in a set of second instructions of a second widget.

7. The method of claim 1, further comprising:

using the first computer to detect the change in the data source by detecting a new single table in a particular data storage system;

automatically generating the subset of data from the data source by applying a predetermined schema to the new single table that was detected.

8. A method comprising:

receiving, from a first computer at a second computer, a display description that comprises;

a unique dataset identifier; and

a plurality of instructions that specify a widget type, a display order and one or more widget configuration values for each widget among one or more graphical data display widgets;

wherein the unique dataset identifier identifies a dataset having been generated and formatted to conform with a data format defined by the one or more widget configuration values of the one or more graphical data display widgets, using a subset of data from a data source, and is associated in digital data storage with the unique dataset identifier, in response to detecting a change in data stored in the data source;

wherein the dataset comprises data values representing content to be presented within the one or more graphical data display widgets;

wherein the data format defined by the one or more widget configuration values comprises at least one of a data format for one or more columns that make up the content, data values that make up the content, or names for the set of columns that make up the content;

fetching the dataset based on the unique dataset identifier;

rendering the one or more graphical data display widgets according to each display order, each widget type and the widget configuration values; and

displaying the one or more of graphical data display widgets in a display of the second computer.

9. The method of claim 8, further comprising rendering the one or more graphical data display widgets as a line chart, a key value chart, or a bar chart based upon the widget type.

10. The method of claim 8, further comprising:

obtaining, from the instructions of the display description, a structured query language (SQL) statement;

submitting the SQL statement as a database query to the data source;

receiving from the data source particular data for display using the particular graphical data display widget.

11. The method of claim 8, wherein the widget type of the particular data display widget specifies a line chart having an X axis and a Y axis;

the method further comprising;

obtaining, from the instructions of the display description, a structured query language (SQL) statement;

submitting the SQL statement as a database query to the data source;

receiving from the data source particular data for display using the particular graphical data display widget, including a first column value of the dataset for use in rendering the X axis and a second column value of the dataset for use in rendering the Y axis.

12. The method of claim 8 wherein the instructions of the display description specify one or more of a title, subtitle, format, labeling features, grouping and sorting of data, axis display parameters, line display parameters, units and display formats.

13. The method of claim 8, further comprising:

receiving the display description comprising the unique dataset identifier, and for each particular graphical data display widget among two or more graphical data display widgets, the instructions that specify a widget type, one or more widget configuration values for the particular graphical data display widget, wherein the instructions comprise a set of first instructions of a first widget specify a first ordinal value that is higher in order than a second ordinal value in a set of second instructions of a second widget;

sorting the first ordinal value and the second ordinal value in order;

rendering the second widget first, and the first widget second, based on the first ordinal value and the second ordinal value.

14. The method of claim 8, further comprising:

generating and displaying a graphical user interface comprising a dashboard notification list and a widget notification list;

wherein the dashboard notification list comprises one or more dashboard notification switches that are programmed to receive input to toggle corresponding notifications on or off for specified notification conditions;

wherein the widget notification list comprises a plurality of selectable list items that are programmed to cause navigating the graphical user interface to a widget notification panel;

generating and displaying, a widget-level notification panel comprising a widget-level notifications list having one or more widget notification switches that are programmed to receive input to toggle corresponding notifications on or off for specified notification conditions pertaining to a specified widget;

determining that a programmed triggering condition has occurred for a particular dashboard notification switch or widget notification switch that is toggled on;

generating a notification in response to determining that a programmed triggering condition has occurred for a particular switch that is toggled on.