McObject, provider of the eXtremeDB product family of real-time database management system (DBMS) software, has released its new Data Relay technology as a key building block for fast and flexible data-sharing between real-time applications based on eXtremeDB, and external systems such as an enterprise DBMS. Data Relay helps developers by simplifying the code that “looks inside” database transactions for changes that should be relayed. It also guarantees maximum efficiency by eliminating the CPU-intensive task of monitoring database activity.
eXtremeDB Data Relay maintains a buffer of eXtremeDB database transactions as they occur. For every object affected by a transaction, there is a code within the buffer that indicates whether the operation was an insert, update, or delete. Developers can use a familiar database “cursor” to iterate over objects in the transaction buffer. If the change in eXtremeDB is of interest (by the application’s criteria), the changes can be propagated to an Oracle, SQL Server, or other backend DBMS.
The new technology also supports an asynchronous mode, in which a transaction can commit on eXtremeDB before changes are saved outside the real-time system. Synchronous data-sharing guarantees consistency between eXtremeDB and the external database, but it ties the eXtremeDB in-memory database to the (slower) performance of the external database. In contrast, the more “relaxed” asynchronous approach largely sustains eXtremeDB’s natural performance. Synchronous Data Relay mode could be useful when eXtremeDB is employed as a predominantly read-only high speed cache to an RDBMS, with occasional updates. Asynchronous Data Relay mode could be useful for classic real-time applications such as financial systems.
eXtremeDB Data Relay provides a convenient, off-the-shelf solution to developers who otherwise would likely code these functions from scratch.