| US 7,418,441 B2 | ||
| Data loading from a remote data source record by record | ||
| Elizabeth Belva Hamel, Morgan Hill, Calif. (US); Michael T. Ho, Willowdale (Canada); James C. Kleewein, San Jose, Calif. (US); Mark Donald Leitch, Ajax (Canada); Sam Sampson Lightstone, Toronto (Canada); John Ai McPherson, Jr., San Jose, Calif. (US); and James Alan Ruddy, Gilroy, Calif. (US) | ||
| Assigned to International Business Machines Corporation, Armonk, N.Y. (US) | ||
| Filed on Jul. 24, 2001, as Appl. No. 9/912,586. | ||
| Claims priority of provisional application 60/272680, filed on Feb. 28, 2001. | ||
| Prior Publication US 2002/0161748 A1, Oct. 31, 2002 | ||
| Int. Cl. G06F 17/30 (2006.01) | ||
| U.S. Cl. 707—3 [707/4; 707/5; 707/10; 707/100; 709/200; 709/201; 709/203] | 24 Claims |
| 1. A method for loading data from a remote data source record by record, in a computer system network connecting a source
site and a target site via a database connection communication line, the method comprising the following steps:
(a) coupling the source site to at least one data source and to a software server having multi-database access to DBMSs;
(b) at the target site requesting data loading from the source site via a block of Structured Query Language (SQL) statements;
and
(c) transporting data record by record via the database connection communication line according to a multi-database access
communication protocol, wherein the target site loading records concurrently with the unloading of records in the source site.
|