Dynamic Connection Pool Management for Cloud Database Access

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing systems face challenges in managing connection pools for cloud-based applications accessing databases, particularly in scenarios where applications have different database requirements or usage patterns, leading to resource contention and performance optimization issues.

Innovation Solution

A computer-implemented method and system for managing a connection pool that establishes multiple connections to databases, allocates connection requests based on connection pool parameters, monitors usage, and updates these parameters to optimize resource allocation and performance.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If a connection proxy is shared by multiple applications, then resource utilization is improved, but connection conflicts and reliability deteriorate

Engineering Contradiction:

Improveresource utilizationVSAvoidconnection conflicts

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

The system segments the connection pool by creating separate connection pools for different applications or application types. Each connection pool is isolated and dedicated to specific applications, eliminating connection conflicts while maintaining resource utilization benefits through centralized management of multiple segmented pools.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The system applies different connection pool configurations and management strategies to different applications based on their specific requirements. Each application or application group receives tailored connection pool parameters (size, timeout, validation rules) optimized for its workload characteristics, preventing conflicts while maximizing resource utilization.

Inventive Principle:

Principle #3Local quality

2Reliability

If separate connection proxies are maintained for applications with different requirements, then reliability is improved, but device complexity increases

Engineering Contradiction:

Improveperformance optimizationVSAvoidconnection proxy management

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The system implements a universal connection pool management platform that can serve multiple applications with different requirements through a single unified system. This platform provides multi-functionality by supporting dynamic configuration, monitoring, and adjustment of connection pools for various applications, maintaining reliability without increasing complexity through standardization.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system dynamically adjusts connection pool parameters based on real-time monitoring of application performance and resource utilization. Connection pool size, timeout values, and other parameters are automatically tuned according to changing workload conditions, maintaining optimal performance without manual intervention or complex static configurations.

Inventive Principle:

Principle #15Dynamics

3Device complexity

If connection pool parameters are statically configured, then device complexity is reduced, but adaptability deteriorates

Engineering Contradiction:

Improveparameter managementVSAvoidusage pattern adaptation

Core Design Contradiction:

Device complexityVSAdaptability or versatility

Solution Approach 1:

The system implements continuous monitoring of connection pool usage patterns, performance metrics, and resource utilization. This feedback is used to automatically adjust connection pool parameters such as pool size, timeout values, and validation rules, enabling the system to adapt to changing workload patterns without manual reconfiguration or increased complexity.

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The connection pool management system performs self-configuration and self-optimization by automatically analyzing usage patterns and adjusting parameters without external intervention. The system monitors its own performance, identifies optimization opportunities, and implements parameter changes autonomously, maintaining simplicity while achieving high adaptability.

Inventive Principle:

Principle #25Self-service

Data Source

PatentUS12335163B2Managing a connection pool for cloud-based applications accessing databases

Publication Date: 2025.06.17 INTERNATIONAL BUSINESS MACHINE CORPORATION

AI summary

Methods for managing a connection pool for cloud-based applications accessing databases are provided. Aspects include establishing a plurality of connections to one or more databases, receiving connection requests from a plurality of cloud-based applications to access the one or more databases, and allocating the connection requests to among the plurality of connections, where the allocation is determined based at least in part on one or more connection pool parameters. Aspects also include monitoring a usage of the plurality of connections by the plurality of applications and updating the one or more connection pool parameters based on an analysis of the usage of the plurality of connections by the plurality of applications.