International business machines corporation (20240118808). CONNECTION POOL MANAGEMENT WITH STRATEGIC CONNECTION ALLOCATION TO REDUCE MEMORY CONSUMPTION OF STATEMENT POOLS simplified abstract

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 20240118808 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 modified call stacks, and selecting a connection based on the highest match score.

• The method involves creating a modified call stack for a connection request.
• The modified call stack includes elements that call prepared statements from the application logic.
• Potential connections matching the connection request are identified from the connection pool.
• Match scores are calculated for the group of associated modified call stacks.
• A connection is selected based on the highest match score in the group of weighted match scores.

Potential Applications

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

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

One potential commercial application of this technology could be in cloud computing platforms where efficient connection management is crucial for performance and cost-effectiveness.

Possible Prior Art

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

How does this technology handle connection failures and retries?

The abstract does not provide information on how the method deals with connection failures and retries. This aspect is crucial for ensuring robustness and reliability in connection management systems.

What impact does this technology have on system resource usage?

The abstract does not mention the impact of this technology on system resource usage. Understanding how this method affects resource consumption is essential for evaluating its overall efficiency and practicality.

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.