Data loading from remote data source

本发明提出了一种在通过数据库连接通信线路连接源端和目标端的计算机系统网络中逐个记录地从远程数据源加载数据的方法、设备和产品。源端拥有至少一个数据源和一个具有对库管理系统(DBMS)的多数据库访问的分布式关系数据库体系(DRDA)软件服务器。目标端通过一组结构化查询语言(SQL)语句请求从源端DRDA加载数据。根据DRDA通信协议，数据通过数据库连接通信线路逐个记录地输送，其中，在源端卸载记录的同时目标端加载记录。数据加载也可以以流水线的方式实现，以多个并行的流将数据记录加载到多个分区内，所述多个并行流被多个数据源分区指针所指向。 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.