Invention Grant
- Patent Title: Memory-aware plan negotiation in query concurrency control
-
Application No.: US15411713Application Date: 2017-01-20
-
Publication No.: US10740332B2Publication Date: 2020-08-11
- Inventor: Mingyi Zhang , Huaizhi Li , Yu Dong , Cheng Zhu
- Applicant: Futurewei Technologies, Inc.
- Applicant Address: US TX Plano
- Assignee: Futurewei Technologies, Inc.
- Current Assignee: Futurewei Technologies, Inc.
- Current Assignee Address: US TX Plano
- Agency: Vierra Magen Marcus LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2455

Abstract:
Embodiments of the present technology relate 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.
Public/Granted literature
- US20180210916A1 MEMORY-AWARE PLAN NEGOTIATION IN QUERY CONCURRENCY CONTROL Public/Granted day:2018-07-26
Information query