International Business Machines Corporation

Venkat R Arra

Paul Michael Cadarette

Ritesh Kumar Gupta

Nirmal Kumar

Rashmi Bharadwaj, V

A method, system, and computer program product to analyze data patterns in source workloads and predict the optimal parallel apply algorithms, where the method may include receiving source workload data and replication environment data, where the source workload data includes at least a stream of changes to a target DBMS. The method may also include analyzing characteristics of the source workload data and the replication environment data. The method may also include inputting, as input variables, the characteristics of the source workload data and the replication environment data into a machine learning algorithm. The method may also include obtaining, from the machine learning algorithm, an optimal parallel apply algorithm from a plurality of parallel apply algorithms. The method may also include applying the optimal parallel apply algorithm to the target database management system.

Dynamically predict optimal parallel apply algorithms

Transaction change data replication includes identifying changes being made to a source database as part of an ongoing transaction at a source. The identifying is performed as the changes are made to the source database and as the transaction remains ongoing prior to commit or rollback thereof at the source. The source and a target are in a replication relationship in which data of the source database at the source is replicated to destinations in a target database at the target. The indications of the changes being made to the source are forwarded, to the target, as the transaction remains ongoing prior to commit or rollback thereof, and based on ending the transaction at the source, an indication of the transaction end is sent to the target.

Transaction change data forwarding

A computer detects initialization of a first messaging session. The computer receives one or more message commands relating to one or more messages. The computer monitors message progress of the first messaging session. The computer detects errors in the message progress. The computer starts one or more additional messaging session(s). The computer monitors message progress of the first messaging session and the one or more additional messaging session(s). The computer detects contraction of messaging sessions is appropriate. The computer closes one or more messaging sessions.

Dynamic communication session management

In dynamic multi-session management, a communication layer monitors network indicators during sending of application messages over a session established between sender and receiver nodes. Based on the network indicators, the communication layer determines that the session has insufficient bandwidth. In response, at least one session is added between sender and receiver nodes, where a plurality of parallel sessions is established between sender and receiver nodes. The application messages are sent over the plurality of sessions. The communication layer continues to monitor the network indicators, and when the plurality of sessions is determined to have insufficient bandwidth, adds at least one more session between sender and receiver nodes. The communication layer further determines, based on the network indicators, whether the plurality of sessions have excess bandwidth If so, one or more sessions are removed. The communication layer may further provide ordering mechanisms to sequence messages sent over the plurality of sessions.

Growing community of inventors

Bengaluru, India

Venkat R Arra