Computer systems and methods for automatically viewing multidimensional databases
First Claim
Patent Images
1. A computer implemented method for displaying a graphical representation of a dataset, comprising:
- at a computer having one or more processors and memory storing programs executed by the one or more processors;
displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset;
receiving a user selection of at least a subset of the multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type; and
in response to the user selection and the user ordering,forming a plurality of alternative views using the dataset based on the user ordering of the user-selected terms;
determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system;
selecting from among the plurality of alternative views a resulting view for displaying the dataset based on comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and
displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view.
2 Assignments
0 Petitions
Accused Products
Abstract
A method for automatically forming the clearest and most useful visual plot for a given dataset of tuples. A best view type is selected for a view that includes a subsequently added new field. The visual plot is populated with the data in the view and then automatically rendered for the user. A dataset that is retrieved from a storage is analyzed to identify all the data types found in the dataset, and to determine the best view type to assign to the dataset'"'"'s views. The visual plot is then populated with the data according to this best view type, and is automatically rendered for the user.
-
Citations
202 Claims
-
1. A computer implemented method for displaying a graphical representation of a dataset, comprising:
-
at a computer having one or more processors and memory storing programs executed by the one or more processors; displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; receiving a user selection of at least a subset of the multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type; and in response to the user selection and the user ordering, forming a plurality of alternative views using the dataset based on the user ordering of the user-selected terms; determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system; selecting from among the plurality of alternative views a resulting view for displaying the dataset based on comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 201)
-
-
37. A computer implemented method for displaying a graphical representation of a dataset with a plurality of tuples, comprising:
-
at a computer having one or more processors and memory storing programs executed by the one or more processors; displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; receiving a user instruction for generating a graphical representation of the dataset, wherein the user instruction includes a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type; and in response to the user selection and the user ordering, forming a plurality of alternative views based on the user ordering of the user-selected terms, each alternative view showing all tuples, or a transformation of all tuples, in the dataset; determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system; selecting a resulting view from the plurality of rated alternative views, based upon a user selected option and comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view. - View Dependent Claims (38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 202)
-
-
69. A computer program product including a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising instructions that are executed to display a graphical representation of a dataset, the instructions comprising:
-
a module for displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; a field receiver for receiving a user selection of at least a subset of the multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, wherein each user-selected term has an associated data type; a resulting view selector for, in response to the user selection and the user ordering, forming a plurality of alternative views using the dataset based on the user ordering of the user-selected terms; determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system; selecting a resulting view from the plurality of alternative views for displaying the dataset based on comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and a dataset displayer for displaying the dataset or a transformation of the dataset according to the resulting view in the data visualization region. - View Dependent Claims (70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104)
-
-
105. A computer program product including a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising instructions that are executed to display a graphical representation of a dataset with a plurality of tuples, the instructions comprising:
-
a module for displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; an alternative view former for forming a plurality of alternative views in response to a user instruction for generating a graphical representation of the dataset, each alternative view showing all tuples, or a transformation of all tuples, in the dataset, wherein the user instruction includes a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type, and determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system, wherein the user instruction includes a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type; a resulting view selector for selecting a resulting view from the plurality of rated alternative views in response to the user instruction, based upon a user selected option and comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and a dataset displayer for displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view in response to the user instruction. - View Dependent Claims (106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132)
-
-
133. A computer system for automatically and visually displaying a graphical representation of a dataset, the computer system comprising:
-
a central processing unit; a memory, coupled to the central processing unit, the memory storing; the dataset; a programming module comprising, comprising; instructions for displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; instructions for receiving a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, wherein each field has an associated data type; instructions for forming a plurality of alternative views using the dataset based on the user ordering of the user-selected terms; instructions for determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system and selecting a resulting view from the plurality of alternative views for displaying the dataset based on comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and instructions for displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view. - View Dependent Claims (134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168)
-
-
169. A computer system for automatically and visually displaying a graphical representation of a dataset with a plurality of tuples, the computer system comprising:
-
a central processing unit; a memory, coupled to the central processing unit, the memory storing; the dataset; a programming module comprising; instructions for displaying a graphical user interface window including a schema display region and a data visualization region, wherein the schema display region includes multiple terms corresponding to a plurality of fields of the dataset, wherein each field defines a respective category of the dataset; instructions for forming a plurality of alternative views in response to a user instruction for generating a graphical representation of the dataset, each alternative view showing all tuples, or a transformation of all tuples, in the dataset, wherein the user instruction includes a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type, and determining a rank for each of the plurality of alternative views based on the user-specified order and the associated data types of the user-selected terms and a rating system, wherein the user instruction includes a user selection of at least a subset of multiple terms in the schema display region and a user ordering of the user-selected terms in the data visualization region, each of the user-selected terms having an associated data type; instructions for selecting a resulting view from the plurality of rated alternative views in response to the user instruction, based upon a user selected option and comparing the rank of the resulting view with the rank of at least another view of the plurality of alternative views; and instructions for displaying the dataset or a transformation of the dataset in the data visualization region according to the resulting view in response to the user instruction. - View Dependent Claims (170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200)
-
Specification