Patent ID: 7765216
Filing Date: 2010-07-27
Classification: G06F

Abstract:
1. A method performed by one or more computing devices, the method comprising: accessing a master dataset, the master dataset comprising a plurality of dimensions and a plurality of rows, each dimension comprising a category or type of data, each row comprised of values corresponding to the dimensions, the rows forming columns of values that correspond to the dimensions, the master dataset further comprising a dimension table for a given dimension and an inverted index for the dimension table, the dimension table comprising rows, each row comprising a value or range of values corresponding to the category or type of data of the given dimension, the inverted index identifying, for each row of the dimension table, a corresponding row in the master dataset that contains a value of the dimension that matches the value or range of values of the row of the dimension table; obtaining a final dataset from the master dataset based on analysis parameters, the analysis parameters including at least one parameter that identifies the given dimension and defines a set of values for the given dimension, wherein the final dataset is comprised of rows of master dataset; finding the rows of the final dataset by using the inverted index to find rows of the master dataset that have values for the given dimension that match the set of values defined by the analysis parameters; performing at least one of: a grouping operation, an aggregating operation or a sorting operation, or any combination of a grouping operation, an aggregating operation or a sorting operation to configure a result set from the final dataset; and outputting the result set.