Deferred Database Connection Configuration for Latency Reduction

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

In Web-based applications with multi-tiered architecture, frequent changes to database connection parameters incur noticeable costs in terms of system latency and resource usage due to immediate execution and synchronization requirements.

Innovation Solution

Implementing a deferred database connection configuration system where a connection handling infrastructure assigns a database connection handle to an application, deferring access to selected connection parameters until necessary, maintaining both actual and desired state information to optimize parameter synchronization and reduce latency.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If connection parameters are changed immediately with synchronous execution, then the application can access updated parameter values right away, but system latency increases and database resources are consumed unnecessarily

Engineering Contradiction:

Improveparameter consistencyVSAvoidsystem latency

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary actions by queuing parameter change requests and executing them at predetermined intervals or triggers rather than immediately. The connection handling infrastructure batches parameter changes and applies them in advance of when they are actually needed, reducing unnecessary synchronous database interactions while maintaining parameter consistency.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system dynamically adjusts the timing of parameter synchronization based on transaction states and resource allocation. Parameter changes are deferred until appropriate moments (e.g., transaction boundaries, resource allocation events), making the synchronization process adaptive rather than rigidly synchronous, thus reducing latency while preserving data integrity.

Inventive Principle:

Principle #15Dynamics

2Reliability

If connection parameters are synchronized frequently to maintain consistency, then parameter accuracy is maintained, but database resource usage increases

Engineering Contradiction:

Improveparameter consistencyVSAvoiddatabase resource usage

Core Design Contradiction:

ReliabilityVSUse of energy by moving object

Solution Approach 1:

The system implements periodic action by synchronizing connection parameters at predetermined intervals or triggers (e.g., transaction boundaries, connection pool events) rather than continuously or immediately upon each change request. This periodic synchronization maintains parameter consistency while significantly reducing database resource usage by eliminating unnecessary frequent interactions.

Inventive Principle:

Principle #19Periodic action

Solution Approach 2:

The connection handling infrastructure provides self-service by automatically managing parameter synchronization timing and batching changes without requiring constant application intervention. The system monitors transaction states and resource allocation events, then autonomously determines when to apply parameter changes, reducing overall database resource consumption while maintaining consistency.

Inventive Principle:

Principle #25Self-service

3Loss of information

If all connection parameters are accessed and synchronized immediately, then complete parameter information is available, but system performance deteriorates

Engineering Contradiction:

Improveparameter information completenessVSAvoidsystem performance

Core Design Contradiction:

Loss of informationVSProductivity

Solution Approach 1:

The system extracts only the essential connection parameters that need immediate synchronization from the complete parameter set. By identifying and isolating critical parameters (such as those affecting transaction integrity or resource allocation) and deferring synchronization of less critical parameters, the system maintains necessary information completeness while improving overall performance by reducing unnecessary access operations.

Inventive Principle:

Principle #2Taking out (Extraction)

Data Source

PatentUS7571164B2System and method for deferred database connection configuration

Publication Date: 2009.08.04 SAP SE

AI summary

A system and method for deferred database connection configuration. A database connection handle associated with a physical database connection is assigned to an application. An indication is received from the application to access a specified connection parameter of the physical database connection. A connection handling infrastructure determines whether the specified connection parameter is one of a selected subset of connection parameters. Access to the specified connection parameter is deferred, if the specified connection parameter is one of the selected subset of connection parameters.