Systems and methods for visualizing one or more datasets
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.
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;
performing an aggregation computation of one or more 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;
wherein the consolidated data for each root object comprises a first attribute data and a second attribute data;
wherein the first attribute data is one of from the plurality of rows of related attribute data;
wherein the second attribute data is one of the plurality of rows of related attribute data;
wherein in the corresponding single aggregation row of consolidated data for each root object, the first attribute data and the second attribute data are concatenated next to each other; and
causing presentation of a 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;
wherein the method is carried out by one or more processors.
2 . The method of claim 1 , wherein each root object of the plurality of root objects comprises a join cardinality, and wherein the plurality of root objects are ordered on the user interface based on the join cardinality of each root object of the plurality of root objects.
3 . The method of claim 2 , 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.
4 . The method of claim 2 , 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 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.
6 . The method of claim 1 , wherein at least one aggregation type of the one or more aggregation types includes a concatenation operation, and wherein the first attribute data from the plurality of rows of related attribute data concatenated next to the second attribute data from the plurality of rows of related attribute data is generated by applying the concatenation operation to the plurality of rows of related attribute data corresponding to each root object.
7 . 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.
8 . A system comprising:
one or more processors; and
one or more memories storing instructions that, when executed by the one or more processors, 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;
performing an aggregation computation of one or more 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;
wherein the consolidated data for each root object comprises a first attribute data and a second attribute data;
wherein the first attribute data is one of from the plurality of rows of related attribute data;
wherein in the corresponding single aggregation row of consolidated data for each root object, the first attribute data and the second attribute data are concatenated next to each other; and
causing presentation of a 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.
9 . The system of claim 8 , wherein each root object of the plurality of root objects comprises a join cardinality, and wherein the plurality of root objects are ordered on the user interface based on the join cardinality of each root object of the plurality of root objects.
10 . The method of claim 9 , 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.
11 . The system of claim 9 , 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.
12 . The system of claim 8 , 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.
13 . The system of claim 8 , wherein at least one aggregation type of the one or more aggregation types includes a concatenation operation, and wherein the first attribute data from the plurality of rows of related attribute data concatenated next to the second attribute data from the plurality of rows of related attribute data is generated by applying the concatenation operation to the plurality of rows of related attribute data corresponding to each root object.
14 . The system of claim 8 , 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.
15 . 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;
perform an aggregation computation of one or more 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;
wherein the consolidated data comprises a first attribute data and a second attribute data;
wherein the first attribute data is one of the plurality of rows of related attribute data;
wherein the second attribute data is one of the plurality of rows of related attribute data;
wherein in the corresponding single aggregation row of consolidated data for each root object, the first attribute data and the second attribute data are concatenated next to each other; and
cause presentation of a 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.
16 . The non-transitory storage medium of claim 15 , wherein each root object of the plurality of root objects comprises a join cardinality, and wherein the plurality of root objects are ordered on the user interface based on the join cardinality of each root object of the plurality of root objects.
17 . The non-transitory storage medium of claim 16 , 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.
18 . The non-transitory storage medium of claim 16 , 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.
19 . The non-transitory storage medium of claim 15 , 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 single aggregation rows that are grouped together into a single collapsed row.
20 . The non-transitory storage medium of claim 15 , wherein at least one aggregation type of the one or more aggregation types includes a concatenation operation, and wherein the first attribute data from the plurality of rows of related attribute data concatenated next to the second attribute data from the plurality of rows of related attribute data is generated by applying the concatenation operation to the plurality of rows of related attribute data corresponding to each root object.