Server Query Processing Segmentation and Intermediary Response
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Server systems face performance degradation when processing resource-intensive queries due to the lack of necessary indexes, leading to inefficient resource utilization and potential overload, as they either return exceptions or burden themselves trying to fully process unsupported queries.
Innovation Solution
Implement a method where the server system processes only the supported query-processing steps, generates intermediate results, and returns these along with a representation of unsupported steps to the requestor, allowing the requestor to complete the query using their resources, thereby preventing server overload.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the server system attempts to fully process resource-intensive queries that lack necessary indexes, then the query results can be obtained, but the server system performance degrades and resources are monopolized
Solution Approach 1:
The patent segments the query processing into two distinct parts: supported query-processing steps that can be executed by the server system using available indexes, and unsupported query-processing steps that require additional indexes or resources. This segmentation allows the server to process the supported portion efficiently while returning intermediate results and metadata about the unsupported steps to the requestor, who can then complete the query locally without overwhelming the server.
2Productivity
If the server system returns exceptions for queries not fully supported, then server resources are protected, but the requestor cannot obtain query results without performing all processing locally
Solution Approach 1:
The patent introduces an intermediary response structure that contains both intermediate results from the supported query-processing steps and metadata representing the unsupported steps. This intermediary response acts as a bridge between the server's capabilities and the requestor's needs, allowing the requestor to receive partial results that can be further processed locally without requiring the server to either fully support the query or return a hard exception.
3Productivity
If the server system processes only supported query-processing steps, then server overload is prevented, but the query cannot be fully completed without additional processing at the requestor
Solution Approach 1:
The patent implements a feedback mechanism where the server system analyzes the incoming query, identifies which steps are supported based on available indexes, executes those steps to produce intermediate results, and returns both the results and metadata about the unsupported steps to the requestor. This feedback loop enables the requestor to understand what processing was done and what additional steps are needed, allowing complete query execution distributed between server and requestor.
Data Source
AI summary
A server system having one or more processors and memory receives a first query from a requestor and obtains a first query-processing plan including a first plurality of query-processing steps for processing the query. Supported query-processing steps comprise query-processing steps in a set of supported query-processing steps, and unsupported query-processing steps comprise query-processing steps not in the set of supported query-processing steps. In accordance with a determination that the first plurality of query-processing steps includes one or more of the supported query-processing steps and one or more unsupported query-processing steps including a respective unsupported query-processing step, the server system performs the one or more supported query-processing steps to produce intermediate results and generates a first response to the first query that includes the intermediate results and a representation of the respective unsupported query-processing step. The server system transmits the first response to the requestor.