|
Going Beyond Disaster Recovery for Critical Transactional Data
A common question is how GoldenGate's Transactional Data Management software differs from and/or complements replication solutions. GoldenGate TDM utilizes a Change Data Capture (CDC) technology that directly captures data from the source database's transaction logs with very low impact, then delivers that data in real time to target systems - while maintaining the ACID (Atomicity, Consistency, Isolation, Durability) properties of the transactional data. This can be done across heterogeneous and long-distance environments.
What does that mean for the solutions we can deliver?
While GoldenGate TDM can provide a Disaster Recovery and data backup solution, it is optimized to enable complete High Availability solutions that eliminate unplanned AND planned outages (such as application, database, and platform migrations and upgrades) as well as address scalability-related performance problems for production systems.
In addition, the TDM technology enables real-time data integration between disparate source systems and allows users to access to real-time information from your mission-critical systems. Thus, the TDM technology not only enables continuous operations for mission-critical systems, it also brings real-time business intelligence to your enterprise.
Below is a high level comparison of TDM technology with Physical/Block-Level Replication solutions:
Transactional Data Management |
Physical/Block-Level Data Replication |
1. Handles all types of availability interruptions, including logical data corruptions, unplanned outages, planned outages (e.g. migrations), and scalability-related performance issues. |
1. Supports only disaster recovery, i.e. data-block corruption, disk failure, unplanned outages because of data corruption. |
2. Heterogeneous databases and platforms. |
2. Like-to-like databases and platforms. |
3. Guarantees transaction integrity at the database operation level; ensuring database consistency at all times. |
3. No transaction integrity; no guarantee that database will be available or consistent. |
4. Both source and target systems are available. |
4. Target system unavailable for data processing. |
5. Data corruption is isolated at source. |
5. Data corruption is propagated to target. |
6. Selective and dynamic rollback with advanced point-in-time recovery. |
6. No rollback or point-in-time recovery. |
7. Many-to-many topology with selective and optimized data movement. |
7. One-to-one topology with all-or-nothing data replication. |
8. No distance limitations between data source and target; very efficient use of TCP/IP networks for data propagation. |
8. Geographic distance limitation between data source and target; very high bandwidth consumption - most cases need fiber connectivity between storage sources. |
9. Data transformation and enrichment. |
9. No data transformation capability. |
10. Real-time data integration for real-time business intelligence initiatives. |
10. No support for real-time data integration. |
For further reading:
If you still have more questions, please send us a note.
|
