Title:
MEMORY-AWARE PLAN NEGOTIATION IN QUERY CONCURRENCY CONTROL
Document Type and Number:
WIPO Patent Application WO/2018/133821
Kind Code:
A1
Abstract:
The present technology relates managing database query concurrency. A method of the present technology can include receiving a query, generating a first query plan that can be used to execute the query in system memory without any system memory constraints, and estimating a system memory cost for executing the query in the system memory using the first query plan. The method can also include placing the query in a queue if available system memory does not satisfy the estimated system memory cost. The method can further include conditionally selecting the query from the queue, conditionally generating a second query plan for the query that can be used to execute the query in the system memory in compliance with a system memory constraint, and conditionally executing the query in the system memory.
Inventors:
ZHANG MINGYI (US)
LI HUAIZHI (US)
DONG YU (US)
ZHU CHENG (US)
LI HUAIZHI (US)
DONG YU (US)
ZHU CHENG (US)
Application Number:
PCT/CN2018/073245
Publication Date:
July 26, 2018
Filing Date:
January 18, 2018
Export Citation:
Assignee:
HUAWEI TECH CO LTD (CN)
International Classes:
G06F17/30
Foreign References:
| US20120136850A1 | 2012-05-31 | |||
| CN102999377A | 2013-03-27 | |||
| US20030065688A1 | 2003-04-03 | |||
| US20060190430A1 | 2006-08-24 | |||
| CN104408088A | 2015-03-11 |
Download PDF: