andrewah_at_hotmail.com wrote:
> Hi,
>
> I wondered if you could advise me on what Oracle feature to look into
> to help me decide upon a design issue?
>
> we have a corporate database - our main system - which is effectively
> the single repository for data in the organisation.
>
> A need for a publically available extranet has arisen, whose
> underlying database schema will contain a replica of some of the main
> system's data.
>
> About 10 tables have to be populated in the extranet's database. Their
> data will be derived from data stored in the main system. Some, but
> not all of these tables have a direct equivalent in the source system
> - ie the data that some tables will store is derived from a number of
> tables in our source system.
>
> If records in two of the tables in the main system are flagged to be
> pushed to the website's database by business users [which could happen
> at any time], it is possible to derive what the remainder of the data
> destined for the website's database should be.
>
> Clearly, it would be very simple to implement a push of data from the
> source to the destination database just by putting triggers on the two
> tables previously mentioned to capture changes to their records, using
> some queries to bring the data together, and then send these resulting
> datasets off to the destination system.
>
> The question I have is whether or not a feature like 'Oracle Streams'
> or 'Change Data Capture' would be useful in this situation? Is it
> possible to configure either of these features to recognise that when
> a change is made to a particular record, that Oracle should not only
> propogate this change to a destination system, but also propogate a
> related dataset as well? A feature like Streams would certainly
> simplify catering for situations where reference data in the main
> system changed after it was pushed to the destination.
>
> Any information would be appreciated,
>
> Cheers,
>
> Andrew.
CDC is a simple, basic, form of Streams. Easy to implement, easy to
maintain, and little flexibility. I suspect you are looking at Streams
and will need to give careful consideration to how you write your
positive and negative rule sets.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Oct 06 2007 - 02:31:57 CDT
