Search International and National Patent Collections

1. (WO2017157160) DATA TABLE JOINING MODE PROCESSING METHOD AND APPARATUS

Pub. No.:    WO/2017/157160    International Application No.:    PCT/CN2017/075065
Publication Date: Fri Sep 22 01:59:59 CEST 2017 International Filing Date: Tue Feb 28 00:59:59 CET 2017
IPC: G06F 17/30
Applicants: ALIBABA GROUP HOLDING LIMITED
阿里巴巴集团控股有限公司
XU, Dong
徐冬
SUN, Weiguang
孙伟光
LIAN, Jiehong
连杰红
WANG, Longzhong
汪龙重
Inventors: XU, Dong
徐冬
SUN, Weiguang
孙伟光
LIAN, Jiehong
连杰红
WANG, Longzhong
汪龙重
Title: DATA TABLE JOINING MODE PROCESSING METHOD AND APPARATUS
Abstract:
The present invention provides a data table joining mode processing method and apparatus. The method comprises: setting a parameter list used for cost estimation according to a distributed data warehouse environment where a to-be-joined data table is located; according to parameters in the parameter list and execution logics of candidate data table connection modes, pre-estimating execution cost when joining calculation is performed on the to-be-joined data table by means of candidate data table connection modes; and selecting a target data table connection mode used for performing joining calculation on the to-be-joined data table, according to the pre-estimated the execution cost when the joining calculation is performed on the to-be-joined data table by means of the candidate data table connection modes. In the present application, data tables can be connected by selecting a proper join algorism, thereby saving resources of the distributed data warehouse, and improving the query efficiency.