Invention Grant
- Patent Title: Min/max query with synopsis guided scan order
-
Application No.: US15371852Application Date: 2016-12-07
-
Publication No.: US09886476B2Publication Date: 2018-02-06
- Inventor: Madhusudan Kalarikal Janardhana , Andanagouda F. Patil , Steven R. Pearson
- 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
- Agent Gilbert Harmon, Jr.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
An approach for synopsis guided scan processing of MIN/MAX data queries where a minimal or maximal data query operation and a synopsis store are received. The synopsis store includes at least one of tuple range identifiers, column minimal and maximal metadata values. The synopsis store is sorted, where the column minimal or maximal metadata values search order is created for the tuple range identifiers. Dataset data associated with the tuple range identifiers is searched in the search order for a minimal or maximal value result until the minimal value result is less than or equal to a next column minimal metadata values or the maximal value result is greater than or equal to a next column maximal metadata values respectively and the minimal or maximal value result associated with the respective minimal or maximal data query operation is output.
Public/Granted literature
- US20170212927A1 MIN/MAX QUERY WITH SYNOPSIS GUIDED SCAN ORDER Public/Granted day:2017-07-27
Information query