Invention Grant
- Patent Title: Control method for performing multi-table join operation and corresponding apparatus
-
Application No.: US16370343Application Date: 2019-03-29
-
Publication No.: US11301470B2Publication Date: 2022-04-12
- Inventor: Wenjie Liu , Jiansheng Wei , Xiaofei Zhang , Lei Chen
- Applicant: HUAWEI TECHNOLOGIES CO., LTD.
- Applicant Address: CN Guangdong
- Assignee: HUAWEI TECHNOLOGIES CO., LTD.
- Current Assignee: HUAWEI TECHNOLOGIES CO., LTD.
- Current Assignee Address: CN Guangdong
- Agency: Womble Bond Dickinson (US) LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/00 ; G06F16/22 ; G06F16/2455

Abstract:
A control method for performing a multi-table join operation and a corresponding apparatus are disclosed. Fields in a table whose fields participating in a theta join operation and used in the query statement meet a first preset condition are decomposed, to obtain a plurality of first field groups, so that the theta join operation can be implemented in steps in a form of the plurality of field groups. This can reduce a data amount of Cartesian product calculation during one join operation, greatly reduce network transmission overheads, computing overheads, and memory overheads, and improve execution efficiency.
Public/Granted literature
- US20190228014A1 CONTROL METHOD FOR PERFORMING MULTI-TABLE JOIN OPERATION AND CORRESPONDING APPARATUS Public/Granted day:2019-07-25
Information query