Invention Grant
- Patent Title: MIN/MAX query with synopsis guided scan order
- Patent Title (中): MIN / MAX查询与概要指导扫描顺序
-
Application No.: US15131532Application Date: 2016-04-18
-
Publication No.: US09569490B1Publication Date: 2017-02-14
- 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.
Information query