Invention Grant
- Patent Title: Method for query execution planning
-
Application No.: US15493271Application Date: 2017-04-21
-
Publication No.: US10552414B2Publication Date: 2020-02-04
- Inventor: Andreas Brodt , Oliver Schiller , Marc Schwind , Mathias Trumpp
- 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 Richard A. Wilhelm
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/22 ; G06F16/2458

Abstract:
The present disclosure provides a computer implemented method and system for processing queries. The first data table comprises a set of data blocks. Each of the set of data blocks may be assigned respective attribute value information. A query involving a query condition on at least a first attribute of the first data table may be received. And a subset of the set of data blocks to be accessed may be selected based on the query condition and using the attribute value information. Furthermore, a guaranteed bound may be determined for a statistical metric on the first attribute based on at least one of the number of data blocks of the subset of data blocks and the attribute value information of the subset of data blocks. The guaranteed bound for the statistical metric may be used when determining a query execution plan for the received query.
Public/Granted literature
- US20170270161A1 METHOD FOR QUERY EXECUTION PLANNING Public/Granted day:2017-09-21
Information query