Interactive interfaces as computerized tools to present summarization data of dataset attributes for collaborative datasets

• US 10,691,710 B2
• Filed: 03/09/2017
• Issued: 06/23/2020
• Est. Priority Date: 06/19/2016
• Status: Active Grant

• Current Assignee: Data.World, Inc.
• Original Assignee: Data.World, Inc.
• Inventors: Reynolds, Shad William, Griffith, David Lee, Loyens, Jon, Jacob, Bryon Kristen
• Primary Examiner(s): Dwivedi, Mahesh H
• Application Number:
  US15/454,955
• Publication Number:
  US 20170364568A1
• Time in Patent Office: 1,202 Days
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range

Abstract

Various embodiments relate generally to data science and data analysis, and computer software and systems, to provide an interface between repositories of disparate datasets and computing machine-based entities that seek access to the datasets, and, more specifically, to a computing and data storage platform that facilitates consolidation of one or more datasets, whereby one or more interfaces, such as user interfaces, may be implemented as computerized tools for presenting summarization of dataset attributes to facilitate discovery, formation, and analysis of interrelated collaborative datasets. In some examples, a method may include presenting data representing summary characteristic data in a user interface. This may include user interface elements each specifying a value of a dataset attribute for a collaborative dataset. Also, the method may include presenting aggregated data attributes for a subset of the collaborative dataset associated with the linked atomized datasets. In one example, an interactive overlay window may be activated.

Claims

1. A method comprising:

presenting data representing summary characteristic data for subsets of data in a user interface, each subset of data being presented to include user interface elements each specifying a value of a dataset attribute for a collaborative dataset including linked atomized datasets;

determining selection of a first user interface element of the user interface to identify a subset of data to form an identified subset of data from the collaborative dataset;

activating a subset of executable code to present in a portion of the user interface an interactive overlay window as a second interface element responsive to identifying the identified subset of the collaborative dataset,

presenting the interactive overlay window to include aggregated data attributes for the subset of the collaborative dataset associated with the linked atomized datasets;

determining selection of a third user interface element of the interactive overlay window to identify a graphical representation of a range of values in a distribution of a plurality of ranges of values for a column of data in a data file for the collaborative dataset;

activating another subset of executable code to present in a portion of the interactive overlay window a nested overlay window as a fourth interface element responsive to identifying the graphical representation of the range of values;

presenting the nested overlay window to include one or more values of dataset attributes for the range of values;

receiving a data signal indicating to either add a linked atomized dataset or omit the linked atomized dataset in generating the aggregated data attributes;

identifying that either the linked atomized data set is either added or omitted;

transmitting an instruction via a programmatic interface to recalculate values of the aggregated data attributes based on adding or omitting the linked atomized data set; and

receiving recalculated values of the aggregated data attributes.

2. The method of claim 1 wherein presenting the data representing the summary characteristic data for the subsets of data comprises:

presenting data that represents the summary characteristic data for columns of data, each column of data including a corresponding subset of data.

3. The method of claim 1 wherein the identified subset of the collaborative dataset comprises:

a column of data in a data file for the collaborative dataset.

4. The method of claim 1 further comprising specifying a quality of the dataset attribute including

presenting data that represents one or more values of the dataset attribute.

5. The method of claim 4 wherein presenting the data that represents the value of the dataset attribute comprises:

presenting as the one or more values as data representing one or more of a string, a number, and a range of values displayed as a graphical representation of a distribution.

6. The method of claim 1 further comprising:

presenting the distribution of the plurality of ranges of values in a histogram data format.

7. The method of claim 1 further comprising:

presenting a number of data points associated with the values in the range of values.

8. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting a number of distinct data points associated with distinct values of a value of the dataset attribute for the column of data.

9. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting a number of data points associated with non-empty data cells in the column of data; and

presenting another number of data points associated with null values for data in the column of data,

wherein a null value represents an empty data cell.

10. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting values of one or more of a mean value, maximum value, a minimum value and a standard deviation value for the values of the dataset attribute for the column of data.

11. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting values of a skewness value and a kurtosis value for the values of the dataset attribute for the column of data.

12. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting values of a textual representation of an annotation for the column of data.

13. The method of claim 1 wherein presenting the interactive overlay window to include the aggregated data attributes further comprises:

identifying a column of data associated with the identified subset of the collaborative dataset; and

presenting values of a textual representation of a data type for the column of data.

14. The method of claim 1 wherein determining the selection of the first user interface element comprises:

detecting selection via a pointer device as a user interface element.

15. The method of claim 1 wherein the atomized dataset and another dataset include subsets of linked data points.

16. The method of claim 15 wherein the linked data points comprise triples.

17. The method of claim 16 wherein at least one triple of the triples are formatted to comply with a Resource Description Framework (“

RDF”

) data model.

18. An apparatus comprising:

a memory including executable instructions; and

a processor, responsive to executing the instructions, is configured to;

present data representing summary characteristic data for subsets of data in a user interface, each subset of data being presented to include user interface elements each specifying a value of a dataset attribute for a collaborative dataset including linked atomized datasets;

determine selection of a first user interface element of the user interface to identify a subset of data to form an identified subset of data from the collaborative dataset;

activate a subset of executable code to present in a portion of the user interface an interactive overlay window as a second interface element responsive to identifying the identified subset of the collaborative dataset; and

present the interactive overlay window to include aggregated data attributes for the subset of the collaborative dataset associated with the linked atomized datasets;

determine selection of a third user interface element of the interactive overlay window to identify a graphical representation of a range of values in a distribution of a plurality of ranges of values for a column of data in a data file for the collaborative dataset;

activate another subset of executable code to present in a portion of the interactive overlay window a nested overlay window as a fourth interface element responsive to identifying the graphical representation of the range of values;

present the nested overlay window to include one or more values of dataset attributes for the range of values;

receive a data signal indicating to either add a linked atomized dataset or omit the linked atomized dataset in generating the aggregated data attributes;

identify that either the linked atomized data set is either added or omitted;

transmit an instruction via a programmatic interface to recalculate values of the aggregated data attributes based on adding or omitting the linked atomized data set; and

receive recalculated values of the aggregated data attributes.