Title:
QUERY OPTIMIZATION ADAPTIVE TO SYSTEM MEMORY LOAD FOR PARALLEL DATABASE SYSTEMS
Document Type and Number:
WIPO Patent Application WO/2016/134646
Kind Code:
A1
Abstract:
A method for adaptively generating a query execution plan for a parallel database distributed among a cluster of data nodes includes receiving memory usage data from a multiple data nodes including network devices, calculating a representative memory load corresponding to the data nodes based on the memory usage data, categorizing a memory mode corresponding to the data nodes based on the calculated representative memory load, calculating an available work memory corresponding to the data nodes based on the memory mode, and generating the query execution plan for the data nodes based on the available work memory, wherein the memory usage data is based on monitored individual memory loads associated with the data nodes and the query execution plan corresponds to the currently available work memory.
Inventors:
LI HUAIZHI (US)
ZHANG GUOGEN (US)
ZHANG GUOGEN (US)
Application Number:
PCT/CN2016/074239
Publication Date:
September 01, 2016
Filing Date:
February 22, 2016
Export Citation:
Assignee:
HUAWEI TECH CO LTD (CN)
International Classes:
G06F17/30
Foreign References:
CN101594371A | 2009-12-02 | |||
CN103345447A | 2013-10-09 | |||
CN101201842A | 2008-06-18 | |||
US20060164414A1 | 2006-07-27 | |||
US20030212668A1 | 2003-11-13 |
Other References:
See also references of EP 3251034A4
Download PDF:
Previous Patent: SPRING BED CONVENIENT TO DISASSEMBLE AND ASSEMBLE
Next Patent: MIXING PIPE AND EXHAUST TREATMENT DEVICE THEREOF
Next Patent: MIXING PIPE AND EXHAUST TREATMENT DEVICE THEREOF