Oracle Database Discussions

Hi All,

I im interestd in having a comarision(proc/cons/test cases) between CDC,Streams and DCN in Oracle 10gr2 on RHEL 5.4.
My requirement is somethig like this:
We are creating a publisher/subscriber model (Publisher-Oracle DB,Subscriber-JDBC/OCI application Clients).
There are couple of high volatile tables in database (table size is ~2 GB and DML volume is between 10-50 MB per one ETL run) and hourly ETL jobs does its job on them.
As soon as ETL is over,we ask Clients to download/query table data from the database to get the latest version of data.
With Pub/Sub model as i stated,we want a mechanism which automatically NOTIFIES the clients whenever there is a change in table data.Upon which,their existing data would get invalidate and they would get the latest data.

I believe,CDC is good option but it does not have capability to notify the changes to its subscribers.Also we can not apply any RULE (coulum rules) with CDC.
STREAMS seems good option but again, it does not have the notification capability.I believe, administration/maintanace cost is also high in STREAMS.
I am not aware on DCN.

Can i request to have a proc/cons/test cases for each of these 3 technologies to have better choice for my requirements?
We are also planning to go for 11g.I believe,OCI CLIENT CACHE can be a good option too ?

Regards,
Bhavik