Data Sourced from mainframe for Oracle application

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Fri, 11 Jun 2004 11:07:19 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF1688087066D681B@tuscil_ex1>

Hey fokls... looking for some feedback.

I've got data sourced from other databases (e.g. DB2, etc..) that is comming into a central Oracle database. Right now, this data is fairly small, but the volume will be increasing quickly (amount of data and number of tables being replicated), and the number of applications that will be using this data will increase as well. Each of these applications has different data retention requirements (some, for example, only need the data for 10 days, other for 180, others for 365, and each only need subsets of the whole).

Each application also has it's own application specific data as well of course.

So, I'm trying to decide what the best architectural option is here. The options as I see them are:

Have one big data store for the data, throw all the applications in it being careful to tune each one so they won't step on the other. Benefit: Data is only stored in one place, no physical duplication of data. This is not my prefered course of action, but others prefer this.
Have multipule instances for the more critical applications, and duplicate (replicate) the data to those instances. Less important, and less performance impactive applications could sit on a single database, but those mission critical applications would sit on their own instances/disks/etc... the down side of this is duplication of data, and more disk space is required. Still from an administrative point of view this seems a better course of action.

Any thoughts on this?

Robert

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Jun 11 2004 - 11:04:49 CDT