RE: building a reporting database

[C.S.Venkata Subramanian]

Hi All,
I have been working with client, where the refresh of the reporting instance is happening every 12 hrs due to business needs. This process is very well defined and the users are very happy. Even the concurrent requests are xfr to new reporting instance. I would take it offline and the process in fully driven by scripts and one good point is that we can continue from the point where it failed.

--------- Original Message ---------

DATE: Tue, 18 Nov 2003 04:59:25

From: "Nelson, Allan" <[EMAIL PROTECTED]>

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Cc:

We are working a SharePlex project from Quest.  For our purposes (Financials) with heavy adhoc (Cognos) we need to stay as close as possible to the production instance.  The advantage to SharePlex is that it is a log miner and hence does not do a lot of sql against the source database.  It is near real time.  Since this is not an Oracle product perhaps offline would be a better place to discuss it.  One disclaimer, we are still in implementation and are not currently in production.

 

Allan

-----Original Message-----
From: Sai Selvaganesan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: building a reporting database

hi

 

i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good.

- using aq and dq message processing

- using snapshot replication

- using ro standby databases.

 

the last one will lag in data since standby database caanot have any archival log applied when opened in read only.

 

is there any other good method to do this . my database is on 8.1.7.4

 

thanks

sai

______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
Login To Lycos Mail