Catalina Y Wei

US Patent:

20130339964, Dec 19, 2013

Filed:

Jun 15, 2012

Appl. No.:

13/525246

Inventors:

Curt L. COTNER - Gilroy CA, US
Sherry X. GUO - Fremont CA, US
Thomas J. TOOMIRE - Morgan Hill CA, US
John E. VONAU - Brighton CO, US
Fang-Yi WANG - San Jose CA, US
Catalina Y. WEI - San Jose CA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 9/46

US Classification:

718102

Abstract:

The replaying of work across a database servers includes: receiving a global time by each of a plurality of replay dispatchers; calculating, for each given replay dispatcher, a time offset using a local time for the given replay dispatcher and the global time; receiving, for each given replay dispatcher, a replay workload comprising a plurality of replay records and a global replay start time, wherein each of the plurality of replay records comprises an expected wait time; calculating, for each given replay dispatcher, a wait time for each given replay record based on the expected wait time for the given replay record, the global replay start time, and the time offset for the given replay dispatcher; and submitting, for each given replay dispatcher, the replay records to a target database server for processing in an order according to the calculated wait times.

US Patent:

20100293209, Nov 18, 2010

Filed:

May 15, 2009

Appl. No.:

12/467102

Inventors:

William R. Bireley - Morgan Hill CA, US
Dilip K. Biswal - Union City CA, US
Delmar E. Blevins - Los Gatos CA, US
Stephen A. Brodsky - Los Gatos CA, US
Anshul Dawra - San Jose CA, US
Swaminathan Gounder - San Jose CA, US
Paul A. Ostler - Yakima WA, US
Manish Sehgal - San Jose CA, US
Catalina Y. Wei - San Jose CA, US
David J. Wisneski - Morgan Hill CA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES, CORPORATION - Armonk NY

International Classification:

G06F 17/30

US Classification:

707959, 707954

Abstract:

Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.