Event Messaging and Notification

Streams Methodology event management systems allow the applications to enqueue explicitly. The captured events may be DML or DDL changes. Through the use of multiple queues and queue tables, events are propagated to the desired queue systems. These messages can be explicitly de-queued by writing a suitable application routine.  This routine may update certain database objects or trigger some other specific action or series of actions.

Message Systems are important components in the overall business communication process. Based on the appropriate rules, a messaging client or an application can de-queue the messages. This kind of event based system has the added advantage of having the capability of alerting the appropriate monitoring systems or applications groups. They can also develop a suitable auditing mechanism allowing further analysis of the actions that have taken place.  User developed application routines can be used to harness the database to perform actions that range from notifying the user that a set criteria has been met or the database can de-queue the messages in a manner determined by the user.

Data Replication

Data Replication is one of the most widely used methodologies for the maintenance of different sets of data within or outside business organizations. It is used to keep those sets of data synchronized, as required. Data Replication is one of most significant benefits of the Stream Methodology.