Real time datawarehouse: Asynchronous message queueing?

From: Vikas Agnihotri <vikasa_at_writeme.com>
Date: Tue, 19 Oct 1999 17:47:02 GMT
Message-ID: <7uiaqh$l72$1@nnrp1.deja.com>

Loading your DW from OLTP systems every week/month is no longer acceptable if the DW is to be of any value to the business.

The logical solution seems to have the OLTP system "push" transaction details as they occur, either directly to the DW or to a staging area. Of course, to minimally disrupt the OLTP system, this "push" has to be asynchronous in nature.

If both the OLTP and DW use Oracle RDBMS, has anyone used Oracle's message queueing features for this kind of use?

How easy are they to use?
Performance?
Volume limitations on message size, etc? ACID test?
Recovery from premature termination, receiving database not up, etc, etc. A whole bunch of error conditions...How does Oracle deal with them?

Finally, how does Oracle's message queueing compare to the commercially available dedicated "middleware" queueing products out there like, say, IBM's MQ Series.

Any comments, experiences appreciated.

Thanks,
Vikas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 19 1999 - 12:47:02 CDT