Replication

Oracle Streams is based on a foundation of AQ. Before speaking of Streams, a quick review of AQ is in oder.

What is AQ?

Advanced Queues, or AQ, is Oracle's messaging solution. AQ provides a persistent (or non-persistent for specialty apps) queue mechanism that can guarantee delivery of a message. It has interfaces to PL/SQL, OCI and Java. It's Oracle's answer to IBM's MQ Series.

A message can be an XML document, a set of fields, an array of data and just about anything else you can think of.

AQ works on a publish/subscribe model. That means that someone (a publisher puts a message on the queue and someone else (a subscriber) takes the message off. A queue can have multiple subscribers. Technically it can have multiple publishers but I haven't worked with that configuration and I'm not sure what the usefulness of that is. I think I would prefer multiple queues, one for each publisher.

What's AQ good for? What does it do?

One example would be replication. And that brings us to Oracle Streams.

Page: 1 2 3

Topic: Replication Oracle Replication Postgres Replication MySQL Replication