The present invention provides data replication and transformation. The
invention system creates a replica version of a relational database based
upon information obtained from a source database. The system populates
the replica database with all or a portion of the data from the source
database and transforms the data during the extraction process using a
standard set of algorithms. This keeps any proprietary information in the
source database from reaching the replica database while still retaining
that source database's referential integrity. The system supports the
process of reloading the replica databases interactively or on a
scheduled basis running as a batch process. Included is a global network
component that coordinates the reload among the various groups of users
accessing the replica database and supports the addition of new or
enhanced transform algorithms through the present invention web portal,
as they become available.