Database Replication via Parallel JDBC Connection Pooling

The patent segments the single database connection into multiple parallel connections (connection pool). Each connection can execute SQL statements independently, allowing parallel processing of replication operations while maintaining data consistency through proper connection management and transaction control.

The patent transitions from a single-dimensional sequential execution model to a multi-dimensional parallel execution model by introducing multiple database connections. This allows replication operations to be distributed across multiple connections, increasing throughput while maintaining correctness through coordination mechanisms.

The patent divides the single connection resource into multiple connections, creating a connection pool that can be distributed across multiple database processes. This enables parallel processing and exploitation of multi-processing capabilities while managing complexity through connection pooling algorithms.

The patent changes the connection parameter from a single connection to multiple connections, fundamentally altering the system's processing capacity. This parameter change enables the system to leverage multi-processing capabilities and significantly increase replication processing speed.

The patent segments large batches of SQL statements across multiple database connections, allowing parallel processing of statement subsets. This maintains batch processing efficiency while distributing the load, preventing any single connection from becoming a bottleneck and reducing failure risk during high data change rates.

The patent uses multiple connections to process batches in parallel, effectively performing more processing actions simultaneously than a single connection could handle. This partial distribution of batch processing across connections increases overall throughput and reliability without sacrificing batch efficiency.