18045627. CONNECTION POOL MANAGEMENT WITH STRATEGIC CONNECTION ALLOCATION TO REDUCE MEMORY CONSUMPTION OF STATEMENT POOLS simplified abstract (International Business Machines Corporation)

CONNECTION POOL MANAGEMENT WITH STRATEGIC CONNECTION ALLOCATION TO REDUCE MEMORY CONSUMPTION OF STATEMENT POOLS

Organization Name

International Business Machines Corporation

Inventor(s)

Nathan Jon Rauh of Rochester MN (US)

Alex Seitzinger Motley of Rochester MN (US)

Mark Swatosh of ROCHESTER MN (US)

James Stephens of Palisade MN (US)

CONNECTION POOL MANAGEMENT WITH STRATEGIC CONNECTION ALLOCATION TO REDUCE MEMORY CONSUMPTION OF STATEMENT POOLS - A simplified explanation of the abstract

This abstract first appeared for US patent application 18045627 titled 'CONNECTION POOL MANAGEMENT WITH STRATEGIC CONNECTION ALLOCATION TO REDUCE MEMORY CONSUMPTION OF STATEMENT POOLS

Simplified Explanation

The computer implemented method described in the abstract manages connections in a connection pool by creating a modified call stack for a connection request, identifying potential connections from the connection pool, determining match scores for the potential connections, and selecting a connection based on the highest match score.

• The method involves creating a modified call stack for a connection request, which includes elements calling prepared statements from the application logic.
• A group of potential connections is identified from the connection pool that match the connection request, and each potential connection is associated with an associated modified call stack.
• Weighted match scores are calculated for the associated modified call stacks by comparing them with the modified call stack of the connection request.
• The connection with the highest weighted match score is selected from the group of potential connections.

Potential Applications

This technology can be applied in database management systems, web servers, and other systems that require efficient connection management.

Problems Solved

This technology solves the problem of efficiently managing connections in a connection pool and selecting the most suitable connection for a given request.

Benefits

The benefits of this technology include improved performance, optimized resource utilization, and enhanced scalability in systems with high connection requirements.

Potential Commercial Applications

Potential commercial applications of this technology include cloud services, e-commerce platforms, and enterprise software solutions.

Possible Prior Art

One possible prior art for this technology could be connection pooling techniques used in database management systems and web servers.

How does this technology handle connection failures in the pool?

The abstract does not provide information on how the method deals with connection failures in the pool. This aspect is crucial for ensuring the reliability of the connection management system.

What is the impact of the size of the connection pool on the performance of the method?

The abstract does not address how the size of the connection pool affects the performance of the method. Understanding this relationship is essential for optimizing the system for different scalability requirements.

Original Abstract Submitted

A computer implemented method manages connections in a connection pool. A computer system creates a modified call stack for a connection request in response to receiving the connection request. The modified call stack comprises elements that call prepared statements that are part of an application logic for the connection request. The computer system identifies a group of potential connections from the connections in the connection pool matching the connection request. The group of potential connections is associated with a group of associated modified call stacks that call the prepared statements. The computer system determines a group of weighted match scores for the group of associated modified call stacks from a comparison of the modified call stack with the group of associated modified call stacks. The computer system selects a connection from the group of potential connections based on a highest weighted match score in the group of weighted match scores.