Database Query Processing with Client-Side Normalization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database clients' resources are underutilized, leading to increased pressure on database servers due to centralized query processing, which also results in higher network resource consumption and reduced query performance.
Innovation Solution
A method and system that normalize queries and determine access paths on the client-side, allowing for data retrieval from both clients and the database server, thereby utilizing client resources to reduce server load and network requests.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If all query processing is performed on the server-side, then the database server can utilize its great computing/storage/network resources, but the database clients' resources are wasted and pressure on the database server increases
Solution Approach 1:
The patent divides query processing into multiple segments: normalization and access path determination are performed on the client-side, while data retrieval is performed on the server-side. This segmentation allows clients to utilize their own resources for preliminary processing, reducing the burden on the server and improving overall system efficiency.
Solution Approach 2:
The patent introduces a new dimension of client-side processing capability. By enabling clients to perform normalization and access path determination locally, the system transitions from a single-dimension server-centric model to a multi-dimensional distributed processing model, effectively utilizing resources across different dimensions of the system.
2Reliability
If all query processing is performed on the server-side, then centralized control is maintained, but network resource consumption increases and query performance decreases
Solution Approach 1:
The patent extracts certain processing functions (normalization and access path determination) from the server and places them on the client-side. This extraction reduces the amount of data and processing that must occur over the network, thereby reducing network resource consumption while maintaining the server's role in data retrieval and centralized control.
3Productivity
If query processing is distributed to clients, then client resources are utilized and server pressure is reduced, but query normalization and access path determination become more complex
Solution Approach 1:
The patent enables clients to serve themselves by performing normalization and access path determination locally without requiring complex server-side coordination for these functions. This self-service approach simplifies the overall system architecture by clearly separating client responsibilities from server responsibilities, reducing the complexity of inter-component communication.
Data Source
AI summary
Embodiments of the present disclosure describe an approach for database query processing with database clients. According to the approach, a first set of queries are obtained from a plurality of clients in communication with a database server. A second set of queries are generated by normalizing the first set of queries. A set of access paths corresponding to the second set of queries are determined for retrieving data from at least one of the plurality of clients and the database server. Data is retrieved from at least one of the plurality of clients and the database server based on the set of access paths.