Invention Grant
US09535947B2 Offloading projection of fixed and variable length database columns
有权
卸载固定和可变长度数据库列的投影
- Patent Title: Offloading projection of fixed and variable length database columns
- Patent Title (中): 卸载固定和可变长度数据库列的投影
-
Application No.: US14868678Application Date: 2015-09-29
-
Publication No.: US09535947B2Publication Date: 2017-01-03
- Inventor: Sameh W. Asaad , Parijat Dube , Hong Min , Bharat Sukhwani , Mathew S. Thoennes
- 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: Cantor Colburn LLP
- Agent Mercedes Hobson
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F17/27

Abstract:
In some embodiments, a query recipient is configured to determine that a database query warrants a first projection operation to project a plurality of input rows to a plurality of projected rows. Each of the input rows has one or more variable-length columns. A projection controller is configured to construct a first projection control block to describe the first projection operation. For this construction, the projection controller is configured to construct a plurality of projection control elements, each one corresponding to a corresponding column in the input rows, and a header to specify the order of the projection control elements. The projection controller is further configured to offload the first projection operation to a hardware accelerator, and to provide the first projection control block to the hardware accelerator, where the first projection control block enables the hardware accelerator to perform the first projection operation at streaming rate.
Public/Granted literature
- US20160019262A1 OFFLOADING PROJECTION OF FIXED AND VARIABLE LENGTH DATABASE COLUMNS Public/Granted day:2016-01-21
Information query