Data loading from a remote data source record by record

Details Data loading from a remote data source record by record Data loading from a remote data source record by record

2001-07-24

2008-08-26

Pham, Khanh B (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C709S200000, C709S201000, C709S203000

Reexamination Certificate

active

07418441

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.

REFERENCES:
patent: 5410693 (1995-04-01), Yu et al.
patent: 5511186 (1996-04-01), Carhart et al.
patent: 5884327 (1999-03-01), Cotner et al.
patent: 5987465 (1999-11-01), Kleewein et al.
patent: 5987472 (1999-11-01), Serafin
patent: 6006229 (1999-12-01), Schmidt et al.
patent: 6044216 (2000-03-01), Bhargava et al.
patent: 6151602 (2000-11-01), Hejlsberg et al.
patent: 2002/0038313 (2002-03-01), Klein et al.
patent: 2003/0037048 (2003-02-01), Kabra et al.
patent: 0589219 (1994-03-01), None
patent: 0795834 (1997-09-01), None
IBM, “Datajoiner: A multidatabase Server Version 1”, White paper Data Management Solutions, IBM Corporation 1995, 28 pages.
Vassilakis et al., “Implementing Embedded Valid Time Query Languages”, Proceedings of the DEXA '98 Conference, 1998, pp. 561-572.
Gottenukkala et al., “Interfacing parallel Applications and Parallel Databases”, IBM T. J. Watson Research Center, 1997, pp. 355-364.
Mullins C., “DB2 Developer's Guide, Fourth Edition”, Sams Publishing, May 11, 2000, Chapter 9.
Michael Gertz,Oracle/SQL Tutorial, http//www.db.cs.ucdavis.edu, Version 1.01, Jan. 2000.
Chamberlin et al,Complete guide to DB2 Universal Database, Complete Guide to DB2 Universal Database, 1998, pp. 589-599.
Gupta P et al,DataJoiner; A Practical Approach To Multi-Database Access, Parallel and Distributed Information Systems, 1994. Proceedings of the 3rdIntl Conf on Austin, TX, USA Sep. 28-30, 1994, Los Alamitos, CA, Sep. 8, 1994, p. 264.
Chamberlin et al.,A Complete Guide to DB2 Universal Database, Complete Guide to DB2 Universal Database, 1998, pp. 162-174, 643-658.
Record Blocking in SQLJRA Remote Protocol, Dec. 1992, IBM Technical Disclosure Bulletin, pp. 290-292.
Distributed Relational Database Architecture Reference, IBM Corp., Second Edition, Mar. 1993, IBM Ref. No. SC26-4651-01.

Affiliated with

Also associated with

Rating

Data loading from a remote data source record by record does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Data loading from a remote data source record by record, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data loading from a remote data source record by record will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3996132