Invention Grant
- Patent Title: Mechanism for optimizing parallel execution of queries on symmetric resources
-
Application No.: US14477296Application Date: 2014-09-04
-
Publication No.: US10019478B2Publication Date: 2018-07-10
- Inventor: Yanchen Liu , Masood Mortazavi , Mengmeng Chen , Fang Cao
- 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: Conley Rose, P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method that comprises receiving a logical execution plan for a database query corresponding to a plurality of tables of the database, wherein the logical execution plan comprises one or more operators, receiving an operator cost for each of the operators in the logical execution plan, computing a first accumulated processing cost for a first of the tables based on the logical execution plan, operator selectivity, and operator costs corresponding to the first table, computing a second accumulated processing cost for a second of the tables based on the logical execution plan, operator selectivity, and operator costs corresponding to the second table, comparing the first accumulated processing cost and the second accumulated processing cost to determine a table with the highest accumulated processing cost, and responsive to comparing the accumulated processing costs, computing a physical execution plan that requires partitioning the table with the highest accumulated processing cost.
Public/Granted literature
- US20150066972A1 Mechanism for Optimizing Parallel Execution of Queries on Symmetric Resources Public/Granted day:2015-03-05
Information query