Runtime Query Path Selection for Changing Data Source Performance
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing query execution pathways in software applications are often 'locked in' at design time, leading to suboptimal performance when runtime conditions differ from expectations, as they do not adapt to changing data source performance characteristics.
Innovation Solution
Techniques for dynamically configuring query execution pathways at runtime by analyzing application code, collecting execution statistics, and selecting the most optimal pathway based on defined criteria, which can be periodically reevaluated to adapt to changing conditions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If query execution pathways are locked in at design time, then configuration simplicity is improved, but query performance deteriorates when runtime conditions differ from expectations
Solution Approach 1:
The patent implements dynamic query execution pathways that can change at runtime based on current system conditions. Instead of static design-time configuration, the system evaluates multiple execution pathways and selects the optimal one based on real-time performance metrics, data source availability, and system state, thereby resolving the contradiction between configuration simplicity and query performance adaptability
Solution Approach 2:
The system changes the parameter of execution pathway selection from fixed (design-time) to variable (runtime). By introducing runtime evaluation of execution pathways based on changing system parameters and conditions, the system maintains configuration simplicity while adapting query performance to current runtime scenarios
2Productivity
If multiple execution pathways are evaluated and configured at runtime, then query performance is improved, but system complexity increases
Solution Approach 1:
The patent applies preliminary action by pre-defining multiple execution pathways during design time, so that at runtime the system only needs to evaluate and select among predetermined options rather than creating pathways from scratch. This reduces runtime complexity while still enabling performance optimization through dynamic selection
Solution Approach 2:
The system implements feedback mechanisms by collecting execution statistics and performance metrics from runtime operations. This feedback is used to inform future execution pathway selections, creating a self-optimizing system that improves query performance without requiring complex manual configuration or intervention
3Ease of manufacture
If execution pathways are fixed at design time, then configuration effort is reduced, but adaptability to changing runtime conditions deteriorates
Solution Approach 1:
The patent makes the execution pathway configuration system universal by designing it to handle multiple data sources and various query types through a unified runtime evaluation framework. The same configuration mechanism adapts to different runtime conditions and data source scenarios, providing both configuration simplicity and high adaptability
Data Source
AI summary
The present disclosure provides techniques and solutions for providing flexible query execution pathways. Application code is analyzed to identify one or more queries. For a given query, an identifier is generated, and the query is caused to be executed using two or more execution pathways. Execution statistics are collected for each execution pathway, and defined criteria are used to select one of the execution pathways for operational use. When a query is executed, its identifier is determined and used to determine what execution pathway is configured for its execution. The query is then caused to be executed using the configured execution pathway.