Oracle-L: RE: building a reporting database

From: Nelson, Allan <anelson_at_midf.com>
Date: Tue, 18 Nov 2003 04:59:25 -0800
Message-ID: <F001.005D70CB.20031118045925@fatcity.com>

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:ssaisundar_at_sbcglobal.net] 
	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]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Nov 18 2003 - 06:59:25 CST