INTERACTIVE USER INTERFACE FOR DYNAMIC DATA ANALYSIS EXPLORATION AND QUERY PROCESSING

• US 20170116259A1
• Filed: 01/04/2017
• Published: 04/27/2017
• Est. Priority Date: 12/29/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Elliot, Mark, Duffield, Benjamin, Borochoff, Adam
• Granted Patent: US 9,870,389 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials

Abstract

The systems and methods described herein provide highly dynamic and interactive data analysis user interfaces which enable data analysts to quickly and efficiently explore large volume data sources. In particular, a data analysis system, such as described herein, may provide features to enable the data analyst to investigate large volumes of data over many different paths of analysis while maintaining detailed and retraceable steps taken by the data analyst over the course of an investigation, as captured via the data analyst'"'"'s queries and user interaction with the user interfaces provided by the data analysis system. Data analysis paths may involve exploration of high volume data sets, such as Internet proxy data, which may include trillions of rows of data. The data analyst may pursue a data analysis path that involves, among other things, applying filters, joining to other tables in a database, viewing interactive data visualizations, and so on.

Claims

1. A computer system comprising:

one or more hardware computer processors configured to execute code in order to cause the one or more hardware computer processors to;

provide a user interface configured to display at least a first panel and a second panel, wherein;

the first panel is configured to provide an analysis path visualization, and

the second panel is configured to provide one or more selectable elements for analyzing one or more data sets;

in response to a first user input selecting a first selectable element of the one or more selectable elements;

determine a first analysis type associated with the first selectable element; and

add a first icon to the first panel representing the first analysis type associated with the first selectable element; and

in response to a second user input selecting a second selectable element of the one or more selectable elements;

determine a second analysis type associated with the second selectable element;

add a second icon to the first panel representing the second analysis type associated with the second selectable element; and

add an edge to the first panel connecting the first and second icons so as to visually indicate an analysis path.

2. The computer system of claim 1, wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:

in response to a third user input, based on the analysis path, apply a first analysis of the first analysis type to the one or more data sets to generate a first analyzed one or more data sets; and

apply a second analysis of the second analysis type to the first analyzed one or more data sets to generate a second analyzed one or more data sets.

3. The computer system of claim 2, wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:

provide a first data visualization representing the first analyzed one or more data sets.

4. The computer system of claim 3, wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:

provide a second data visualization representing the second analyzed one or more data sets.

5. The computer system of claim 4, wherein the first or second data visualization comprises at least one of:

a time series view, a time grid view, a pivot table view, or a data summary view.

6. The computer system of claim 1, wherein the first and second icons include at least a symbol representative of the respective first and second analysis types.

7. The computer system of claim 1, wherein the first or second analysis types include at least one of:

a filter operation, or a join or merge operation.

8. The computer system of claim 1, wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:

in response to a third user input selecting a third selectable element of the one or more selectable elements;

determine a third analysis type associated with the third selectable element;

add a third icon to the first panel representing the third analysis type associated with the third selectable element; and

add a second edge to the first panel connecting the first and third icons so as to visually indicate a second analysis path different from the first analysis path.

9. The computer system of claim 1, wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:

generate, based on the analysis path, a query to apply to the one or more data sets; and

apply the query to the one or more data sets.

10. The computer system of claim 9, wherein the query comprises one or more filters or merge operations to apply to the one or more data sets.