INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY
International Classification:
G06F 15/173
US Classification:
709225
Abstract:
A system and method manages resources within a process by identifying a first resource threshold associated with available resources. The method receives a resource request from a resource requesting participant requiring the available resources. The method determines that an estimated resource usage, associated with the resource request, approaches the first resource threshold. The method negotiates with at least one resource consuming participant to voluntarily release resources until the estimated resource usage approaches a second resource threshold associated with the available resources within the process.
A computer-implemented method includes detecting a source update applied to a source table, where the source table includes a plurality of columns, and where the source update modifies a first subset of columns of the plurality of columns. A second subset of columns of the plurality of columns is determined, by a computer processor. The second subset of columns has more columns than the first subset of columns and fewer columns than the plurality of columns. Determining the second subset of columns includes determining which of the plurality of columns were updated most recently. The second subset of columns is included in a set clause of an update statement for updating a target table, where the target table is or includes a replica of the source table. The update statement is applied to the target table to achieve at least a minimum batching percentage within a plurality of update statements.
A computer-implemented method includes detecting a source update applied to a source table, where the source table includes a plurality of columns, and where the source update modifies a first subset of columns of the plurality of columns. A second subset of columns of the plurality of columns is determined, by a computer processor. The second subset of columns has more columns than the first subset of columns and fewer columns than the plurality of columns. Determining the second subset of columns includes determining which of the plurality of columns were updated most recently. The second subset of columns is included in a set clause of an update statement for updating a target table, where the target table is or includes a replica of the source table. The update statement is applied to the target table to achieve at least a minimum batching percentage within a plurality of update statements.
Idling Individually Specified Objects During Data Replication
- Armonk NY, US Laura A. Cuell - Coquitlam, CA Phillip R. Koza - San Jose CA, US Victor L. Szabo - Stouffville, CA
International Classification:
G06F 17/30
Abstract:
According to one embodiment of the present invention, during database replication from a source database to a target database, operations applied to the source database are transferred as target operations and applied to the target database. A request from a requestor to idle a specified database object is received during the database replication. In response to receiving the request, transference of the target operations for the specified database object from the source database to the target database is terminated and target operations for the specified database object on the target database are monitored. In response to no target operations being applied to the specified database object on the target database, replication of the specified database object is suspended and the requestor is notified when the idling of the specified database object has completed.
Idling Individually Specified Objects During Data Replication
- Armonk NY, US Laura A. Cuell - Coquitlam, CA Phillip R. Koza - San Jose CA, US Victor L. Szabo - Stouffville, CA
International Classification:
G06F 17/30
Abstract:
According to one embodiment of the present invention, during database replication from a source database to a target database, operations applied to the source database are transferred as target operations and applied to the target database. A request from a requestor to idle a specified database object is received during the database replication. In response to receiving the request, transference of the target operations for the specified database object from the source database to the target database is terminated and target operations for the specified database object on the target database are monitored. In response to no target operations being applied to the specified database object on the target database, replication of the specified database object is suspended and the requestor is notified when the idling of the specified database object has completed.
A system and method manages resources within a process by identifying a first resource threshold associated with available resources. The method receives a resource request from a resource requesting participant requiring the available resources. The method determines that an estimated resource usage, associated with the resource request, approaches the first resource threshold. The method negotiates with at least one resource consuming participant to voluntarily release resources until the estimated resource usage approaches a second resource threshold associated with the available resources within the process.
Join Now & View the Full Tara Koza Profile. Register for FREE at MyLife to find Tara ... Tina Koza Largo, FL 49 Brian Koza Largo, FL 19 Phillip Koza Davie, FL ...