Richard C Noel

US Patent:

20020083071, Jun 27, 2002

Filed:

Apr 26, 1999

Appl. No.:

09/299282

Inventors:

ANDREW WALTER CRAPO - SCOTIA NY, US
RICHARD CHRISTOPHER NOEL - PISCATAWAY NJ, US
JAMES LEIGH DOUGLASS - SARATOGA SPRINGS NY, US

International Classification:

G06F017/00

US Classification:

707/102000

Abstract:

The present invention provides a method for transferring data between source and target databases in a computer system that can adapt to changes in the schema of the source database and/or target database. This adaptability is achieved by determining the intersection of the source and target database schemas prior to a transfer of data between the databases. Since the intersection is determined prior to a transfer, changes in the schema of the source and/or target database are automatically accommodated. In one embodiment, the method includes the ability to specify the desired frequency with which data is to be transferred between source and target databases. The method, which is implemented as a computer program, is also capable of operating in a computer system in which other tasks are competing for processor time. In this embodiment, the method automatically adjusts the priority of the task of transferring data between source and target databases relative to other tasks that are competing for processor time. This adjustment is based upon information relating to the desired frequency for transferring data between source and target databases.