Database Execution Templates for Selective Query Instance Processing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database query systems suffer from low query efficiency and resource utilization due to dynamic compiling of all standard database instances, leading to increased overheads and inefficient resource usage.
Innovation Solution
A method is introduced to form database execution templates based on computational elements of sample query statements, perform screening to obtain target templates, and generate customized database instances to respond to query statements, reducing the number of instances executed.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If all standard database instances are executed to respond to a query statement, then query completeness is ensured, but query efficiency deteriorates due to the large number of instances that need to be executed
Solution Approach 1:
The patent segments the database instances into different categories (first database instances and second database instances) based on their characteristics and query types. This segmentation allows the system to selectively execute only the necessary instances rather than all instances, thereby improving query efficiency while maintaining query completeness.
Solution Approach 2:
The patent applies partial action by executing only a subset of database instances (the first database instances) that are most likely to contain the required data, rather than executing all standard database instances. This partial execution approach significantly reduces the number of instances that need to be processed while still ensuring that the query can be completed successfully.
2Adaptability or versatility
If dynamic compiling is performed during execution of a data set instance, then query flexibility is improved, but query efficiency deteriorates due to the overhead of determining and compiling during execution
Solution Approach 1:
The patent performs preliminary compilation of database instances before execution, creating a compiled form that can be directly executed without additional compilation overhead during query processing. This preliminary action eliminates the need for dynamic compiling during execution, thereby improving query efficiency while maintaining the flexibility to handle different query types through the pre-compiled instances.
3Reliability
If all standard database instances are executed, then data completeness is ensured, but resource utilization deteriorates due to redundant execution of instances with low utilization
Solution Approach 1:
The patent extracts and identifies the subset of database instances (first database instances) that are most relevant to the query based on data distribution characteristics and query patterns. By taking out only the necessary instances from the complete set of standard database instances, the system ensures data completeness is maintained while avoiding the resource waste of executing redundant instances with low utilization.
Data Source
AI summary
This application provides a database instance processing method and apparatus, an electronic device, a computer-readable storage medium, and a computer program product. The method includes obtaining a plurality of sample query statements for a database, and obtaining at least one computational element of the database corresponding to each sample query statement; forming a database execution template of the sample query statement for each sample query statement by using the at least one computational element of the database corresponding to the sample query statement; performing screening processing on a plurality of database execution templates corresponding to the plurality of sample query statements, to obtain a target database execution template; and generating a database instance corresponding to each target database execution template, a database instance being configured to respond to a target query statement corresponding to the database instance when being executed.