Connection Pool Session Binding for Backend Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Multitier data processing architectures face inefficiencies due to high connection creation times between client systems and backend processing systems, leading to complications in user authentication, access security, and auditing, especially with traditional homogeneous connection pools that lack user-specific information.
Innovation Solution
Implementing a connection pool system that binds and unbinds connections with user-specific sessions, using a generic user session cache and application user session cache to manage connections, allowing the backend processing system to track user activities and provide secure access while reducing unnecessary connection creation and teardown.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If a homogeneous connection pool is used to reduce connection creation time, then connection efficiency is improved, but user authentication and security tracking become complicated
Solution Approach 1:
The patent segments the connection pool into multiple sub-pools, each associated with a specific user. This allows the system to maintain connection efficiency while tracking user identity, as each sub-pool is isolated and can be managed independently with user-specific metadata.
Solution Approach 2:
The patent implements a nested structure where user-specific metadata and session information are embedded within the connection pool framework. The connection pool contains user-specific sub-pools, which in turn contain user-specific sessions, creating a nested hierarchy that preserves user identity information while maintaining connection reuse benefits.
2Reliability
If pool-of-pools or heterogeneous connection pools are used to support user authentication, then security and auditing functions are improved, but connection creation complexity and resource consumption increase
Solution Approach 1:
The patent creates a universal connection pool structure that can serve multiple users through a single homogeneous pool while maintaining user-specific sessions. This multi-functional approach eliminates the need for separate pools per user, reducing structural complexity while still supporting security and auditing through user-specific session metadata.
3Adaptability or versatility
If multiple connections are created for each user to facilitate concurrent access, then user access capability is improved, but connection management overhead increases
Solution Approach 1:
The patent implements dynamic user-specific session metadata that can be created, updated, and removed as users connect and disconnect. This dynamic approach allows the system to adapt to concurrent user access needs without maintaining static multiple connections, reducing management overhead while preserving adaptability.
Data Source
AI summary
Example systems and methods of providing a connection with a backend processing system are presented. In one example, a request for a connection between the backend processing system and a user of an application is received. One of a plurality of connections with the backend processing system is selected. Each of the plurality of connections is bound with a corresponding generic user session in the backend processing system. In response to the request, the selected connection is unbound from a generic user session and bound with a user session corresponding to the user of the application. Access to the selected connection is provided to the user of the application.