Current Slide

Small screen detected. You are viewing the mobile version of SlideWiki. If you wish to edit slides you will need to use a larger device.

The “Compute Cube” Operator

  • Cube definition and computation in DMQL
    define cube sales [item, city, year]: sum (sales_in_dollars)
    compute cube sales
  • Transform it into a SQL-like language (with a new operator cube by, introduced by Gray et al.’96)
    SELECT item, city, year, SUM (amount)
    FROM SALES
    CUBE BY item, city, year
  • Need compute the following Group-Bys
    (date, product, customer),
    (date,product),(date, customer), (product, customer),
    (date), (product), (customer)
    ()


Speaker notes:

Content Tools

Sources

There are currently no sources for this slide.