Invention Grant
- Patent Title: Parallel execution of parsed query based on a concurrency level corresponding to an average number of available worker threads
- Patent Title (中): 基于与平均可用工作线程数相对应的并发级别并行执行解析查询
-
Application No.: US13925629Application Date: 2013-06-24
-
Publication No.: US09329899B2Publication Date: 2016-05-03
- Inventor: Anastasia Ailamaki , Tobias Scheuer , Iraklis Psaroudakis , Norman May
- Applicant: SAP AG
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fountainhead Law Group PC
- Main IPC: G06F9/50
- IPC: G06F9/50 ; G06F17/30 ; G06F9/48

Abstract:
Systems and method for a task scheduler with dynamic adjustment of concurrency levels and task granularity are disclosed for improved execution of highly concurrent analytical and transactional systems. The task scheduler can avoid both over commitment and underutilization of computing resources by monitoring and controlling the number of active worker threads. The number of active worker threads can be adapted to avoid underutilization of computing resources by giving the OS control of additional worker threads processing blocked application tasks. The task scheduler can dynamically determine a number of parallel operations for a particular task based on the number of available threads. The number of available worker threads can be determined based on the average availability of worker threads in the recent history of the application. Based on the number of available worker threads, the partitionable operation can be partitioned into a number of sub operations and executed in parallel.
Public/Granted literature
- US20140380322A1 Task Scheduling for Highly Concurrent Analytical and Transaction Workloads Public/Granted day:2014-12-25
Information query