Invention Grant
- Patent Title: Processing window partitioning and ordering for on-line analytical processing (OLAP) functions
-
Application No.: US16100675Application Date: 2018-08-10
-
Publication No.: US10671610B2Publication Date: 2020-06-02
- Inventor: William B. Ackerman , Eileen T. Lin , David L. Meyers , Shivin S. Misra , Michael R. Zabka
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Konrad Raynes Davda & Victor LLP
- Agent Janaki K. Davda
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/2455 ; G06F16/28 ; G06F16/23

Abstract:
Provided are techniques for processing window partitioning and ordering for OLAP functions. A prior compare operation is performed by: receiving an input vector for each of one or more attributes of input data that represent one of a partition-by column and an order-by column in a database query; generating a per-attribute comparison vector for each input vector; and producing a single output vector using each per-attribute comparison vector, wherein each value of the single output vector is a Boolean attribute whose value for a given tuple is true if a current value and a most recent prior value of any of the one or more attributes are different.
Public/Granted literature
- US20180349442A1 PROCESSING WINDOW PARTITIONING AND ORDERING FOR ON-LINE ANALYTICAL PROCESSING (OLAP) FUNCTIONS Public/Granted day:2018-12-06
Information query