Re: 9i streams vs triggers

"servant" <mjohns1_at_uhc.com> wrote in message news:avmkgh$6kq$1_at_gabriel.uhc.com...
> Sybrand,
>
> I am having trouble understanding how I can design my database to have
data
> that is updated and selected simultaneously without contention. The
update
> will lock the row and block the select and vice versa, right? Can you
> expand . . .?

Let me jump in before you get told to RTFM. In an Oracle database an update will not block the select and vice versa. It just won't happen (unless an app developer codes it to).

Now none of this addresses you complexity issue, but it seems likely to me that coding views and stored procedures might well address your reporting requirements before you get onto ETL. Of course it may not do if the massaging is really complex, but there is an awful lot you can do with plain SQL or PL/SQL. What you may run into is different performance characteristics for reporting needs to OLTP needs.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************