Other
Replication Products
Though data sharing and data replication
are now implemented by Oracle Streams through the use of redo
log files for capturing transaction changes, the concept of
using the transaction log to construct the database changes to
propagate to the destination database is not new. Competitive
RDBMS products and other third party data sharing products have
implemented such methodology in the past. Sybase is well known
for a robust replication methodology and has implemented a
transaction log based data replication method.
Quest software’s SharePlex product
implements a redo-log capture based data replication methodology
for Oracle databases. GoldenGate software also provides a data
replication product. These two products will be introduced, in
brief.
GoldenGate Data Synchronization Platform
GoldenGate Software provides an innovative
product that can be used to support data replication in the
Oracle Database environment. GoldenGate’s solution reads the
Oracle redo log files and captures the database changes for
propagation and application to the destination. However, the
extract and apply processes are not part of the database. They
are an operating system level process.
The data synchronization solution consists
of three modules: Capture; Delivery; and Manager. The Capture
also known as the extract process and the Delivery process do
the bulk of the data replication and data sharing functions.
These two processes are de-coupled and run independently. The
Manager module provides an interface to configure and manage the
replication process.
