International business machines corporation (20240134853). MAINTAINING QUERY PERFORMANCE DURING HIGH CONCURRENCY OPERATIONS simplified abstract
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 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 20240134853 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 and generating access plans for identified resource sets.
- It determines available resources and selects a resource set based on available capacity.
- The method then selects an access plan based on the available resources and executes the query, returning results to the source.
Potential Applications
This technology could be applied in various industries where real-time query optimization is crucial, such as finance, healthcare, and e-commerce.
Problems Solved
This technology solves the problem of optimizing query performance in a database system with limited resources during concurrent query execution.
Benefits
The benefits of this technology include improved query performance, efficient resource utilization, and enhanced scalability in database systems.
Potential Commercial Applications
One potential commercial application of this technology could be in cloud computing services, where optimizing query performance is essential for customer satisfaction and cost-effectiveness.
Possible Prior Art
One possible prior art for this technology could be the concept of query optimization in database systems, where different access plans are generated and selected based on available resources.
What are the specific resource sets identified in the method?
The specific resource sets identified in the method are sets of resources that can be utilized for processing the query, such as CPU, memory, and storage.
How does the method determine which resource set to select based on available resources?
The method determines which resource set to select based on available resources by choosing the set that is closest to the available capacity of the database system, ensuring optimal performance and resource utilization.
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.