Systems and methods for visualizing one or more datasets

Patent metadata

Field	Value
Publication number	US-12008010-B2
Application number	US-202218085204-A
Country	US
Kind code	B2
Filing date	Dec 20, 2022
Priority date	Oct 21, 2019
Publication date	Jun 11, 2024
Grant date	Jun 11, 2024

Abstract

In some embodiments, systems and methods for visualizing one or more datasets include importing a plurality of root objects, each root object including linked data attributes and obtaining a joined dataset based on the plurality of root objects, that includes for each or the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation. The systems and methods perform an aggregation computation on the plurality of rows of related attribute data corresponding to each of the plurality of root objects to produce a corresponding single aggregation row of consolidated data for each root object and present a user interface that shows each of the plurality of root objects with their corresponding single aggregation row of consolidated data resulting from the aggregation computation, in a one-to-one manner.

First claim

What is claimed is:

1. A method for visualizing one or more datasets, the method comprising:
obtaining a joined dataset based on a plurality of root objects that comprises, for each of the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation, each root object of the plurality of root objects comprising a join cardinality;
providing a user interface to present aggregation type selection data that allows a user to select one or more aggregation types from a plurality of different types of aggregation operations to apply to the plurality of rows of related attribute data;
performing an aggregation computation of the one or more selected aggregation types on the plurality of rows of related attribute data corresponding to each root object of the plurality of root objects to produce a corresponding single aggregation row of consolidated data for each root object, the consolidated data comprising an average of the plurality of rows of related attribute data corresponding to each root object or a first attribute data from the plurality of rows of related attribute data appended next to a second attribute data from the plurality of rows of related attribute data; and
causing presentation of the user interface that presents each root object of the plurality of root objects with the corresponding single aggregation row of consolidated data resulting from the aggregation computation, the plurality of root objects being ordered on the user interface based on the join cardinality of each root object of the plurality of root objects;
wherein the method is carried out by one or more processors, and
wherein at least one of the one or more selected aggregation types comprise a concatenation operation, the concatenation operation comprising appending the first attribute data to the second attribute data, and the consolidated data comprising the first attribute data from the plurality of rows of related attribute data appended next to the second attribute data from the plurality of rows of related attribute data.

2. The method of claim 1 , wherein the join cardinality for each root object of the plurality of roots objects corresponds to a number of rows of the plurality of rows of related attribute data linked to a respective root object of the plurality of root objects.

3. The method of claim 1 , wherein a plurality of single aggregation rows with join cardinalities of one are grouped together, and wherein the causing presentation of the user interface comprises collapsing the plurality of single aggregation rows that are grouped together into a single collapsed row.

4. The method of claim 1 , further comprising:
exporting of a dataset that comprises the plurality of root objects ordered based on the join cardinality of each root object, and the corresponding single aggregation row of consolidated data after the aggregation computation has been performed.

5. The method of claim 1 , wherein the corresponding single aggregation row of consolidated data further comprises concatenation data generated by applying the concatenation operation to the plurality of rows of related attribute data corresponding to each root object.

6. The method of claim 1 , wherein the one or more aggregation types comprise a maximum value operation, wherein the aggregation row comprise a maximum value generated by applying the maximum value operation to the plurality of rows of related attribute data corresponding to each root object, and wherein the maximum value is a single numeric value.

7. A system comprising:
a processor; and
memory storing instructions that, when executed by the processor, causes the system to perform a set of operations, the set of operations comprising:
obtaining a joined dataset based on a plurality of root objects, that comprises, for each of the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation, each root object of the plurality of root objects comprising a join cardinality;
providing a user interface to present aggregation type selection data that allows a user to select one or more aggregation types from a plurality of different types of aggregation operations to apply to the plurality of rows of related attribute data;
performing an aggregation computation of the one or more selected aggregation types on the plurality of rows of related attribute data corresponding to each root object of the plurality of root objects to produce a corresponding single aggregation row of consolidated data for each root object, the consolidated data comprising an average of the plurality of rows of related attribute data corresponding to each root object or a first attribute data from the plurality of rows of related attribute data appended next to a second attribute data from the plurality of rows of related attribute data; and
causing presentation of the user interface that presents each root object of the plurality of root objects with the corresponding single aggregation row of consolidated data resulting from the aggregation computation, the plurality of root objects being ordered on the user interface based on the join cardinality of each root object of the plurality of root objects,
wherein at least one of the one or more selected aggregation types comprise a concatenation operation, the concatenation operation comprising appending the first attribute data to the second attribute data, and the consolidated data comprising the first attribute data from the plurality of rows of related attribute data appended next to the second attribute data from the plurality of rows of related attribute data.

8. The system of claim 7 , wherein the join cardinality for each root object of the plurality of roots objects corresponds to a number of rows of the plurality of rows of related attribute data linked to a respective root object of the plurality of root objects.

9. The system of claim 7 , wherein a plurality of single aggregation rows with join cardinalities of one are grouped together, and wherein the causing presentation of the user interface comprises collapsing the plurality of single aggregation rows that are grouped together into a single collapsed row.

10. The system of claim 7 , further comprising:
exporting of a dataset that comprises the plurality of root objects ordered based on the join cardinality of each root object, and the corresponding single aggregation row of consolidated data after the aggregation computation has been performed.

11. The system of claim 7 , wherein the corresponding single aggregation row of consolidated data further comprises concatenation data generated by applying the concatenation operation to the plurality of rows of related attribute data corresponding to each root object.

12. The system of claim 7 , wherein the one or more aggregation types comprise a maximum value operation, wherein the aggregation row comprises a maximum value generated by applying the maximum value operation to the plurality of rows of related attribute data corresponding to each root object, and wherein the maximum value is a single numeric value.

13. A non-transitory storage medium comprising executable instructions that when executed by a processor cause the processor to:
obtain a joined dataset based on a plurality of root objects, that comprises, for each of the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation, each root object of the plurality of root objects comprising a join cardinality;
provide a user interface to present aggrega

Assignees

• Palantir Technologies Inc

Inventors

• Bond Ethan
• Nazario Michael

Classifications

• G06F16/2456 Primary

  Join operations · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F16/248 Primary

  Presentation of query results · CPC title