Just-In-Time Code Generation for Query Error Detection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database management systems face challenges in optimizing performance due to complex queries and high transaction volumes, leading to difficulties in determining errors in software applications during execution.
Innovation Solution
A computer-implemented method that generates just-in-time executable code for queries, incorporating testing codes associated with conditions, which are selectively activated to detect errors and faults, thereby enabling development checks without impacting performance.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If testing codes are included in just-in-time executable code to detect errors, then reliability is improved, but device complexity increases
Solution Approach 1:
The patent extracts testing codes from the main executable code flow and places them in separate, selectively activatable modules. This allows the core code to remain simple while testing functionality is available when needed, resolving the contradiction between reliability improvement and complexity increase.
Solution Approach 2:
The patent implements dynamic activation of testing codes based on runtime conditions. Testing codes are not permanently embedded but are activated only when specific conditions are met, allowing the system to maintain simplicity during normal operation while providing comprehensive error detection when required.
2Reliability
If testing codes are executed during query processing, then error detection capability is improved, but execution speed decreases
Solution Approach 1:
The patent implements periodic or conditional execution of testing codes rather than continuous execution. Testing is performed at specific intervals or under specific conditions, allowing fast execution during normal operations while providing error detection capability when needed, thus resolving the speed-reliability contradiction.
Solution Approach 2:
The patent applies partial action by executing only necessary testing codes based on condition evaluation. Not all testing codes are run for every query - only those relevant to the current execution context are activated, maintaining speed while providing adequate error detection.
3Measurement precision
If multiple testing codes are included to cover various conditions, then measurement precision is improved, but code complexity increases
Solution Approach 1:
The patent applies local quality by making different testing codes available in different contexts or locations within the code structure. Each testing code is placed and activated where it is most relevant, providing precise error detection for specific conditions without requiring all testing codes to be present everywhere, thus managing complexity while maintaining precision.
Data Source
AI summary
A method, a system, and a computer program product for providing one or more checks during execution of queries an application. A query is received for execution by a software application. A just-in-time executable code is generated for execution of the received query. A determination is made that the generated just-in-time executable code is configured to include one or more testing codes for testing the software application. The testing codes are associated with one or more conditions. The generated just-in-time executable code and one or more testing codes are executed. The testing codes are executed upon a determination that one or more conditions are activated.