Re: Data Sourced from mainframe for Oracle application

  • From: Michael Thomas <mhthomas@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 11 Jun 2004 10:06:58 -0700 (PDT)

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.

--- Freeman Robert - IL <FREEMANR@xxxxxxxx> wrote:
> 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

> 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

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).



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:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: