Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Sourced from mainframe for Oracle application

Re: Data Sourced from mainframe for Oracle application

From: Michael Thomas <>
Date: Fri, 11 Jun 2004 10:06:58 -0700 (PDT)
Message-ID: <>

Hi Robert,

These are good questions.

I played mental ping-pong with thoughts about architectural scalability, performance, design, etc. But, I could argue with myself for either of your options, centralized or decentralized, and still not decide because of too many possibilities.

> 1. Have one big data store for the data, throw all
> the applications in it


> 2. Have multipule instances for the more critical
> applications, and
> duplicate (replicate) the data to those instances.

> Any thoughts on this?
> Robert


Here are some ideas. Why is management recommending consolidation?

I think for a project manager in a large corporation, it would be simplest to get one big, fast server site and host everthing in a centralized fashion. Because, once the bills are paid, they only have to manage one (depending on recovery) installation, configuration, and support site.

Its easier to figure out costs to setup a single site. If another member is added later to the project, its easier to add them, than to reconfigure another smaller server for a single add-on project. For a small project manager its easier to join a centralized database, rather than build-your-own subsystem for each project.

The disadvantages of a centralized database architecture include increased complexity to consolidate all the pieces (yada, yada), and getting reliable and fast network access to the central site for both data source loads and user access. A centralized architecture implies centralized bureacuracy and controls that often conflict with remote application owners, developers, and different organizational processes.

I've see that once our data was consolidated into Oracle, from all the various data sources, then new business requirements were spawned. Maybe you will need to analyze the consolidated data with some tools, and, tools are too expensive to host at multiple server sites. It might be possible to convert some existing tool licenses to work with one consolidated database, but very difficult to afford for many decentralized database servers.

Good luck. You sound like you may be holding out for a decentralized database system. If funding is piecemeal, then you may not be able to afford one consolidated database system, but otherwise I think its an up-hill battle to argue for decentralization and Oracle. Hey, it could be worse (M$ SS on W2K/3). :-)

HTH. Regards,

Mike Thomas                          

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Fri Jun 11 2004 - 12:04:11 CDT

Original text of this message