Methods and systems for selectively retrieving data to provide a limited dataset for incorporation into a pivot table
First Claim
Patent Images
1. A computer-implemented method for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table, the method comprising the following steps performed by one or more computer processors of a computer:
- a. receiving in a user interface to a database application program executing in the computer, a designation of a grouping column in the initial dataset, wherein the grouping column comprises one or more groups of grouping values;
b. receiving in the user interface a designation of a partition column in the initial dataset, wherein the partition column comprises one or more partition values;
c. receiving in the user interface a designation of an ordering column in the initial dataset, wherein the ordering column comprises one or more ordering values, and wherein the initial dataset comprises one or more rows, wherein each row comprises a corresponding grouping value, a corresponding partition value, and a corresponding ordering value;
d. receiving in the user interface a designation of a specific partition value;
e. identifying rows in the initial dataset which comprise the specific partition value;
f. selecting the rows that include the specific partition value, and limiting the selected rows based on a ranking of the corresponding ordering value of each selected row to provide a limited set of rows;
g. expanding the limited set of rows to include all rows that share grouping values in common with the grouping values of the limited set of rows to provide the limited dataset;
h. retrieving from memory, a designated row limit, and on condition that a number of rows in the expanded ones of the limited ones of the selected rows exceed the row limit, reducing a number of rows in the expanded ones of the limited ones of the selected rows to cause the number of rows to meet the designated row limit, but on condition that the number of rows in expanded ones of the limited ones of the selected rows falls short of the row limit, inserting additional rows of a different partition value into the expanded ones of the limited ones of the selected rows until the number of rows is equivalent to the designated row limit;
i. inserting the expanded ones of the limited ones of the selected rows into a pivot table comprising a row for each distinct grouping value and a column for each distinct partition value in the limited data set, wherein each distinct grouping value and each distinct partition value forms a distinct grouping value-partition value pair that defines a unique cell in the pivot table and corresponds to a distinct row of the limited dataset, by populating each cell defined by each distinct grouping value-partition value pair with the corresponding ordering value from each distinct row in the limited dataset, and,j. displaying the pivot table in the user interface to the database application program.
2 Assignments
0 Petitions
Accused Products
Abstract
The present disclosure provides inclusive and exclusive approaches, including computer-implemented methods for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table. Also provided are related systems and non-transitory computer-readable recording media.
19 Citations
15 Claims
-
1. A computer-implemented method for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table, the method comprising the following steps performed by one or more computer processors of a computer:
-
a. receiving in a user interface to a database application program executing in the computer, a designation of a grouping column in the initial dataset, wherein the grouping column comprises one or more groups of grouping values; b. receiving in the user interface a designation of a partition column in the initial dataset, wherein the partition column comprises one or more partition values; c. receiving in the user interface a designation of an ordering column in the initial dataset, wherein the ordering column comprises one or more ordering values, and wherein the initial dataset comprises one or more rows, wherein each row comprises a corresponding grouping value, a corresponding partition value, and a corresponding ordering value; d. receiving in the user interface a designation of a specific partition value; e. identifying rows in the initial dataset which comprise the specific partition value; f. selecting the rows that include the specific partition value, and limiting the selected rows based on a ranking of the corresponding ordering value of each selected row to provide a limited set of rows; g. expanding the limited set of rows to include all rows that share grouping values in common with the grouping values of the limited set of rows to provide the limited dataset; h. retrieving from memory, a designated row limit, and on condition that a number of rows in the expanded ones of the limited ones of the selected rows exceed the row limit, reducing a number of rows in the expanded ones of the limited ones of the selected rows to cause the number of rows to meet the designated row limit, but on condition that the number of rows in expanded ones of the limited ones of the selected rows falls short of the row limit, inserting additional rows of a different partition value into the expanded ones of the limited ones of the selected rows until the number of rows is equivalent to the designated row limit; i. inserting the expanded ones of the limited ones of the selected rows into a pivot table comprising a row for each distinct grouping value and a column for each distinct partition value in the limited data set, wherein each distinct grouping value and each distinct partition value forms a distinct grouping value-partition value pair that defines a unique cell in the pivot table and corresponds to a distinct row of the limited dataset, by populating each cell defined by each distinct grouping value-partition value pair with the corresponding ordering value from each distinct row in the limited dataset, and, j. displaying the pivot table in the user interface to the database application program. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A non-transitory computer-readable recording medium for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table comprising instructions, which, when executed by one or more processors, cause the one or more processors of a computer to:
-
a. receive a designation of a grouping column in the initial dataset, wherein the grouping column comprises one or more groups of grouping values; b. receive a designation of a partition column in the initial dataset, wherein the partition column comprises one or more partition values; c. receive a designation of an ordering column in the initial dataset, wherein the ordering column comprises one or more ordering values, and wherein the initial dataset comprises one or more rows, wherein each row comprises a corresponding grouping value, a corresponding partition value, and a corresponding ordering value; d. receive a designation of a specific partition value; e. identify rows in the initial dataset which comprise the specific partition value; f. select the rows that include the specific partition value, and limit the selected rows based on a ranking of the corresponding ordering value of each selected row to provide a limited set of rows; g. expand the limited set of rows to include all rows that share grouping values in common with the grouping values of the limited set of rows to provide the limited dataset; h. retrieve from memory of the computer a designated row limit, and on condition that a number of rows in the expanded ones of the limited ones of the selected rows exceed the row limit, reduce a number of rows in the expanded ones of the limited ones of the selected rows to cause the number of rows to meet the designated row limit, but on condition that the number of rows in expanded ones of the limited ones of the selected rows falls short of the row limit, insert additional rows of a different partition value into the expanded ones of the limited ones of the selected rows until the number of rows is equivalent to the designated row limit; i. insert the expanded ones of the limited ones of the selected rows into a pivot table comprising a row for each distinct grouping value and a column for each distinct partition value in the limited data set, wherein each distinct grouping value and each distinct partition value forms a distinct grouping value-partition value pair that defines a unique cell in the pivot table and corresponds to a distinct row of the limited dataset, by populating each cell defined by each distinct grouping value-partition value pair with the corresponding ordering value from each distinct row in the limited dataset, and, j. display the pivot table in a user interface to a database application program.
-
-
11. A computer-implemented method for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table, the method comprising the following steps performed by one or more computer processors:
-
a. receiving a designation of a grouping column in the initial dataset, wherein the grouping column comprises one or more groups of grouping values; b. receiving a designation of a partition column in the initial dataset, wherein the partition column comprises a plurality of partition values comprising one or more partition values; c. receiving a designation of an ordering column in the initial dataset, wherein the ordering column comprises one or more ordering values, and wherein the initial dataset comprises one or more rows, wherein each row comprises a corresponding grouping value, a corresponding partition value, and a corresponding ordering value; d. partitioning rows of the one or more rows, which share a common partition value, into separate partitions according to the shared common partition value; e. establishing a ranking value of each of the rows within each separate partition according to the corresponding ordering value of each row; f. calculating a minimum ranking value for each separate group of grouping values which corresponds to the row within each group having the lowest ranking value; g. applying a minimum ranking value limit to each of the separate groups of grouping values to exclude groups of grouping values that do not meet the minimum ranking value limit, wherein the group of grouping values not excluded by the minimum ranking value limit provide the limited dataset; h. retrieving from memory, a designated row limit, and on condition that a number of rows in the expanded ones of the limited ones of the selected rows exceed the row limit, reducing a number of rows in the expanded ones of the limited ones of the selected rows to cause the number of rows to meet the designated row limit, but on condition that the number of rows in expanded ones of the limited ones of the selected rows falls short of the row limit, inserting additional rows of a different partition value into the expanded ones of the limited ones of the selected rows until the number of rows is equivalent to the designated row limit; i. inserting the expanded ones of the limited ones of the selected rows into a pivot table comprising a row for each distinct grouping value and a column for each distinct partition value in the limited data set, wherein each distinct grouping value and each distinct partition value forms a distinct grouping value-partition value pair that defines a unique cell in the pivot table and corresponds to a distinct row of the limited dataset, by populating each cell defined by each distinct grouping value-partition value pair with the corresponding ordering value from each distinct row in the limited dataset, and, j. displaying the pivot table in the user interface to the database application program. - View Dependent Claims (12, 13, 14)
-
-
15. A non-transitory computer-readable recording medium for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table comprising instructions, which, when executed by one or more processors, cause the one or more processors to:
-
a. receive a designation of a grouping column in the initial dataset, wherein the grouping column comprises one or more groups of grouping values; b. receive a designation of a partition column in the initial dataset, wherein the partition column comprises one or more partition values; c. receive a designation of an ordering column in the initial dataset, wherein the ordering column comprises one or more ordering values, and wherein the initial dataset comprises one or more rows, wherein each row comprises a corresponding grouping value, a corresponding partition value, and a corresponding ordering value; d. partition rows of the one or more rows, which share a common partition value, into separate partitions according to the shared common partition value; e. establish a ranking value of each of the rows within each separate partition according to the corresponding ordering value of each row; f. calculate a minimum ranking value for each separate group of grouping values which corresponds to the row within each group having the lowest ranking value; g. apply a minimum ranking value limit to each of the separate groups of grouping values to exclude groups of grouping values that do not meet the minimum ranking value limit, wherein the group of grouping values not excluded by the minimum ranking value limit provide the limited dataset; h. retrieve from memory of the computer a designated row limit, and on condition that a number of rows in the expanded ones of the limited ones of the selected rows exceed the row limit, reduce a number of rows in the expanded ones of the limited ones of the selected rows to cause the number of rows to meet the designated row limit, but on condition that the number of rows in expanded ones of the limited ones of the selected rows falls short of the row limit, insert additional rows of a different partition value into the expanded ones of the limited ones of the selected rows until the number of rows is equivalent to the designated row limit; i. insert the expanded ones of the limited ones of the selected rows into a pivot table comprising a row for each distinct grouping value and a column for each distinct partition value in the limited data set, wherein each distinct grouping value and each distinct partition value forms a distinct grouping value-partition value pair that defines a unique cell in the pivot table and corresponds to a distinct row of the limited dataset, by populating each cell defined by each distinct grouping value-partition value pair with the corresponding ordering value from each distinct row in the limited dataset, and, j. display the pivot table in a user interface to a database application program.
-
Specification