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.

Complex Aggregation at Multiple Granularities: Multi-Feature Cubes

  • Multi-feature cubes (Ross, et al. 1998): Compute complex queries involving multiple dependent aggregates at multiple granularities
  • Ex. Grouping by all subsets of {item, region, month}, find the maximum price in 2010 for each group, and the total sales among all maximum price tuples

    select item, region, month, max(price), sum(R.sales)
    from purchases
    where year = 2010
    cube by item, region, month: R
    such that R. price = max(price)
  • Continuing the last example, among the max price tuples, find the min and max shelf live, and find the fraction of the total sales due to tuple that have min shelf life within the set of all max price tuples

Speaker notes:

Content Tools

Sources

There are currently no sources for this slide.