公开(公告)号：CA2441960C

公开(公告)日：2010-11-09

申请号：CA2441960

申请日：2002-02-25

Applicant: IBM

Inventor： HAMEL ELIZABETH BELVA ,  HO MICHAEL T ,  KLEEWEIN JAMES C ,  LEITCH MARK DONALD ,  LIGHTSTONE SAM SAMPSON ,  MCPHERSON JOHN AI ,  RUDDY JAMES ALAN

IPC: G06F17/30 ,  G06F12/00 ,  G06F13/00

Abstract: A method, apparatus and article of manufacture is provided 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 source site has at least one data source and a Distributed Relational Database Architecture (DRDA) software server having multi-database access to DBMSs. The target site requests data loading from the source site DRDA via a block of Structured Query Language (SQL) statements. Data are transported record by record via the database connection communication line according to the DRDA communication protocol, wherein the target site loads records concurrently with the unloading of records in the source site. The data loading may also be performed in a pipeline manner, loading data records in multiple partitions with a plurality of parallel streams, pointed to by a plurality of data source partition cursors.

公开(公告)号：CA2441960A1

公开(公告)日：2002-10-24

申请号：CA2441960

申请日：2002-02-25

Applicant: IBM

Inventor： KLEEWEIN JAMES C ,  MCPHERSON JOHN AI ,  HO MICHAEL T ,  LIGHTSTONE SAM SAMPSON ,  LEITCH MARK DONALD ,  HAMEL ELIZABETH BELVA ,  RUDDY JAMES ALAN

IPC: G06F12/00 ,  G06F13/00 ,  G06F17/30

Abstract: A method, apparatus and article of manufacture is provided 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 source site has at least one data source and a Distributed Relational Database Architecture (DRDA) software server having multi-database access to DBMSs. The target site requests data loading from t he source site DRDA via a block of Structured Query Language (SQL) statements. Data are transported record by record via the database connection communication line according to the DRDA communication protocol, wherein the target site loads records concurrently with the unloading of records in the source site. The data loading may also be performed in a pipeline manner, loading data records in multiple partitions with a plurality of parallel streams, pointed to by a plurality of data source partition cursors.