Invention Grant
- Patent Title: Supporting set-level slice and dice in data warehouses
-
Application No.: US13607320Application Date: 2012-09-07
-
Publication No.: US09646071B2Publication Date: 2017-05-09
- Inventor: Bin He , Ying Chen
- Applicant: Bin He , Ying Chen
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Shimokaji IP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method and system for coping with slice and dice operations in data warehouses is disclosed. An external approach may be utilized, creating queries using structured query language on a computer. An algorithm may be used to rewrite the queries. The resulting predicates may be joined to dimension tables corresponding to fact tables. An internal approach may be utilized, using aggregation functions with early aggregation for creating the queries. The results of the slice and dice operations may be outputted to a user on a computer monitor.
Public/Granted literature
- US20130006969A1 SUPPORTING SET-LEVEL SLICE AND DICE IN DATA WAREHOUSES Public/Granted day:2013-01-03
Information query