METHODS AND SYSTEMS FOR SELECTIVELY RETRIEVING DATA TO PROVIDE A LIMITED DATASET FOR INCORPORATION INTO A PIVOT TABLE

摘要

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.

主权项

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:
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 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. receiving 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; and 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.