Methods and systems for automatically determining a default hierarchy from data
First Claim
1. A method of determining a natural hierarchy for a data set, the method comprising:
- receiving, at a computer system, a data set, wherein the data set is stored in a database;
analyzing, at the computer system, the data set to determine a plurality of categories and a plurality of quantities included within the data set;
based on the determined plurality of categories and quantities, determining, at the computer system, one or more pair-wise combinations within the data set, wherein the one or more pair-wise combinations each include a first field and a second field from the database;
determining, at the computer system, a distinct count for each entry in the first field grouped by the second field of the one or more pair-wise combinations;
determining, at the computer system, that the distinct count for each entry has a value equal to one;
based on the determination that the distinct counts for each entry have a value equal to one, setting the first field in the pair-wise combination as the parent and the second field in the pair-wise combination as the child in a default hierarchy for the data set, wherein the natural hierarchy is the most appropriate hierarchy for the data set based on the data within the data set;
determining a visual representation most suited for the natural hierarchy, based on structural aspects of the natural hierarchy; and
mapping features of the visual representation to the structural aspects of the natural hierarchy.
1 Assignment
0 Petitions
Accused Products
Abstract
This disclosure describes, generally, methods and systems for determining a natural hierarchy for a data set. The method determines one or more pair-wise combinations within the data set. The one or more pair-wise combinations each include a first field and a second field from the database. The method then determines a distinct count for each entry in the first field grouped by the second field of the one or more pair-wise combinations, and determines that the distinct counts for each entry has a value equal to one. The method further includes based on the determination that the distinct counts for each entry have a value equal to one, setting the first field in the pair-wise combination as the parent and the second field in the pair-wise combination as the child in a default hierarchy for the data set.
12 Citations
20 Claims
-
1. A method of determining a natural hierarchy for a data set, the method comprising:
-
receiving, at a computer system, a data set, wherein the data set is stored in a database; analyzing, at the computer system, the data set to determine a plurality of categories and a plurality of quantities included within the data set; based on the determined plurality of categories and quantities, determining, at the computer system, one or more pair-wise combinations within the data set, wherein the one or more pair-wise combinations each include a first field and a second field from the database; determining, at the computer system, a distinct count for each entry in the first field grouped by the second field of the one or more pair-wise combinations; determining, at the computer system, that the distinct count for each entry has a value equal to one; based on the determination that the distinct counts for each entry have a value equal to one, setting the first field in the pair-wise combination as the parent and the second field in the pair-wise combination as the child in a default hierarchy for the data set, wherein the natural hierarchy is the most appropriate hierarchy for the data set based on the data within the data set; determining a visual representation most suited for the natural hierarchy, based on structural aspects of the natural hierarchy; and mapping features of the visual representation to the structural aspects of the natural hierarchy. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A system for determining a natural hierarchy for a data set, the system comprising:
-
a storage device configured to store a database comprising a data set; and a computer system coupled with the storage device, the computer system configured to execute the following commands; receiving the data set from the database, analyzing the data set to determine a plurality of categories and a plurality of quantities included within the data set, based on the determined plurality of categories and quantities, determining one or more pair-wise combinations within the data set, wherein the one or more pair-wise combinations each include a first field and a second field from the database, determining a distinct count for each entry in the first field grouped by the second field of the one or more pair-wise combinations, determining that the distinct counts for each entry has a value equal to one, based on the determination that the distinct counts for each entry have a value equal to one, setting the first field in the pair-wise combination as the parent and the second field in the pair-wise combination as the child in a default hierarchy for the data set, wherein the natural hierarchy is the most appropriate hierarchy for the data set based on the data within the data set, determining a visual representation most suited for the natural hierarchy, based on structural aspects of the natural hierarchy, and mapping features of the visual representation to the structural aspects of the natural hierarchy. - View Dependent Claims (17)
-
-
18. A non-transitory machine-readable medium having sets of instructions stored thereon which, when executed by a machine, cause the machine to:
-
receive a data set, wherein the data set being stored in a database; analyze the data set to determine a plurality of categories and a plurality of quantities included within the data set; based on the determined plurality of categories and quantities, determine one or more pair-wise combinations within the data set, wherein the one or more pair-wise combinations each include a first field and a second field from the database; determine a distinct count for each entry in the first field grouped by the second field of the one or more pair-wise combinations; determine that the distinct counts for each entry has a value equal to one; and based on the determination that the distinct counts for each entry have a value equal to one, set the first field in the pair-wise combination as the parent and the second field in the pair-wise combination as the child in a default hierarchy for the data set, wherein the natural hierarchy is the most appropriate hierarchy for the data set based on the data within the data set; determine a visual representation most suited for the natural hierarchy, based on structural aspects of the natural hierarchy; and map features of the visual representation to the structural aspects of the natural hierarchy. - View Dependent Claims (19, 20)
-
Specification