:: ALTIBASE ::

PRODUCTS > ALTIBASE DATA INTEGRATOR >
TECHNOLOGIES

Major Technology 1. Log-based CDC

CDC is the acronym of Changed Data Capture, and it is used for ‘capturing the changes in data’.

And the log-based CDC indicates the method that detects the change in the DBMS log, and captures the changed data. This method is utilizing one of the characteristics of DBMS that records all the changes of data into the log, whenever DML or DDL occurs.

Besides log-based CDC, the data in DBMS can be captured by using triggers to capture the changes, or by querying the DBMS directly to fetch the data. However, these methods will place quite a heavy load on the operating DBMS.

Compared to these methods, log-based CDC captures only the log, independent from the DBMS, so it can capture only the changed data without placing any load on the operating DBMS and the system. Also, even in the event of DBMS failure, ADI can read maintained logs continuously, so that the data can be captured and applied without interruption.

Major Technology 2. Universal Data

One of the major characteristics of ALTIBASE Data Integrator is that it enables data replication between heterogeneous DBMS. The technology that enables this feature is to use the universal data type, which is not dependent on the data types of the specific kind of DBMS, as the intermediate data. ALTIBASE Data Integrator uses the universal data type during the data transfer, so the data can be converted easily to suit various types of DBMS.

Major Technology 3. Product Architecture

ALTIBASE Data Integrator has various features and characteristics because of its well-designed architecture.

3-1. Composition

ALTIBASE Data Integrator consists of the components shown in the following figure.

< ALTIBASE Data Integrator Components >

Capturer

This module captures data from the logs in the source database. Therefore, it can operate with almost no load on the source system and the database.
Captured data are stored in the staging store after they are filtered. Therefore, even in the event of source database failure, captured data can be sent to the target system without interruption.

Controller

This is the central processing module of ALTIBASE Data Integrator, and it controls the interface for the users and the interaction between each of the modules. The controller module in the source system controls the sender and the capturer, which read the staging store and send the data to the target system; and the controller module in the target system controls the receiver and the applier in the target system. Also, it sends the operating information in real time to the monitor, so that the users can monitor each of the systems. When the administrator executes the admin tool, this module processes the command that the administrator sends via the admin tool.

Sender

This module reads data from the staging store in the source system and send them to the receiver in the target system. Even if DBMS shuts down abnormally, the data captured before DBMS failure can be sent to the target system without interruption; if the sender module in the source system and the receiver in the target system are in operation. This module resides inside the controller of the source system.

Receiver

This module receives the data from the sender module in the source system, and stores the data in the staging store in the target system. This module resides inside the controller of the target system.

Applier

This module reads data from the staging store, and performs input, modification and deletion of the data in the corresponding database.

As shown in the figure above, the data captured from the data source will be accumulated first in the staging store, so that they can be transferred to the target system even during the source system failure, and then transferred to the target system. The data transferred to the target system will continue to be accumulated in the staging store, so that they can be replicated in the DBMS continuously even during the network failure, in which the connection to the source is closed.

The architecture shown in the figure above makes ALTIBASE Data Integrator has various characteristics and the features - including low resource usage, real-time replication between heterogeneous DBMS, support for various topologies, and the fault tolerance.

3-2. Easily Scalable Structure

The architecture of ALTIBASE Data Integrator also enables the flexibility for configuring the system into various forms according to the requests of corporations, and the scalability for expanding the system without limitation. There is no limit in the configuration of topologies of the system by utilizing the flexibility and the scalability of ALTIBASE Data Integrator, as shown in the following figures.

1:1 Structure

This is the default system structure that replicates the data from the source database to the target.
Applicable Areas : Connecting heterogeneous DBs in a single system, establishing HA system

1:N Structure

This system structure can be used for replicating the data from the central source database to the databases in multiple branch offices. This system structure replicates the data from the source database to multiple targets.
Applicable Areas : Establishing DR without placing any load on the operating server.

N:1/N:M Structure

N:1/N:M structure is used for integrating source data scattered around multiple nodes, or for distributing and replicating the data to multiple nodes.

Propagation Structure

Propagation structure enables the replication with more than 3 logically or physically separated DBs.