18616771. INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT simplified abstract (SAP SE)
INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT
Organization Name
Inventor(s)
Jaeyeon Won of Cambridge MA (US)
INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT - A simplified explanation of the abstract
This abstract first appeared for US patent application 18616771 titled 'INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT
Simplified Explanation: The method described in the patent application manages the size of a query plan cache intelligently by measuring actual compilation times of generating query execution plans, estimating ideal compilation times, monitoring differences between actual and ideal times, and adjusting the cache size accordingly.
Key Features and Innovation:
- Measures actual compilation times of generating query execution plans
- Estimates ideal compilation times assuming no plan evictions
- Monitors differences between actual and ideal times in continuous time windows
- Adjusts cache size in runtime based on monitored differences
Potential Applications: This technology can be applied in database management systems, query optimization tools, and any system that utilizes query plan caching to improve performance and efficiency.
Problems Solved: This technology addresses the challenge of efficiently managing the size of query plan caches to optimize query execution performance and resource utilization.
Benefits:
- Improved query execution performance
- Efficient resource utilization
- Dynamic cache size management
- Enhanced system scalability
Commercial Applications: Optimizing query performance in large-scale databases, improving response times in data analytics platforms, enhancing efficiency in cloud computing environments.
Prior Art: Prior research in database query optimization, cache management algorithms, and performance tuning in database systems may provide relevant background information for this technology.
Frequently Updated Research: Stay updated on advancements in database query optimization, cache management techniques, and real-time performance tuning strategies to enhance the effectiveness of this technology.
Questions about Intelligent Query Plan Cache Size Management: 1. How does this technology compare to traditional methods of query plan cache management? 2. What are the potential implications of adjusting the cache size in runtime based on monitored differences in compilation times?
Original Abstract Submitted
A method for intelligent query plan cache size management can be implemented. The method measures actual compilation times of generating query execution plans for a plurality of incoming queries. At least some of the query execution plans are stored in a query execution plan cache. The method can estimate ideal compilation times of generating the query execution plans for the plurality of incoming queries under an assumption that no query execution plan is evicted from the query execution plan cache, monitor differences between the actual compilation times and the ideal compilation times in continuous time windows, and adjust a size of the query execution plan cache in runtime based on the monitored differences.