Database Proxy Connection Management via Rule-Based Routing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database servers face challenges in modifying operations to accommodate changing business needs due to the complexity of maintaining relationships between vast amounts of valuable data, making modifications risky and difficult.
Innovation Solution
A proxy server acts as an intermediary between database clients and servers, applying user-defined rules to requests, translating REST requests into SQL commands, and managing connections to optimize database operations, including failover masking, workload capture, and data masking.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database servers are modified to accommodate changing business needs, then adaptability improves, but reliability deteriorates due to the complexity of maintaining relationships between vast amounts of valuable data
Solution Approach 1:
The patent divides the database system into a client-side component and a server-side component. The client-side component handles business logic and data relationships locally, while the server-side component manages raw data storage. This segmentation allows the client to adapt to changing business needs without modifying the server, thereby maintaining reliability while improving adaptability.
Solution Approach 2:
The patent introduces an intermediary layer (client-side component) between the user applications and the database server. This intermediary translates business needs into database queries and manages data relationships locally, acting as a buffer that protects the server from direct modification while enabling flexible business logic implementation.
2Adaptability or versatility
If database servers are modified to retain additional information or provide additional processing capability, then functionality improves, but device complexity increases due to the difficulty of maintaining relationships between different portions of retained data
Solution Approach 1:
The patent segments the system into a client-side component that handles business logic and data relationship management, and a server-side component that provides raw data storage. This division moves complexity from the server to the client, allowing the server to remain simple while the client handles the complexity of maintaining relationships between different data portions.
Solution Approach 2:
The patent extracts business logic and data relationship management from the database server and places them in the client-side component. This extraction removes complex processing capabilities from the server, reducing its complexity while maintaining the ability to handle additional information and processing requirements through the client component.
3Reliability
If a proxy server is introduced to manage database connections and apply rules, then reliability and security improve, but device complexity increases
Solution Approach 1:
The patent introduces a proxy server as an intermediary between client applications and the database server. The proxy server manages database connections, applies security rules, and handles failover logic centrally. This intermediary approach improves reliability by providing centralized control and security while the modular design keeps the added complexity manageable through clear separation of concerns.
Data Source
AI summary
A proxy server acts as an intermediary between a database client and a database server. The proxy server establishes and maintains a set of logical connections to the database server. The proxy server receives a request from the database client, and generates a set of database commands that, when performed by the database server, are capable of fulfilling the request. The proxy server selects a particular logical connection from the set of logical connections based at least in part on a characteristic of the request, and submits the set of database commands to the database server via the selected particular logical connection. In various examples, the particular logical connection is selected so that various performance, efficiency, and security objectives are achieved.