Re: Reports in OLTP system

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 28 Jul 2007 21:59:40 -0700
Message-ID: <1185685176.492136@bubbleator.drizzle.com>

Wiktor Moskwa wrote:
> On 28.07.2007, DA Morgan <damorgan_at_psoug.org> wrote:

>> I'd suggest taking a serious look at BAM.
>>
>> Why reinvent the wheel?

>
> Well, I want to learn how such things are done.
> Are materialized views or advanced queuing right tools
> here or not.
>
> I'd appreciate any advice.

To determine that would be a full scale research project. They might be and then again they might not be. I know organizations doing it with Data Guard replication to a logical standby so it very much depends.

Give some metrics with respect to number of users, transaction size, number of transactions, etc. and perhaps someone from a similarly sized organization can tell you what worked or didn't work for them.

-- 
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 Jul 28 2007 - 23:59:40 CDT