18047669. MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)
Contents
- 1 MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Unanswered Questions
- 1.11 Original Abstract Submitted
MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
Xiao Xiao Chen of Beijing (CN)
Peng Hui Jiang of Beijing (CN)
MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS - A simplified explanation of the abstract
This abstract first appeared for US patent application 18047669 titled 'MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS
Simplified Explanation
The abstract describes a computer-implemented method for dynamically switching access plans for a query during concurrent query execution in a database system.
- The method involves receiving a query for processing.
- Generating access plans for identified resource sets.
- Determining available resources and selecting a resource set based on available capacity.
- Selecting an access plan based on available resources.
- Executing the query and returning results to the source.
Potential Applications
This technology could be applied in various database systems to optimize query processing and resource utilization.
Problems Solved
1. Efficiently managing resources during concurrent query execution. 2. Dynamically adjusting access plans based on available capacity.
Benefits
1. Improved performance and resource utilization in database systems. 2. Enhanced scalability and responsiveness during query processing.
Potential Commercial Applications
Optimizing database performance in large-scale applications.
Possible Prior Art
There may be prior art related to dynamic access plan switching in database systems, but further research is needed to identify specific examples.
Unanswered Questions
How does this method handle conflicting resource demands during concurrent query execution?
The method may prioritize resource allocation based on predefined criteria or algorithms to resolve conflicts.
What impact does dynamic access plan switching have on overall system stability and reliability?
The method's effectiveness in maintaining system stability and reliability under varying workloads needs to be evaluated through testing and analysis.
Original Abstract Submitted
A computer-implemented method dynamically switches access plans for a query during concurrent query execution. The method includes receiving a first query configured to be processed by a database system. The method also includes generating, for the first query, an access plan for each of identified resource sets. The method includes determining a first set of available resources that represent an available capacity for the database system. The method further includes selecting a first resource set of the one or more resource sets, where the selecting is based on the first set of available resources being closest to the first resource set. The method also includes selecting, based on the first set of available resources, a first access plan of the one or more access plans. The method includes executing the first query and returning results of the first query to a source of the first query.
