Patent ID: 8145626

Claim:
A computer-implemented method comprising: receiving a data filter table for filtering a collection of data, wherein the collection of data is configured as a star schema that includes one fact table and one or more dimension tables associated with the fact table, wherein the data filter table includes a plurality of columns, wherein one or more columns of the plurality of columns are associated with a corresponding one or more dimension tables in the collection of data; and processing the collection of data, wherein the processing includes: applying the data filter table to one or more dimension tables in the collection of data to generate one or more modified dimension tables, including for each column in the data filter table associated with a dimension table, generating a modified dimension table, wherein the modified dimension table includes rows from the associated dimension table in the collection of data that satisfy the data filter table and does not include rows from the associated dimension table in the collection of data that do not satisfy the data filter table; applying each modified dimension table to the fact table to generate a first modified fact table, wherein the first modified fact table includes rows from the fact table that satisfy each modified dimension table and does not include rows from the fact table that do not satisfy each modified dimension table; and applying the data filter table to the first modified fact table to generate a second modified fact table, wherein the second modified fact table includes rows from the first modified fact table that satisfy the data filter table and does not include rows from the first modified table that do not satisfy the data filter table.