Invention Grant
- Patent Title: Allocating resources for parallel execution of query plans
- Patent Title (中): 分配资源以并行执行查询计划
-
Application No.: US12192061Application Date: 2008-08-14
-
Publication No.: US08402469B2Publication Date: 2013-03-19
- Inventor: Sumit Kumar Bose , Srikumar Krishnamoorthy , Nilesh Dilip Ranade
- Applicant: Sumit Kumar Bose , Srikumar Krishnamoorthy , Nilesh Dilip Ranade
- Applicant Address: IN Bangalore
- Assignee: Infosys Limited
- Current Assignee: Infosys Limited
- Current Assignee Address: IN Bangalore
- Agency: Klarquist Sparkman, LLP
- Priority: IN881/CHE/2008 20080408
- Main IPC: G06F9/46
- IPC: G06F9/46

Abstract:
Computing resources can be assigned to sub-plans within a query plan to effect parallel execution of the query plan. For example, computing resources in a grid can be represented by nodes, and a shortest path technique can be applied to allocate machines to the sub-plans. Computing resources can be provisionally allocated as the query plan is divided into query plan segments containing one or more sub-plans. Based on provisional allocations to the segments, the computing resources can then be allocated to the sub-plans within respective segments. Multiprocessor computing resources can be supported. The techniques can account for data locality. Both pipelined and partitioned parallelism can be addressed. Described techniques can be particularly suited for efficient execution of bushy query plans in a grid environment. Parallel processing will reduce the overall response time of the query.
Public/Granted literature
- US20090254916A1 ALLOCATING RESOURCES FOR PARALLEL EXECUTION OF QUERY PLANS Public/Granted day:2009-10-08
Information query