One of the most powerful analytical massively parallel processing (MPP) databases in the market is Greenplum. The database makes it easy to retrieve data in real-time and can run complex query workloads.
However, despite its excellent processing, Greenplum database is not ideal for high volume on line transaction processing (OLTP) typically run on databases like DB2, Oracle and SQL Server. To make Greenplum work seamlessly and effectively with databases that process high volume OLTP, a real-time database replication system must be integrated to provide the high volume interaction necessary. HVR software provides one such solution.
Oracle to Greenplum Replication Software
HVR’s real-time database Oracle to Greenplum replication system makes it possible to deliver large volumes of data fast and reliably from DB2, Oracle and SQL Server databases into Greenplum. The system allows users to get see real-time analytics and get valuable insights into various data.
In today’s competitive environment, access to information when needed can mean the difference between success and failure of projects. For organizations to compete and deliver expected value to customers, they must have access to real-time data and analytics. Using HVR’s database replication system can enable Greenplum to access high volume transactional processing data from Oracle and other source OLTP databases.
Data changes that do not slow down transactional processing can be captured out of the OLTP database’s transactional log and injected into Greenplum database through CDC (Change Data Capture). The data changes captured by this innovative and non-intrusive method can be delivered into Greenplum database through HVR (High Volume Replicator).
Features of HVR Database Replication System
The database replication system from HVR provides end-to-end data load capabilities for delivery and replication of high volume data changes in real time. Features of the system include:
Ability to compare and identify whether tables are in sync.
Burst optimization when synchronizing data in real time. This ensures optimum performance of replication into the Greenplum MPP database.
When the source databases (DB2, Oracle, Ingres, SQL Server or PostgreSQL) are in use, potential data losses are prevented by integrating the initial load with ongoing CDC.
Automatic data type translation and DDL generation for the Greenplum databases schema based on the source database (DB2, Oracle, Ingres, SQL Server or PostgreSQL).
The database replication technology has no impact on the source database. With the technology, tables can be added or removed from the source database. On the target database, the replication system allows for fast, parallel and bulk-upload. The software uses native driver and guarantees quality of data injected into the target databases.
HVR’s database replication system is ideal for enabling high volume interaction between Greenplum database and Oracle database.