Invention Grant
- Patent Title: Query plan optimization for large payload columns
-
Application No.: US15960890Application Date: 2018-04-24
-
Publication No.: US10176223B2Publication Date: 2019-01-08
- Inventor: Gopi K. Attaluri , Vijayshankar Raman , David C. Sharpe , Richard S. Sidle , Liping Zhang
- 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 Christopher K. McLane
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A computer-implemented method includes receiving a query plan. The method includes identifying a plurality of qualified relevant rows and one or more encoding candidate payload columns. The method includes analyzing the relevant rows in the encoding candidate payload columns to yield a count of distinct contents and a payload column width. The method includes estimating a cost and determining whether the cost is larger than an amount of available memory for on-the-fly encoding all of the plurality of encoding candidate payload columns. The method is responsive to the estimated cost being less than the amount of available memory, by on-the-fly encoding the encoding candidates and responsive to the estimated cost being greater than the amount of available memory by on-the-fly encoding fewer than all of the encoding candidates so as not to exceed the available memory, and leaving alone one or more remaining encoding candidate payload columns unencoded.
Public/Granted literature
- US20180225328A1 QUERY PLAN OPTIMIZATION FOR LARGE PAYLOAD COLUMNS Public/Granted day:2018-08-09
Information query