Patent ID: 8326797

Claim:
A method for implementing on-line analytical processing (OLAP) set-level slice and dice operations, comprising: creating queries using structured query language on a computer and storing the queries on a storage medium; utilizing an algorithm to rewrite the queries and implement OLAP slice and dice operations, wherein the algorithm: rewrites the queries as ANDED set-level predicates with a remaining expression; for at least one of the ANDED set-level predicates in the queries: utilizes at least one selected from the group consisting of INTERSECT and UNION functions for query expressions with multiple set-level predicates; utilizes at least one selected from the group consisting of CONTAINS, NOT CONTAINS, CONTAINED BY, NOT CONTAINED BY, EQUALS, and NOT EQUALS functions for rewriting the queries; utilizes a DISTINCT function in combination with the UNION function on a group key; and inserts the group key into a first temporary table; for the remaining expression inserts the group key into a second temporary table; joins query expressions using the group key; and uses an IN function with the group key; and joins the set-level predicates from the queries to dimension tables corresponding to fact tables; applying the algorithm to the queries to generate a result of the queries; and outputting the result of the queries on a computer user interface.