METHOD FOR TRANSPORTING RELATIONAL DATA

摘要

A method for transporting relational data from one relational database to another such database. The data transported may be a subset of data in the entire database and the relations between the root of this data and other data entities are preserved in a way allowing their reconstruction in the target database. This preservation, itself further directed through configuration, is able to recreate new data identifiers without collision, yet also without requiring maintenance of the original identifiers.

主权项

1. A data transporter computer program comprising a series of instructions stored in a computer-readable memory, instructions defining:
an export interface module arranged to interface with a source client program to enable the source client program to initiate export of a subset of relational data from a source relational database to a target relational database; a source database connection module coupled to the export interface module and arranged to connect to a the source relational database associated with the source client program to access the stored relational data; an export subsystem coupled to the source database connection module and configured to generate a data file representing the data for export; a transport I/O subsystem coupled to the export subsystem and arranged to interface with the source client program to provide the data file to the source client program; an import interface module coupled to the transport I/O subsystem and arranged to interface with a target client program; a target database connection module coupled to the import interface module and arranged to connect to a target relational database associated with the target client program to store relational data based on the data stored in the data file.