×

Supporting set-level slice and dice in data warehouses

  • US 8,326,797 B2
  • Filed: 11/11/2009
  • Issued: 12/04/2012
  • Est. Priority Date: 11/11/2009
  • Status: Expired due to Fees
First Claim
Patent Images

1. 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 expressioninserts 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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×