Home » RDBMS Server » Performance Tuning » what is the best ? (merged 3) (oracle 11g )
what is the best ? (merged 3) [message #438479] Sat, 09 January 2010 15:26 Go to next message
al_hareth
Messages: 2
Registered: January 2010
Junior Member
what is the best way ?

multiple schema in the same database or multiple database.....

and what is advantage and disadvantage for each one

i have 5 database each one have 10 schema .......
is best decision to integrate them in one database ?



[Updated on: Sat, 09 January 2010 15:32] by Moderator

Report message to a moderator

Re: what is the best ? [message #438480 is a reply to message #438479] Sat, 09 January 2010 15:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
One database, multi-schmas.
By definition, a database is a set of schemas.
It is designed for this.

Quote:
is best decision to integrate them in one database ?

Yes (assuming the applications are well-designed).

Regards
Michel

[Updated on: Sat, 09 January 2010 15:30]

Report message to a moderator

Re: what is the best ? [message #438484 is a reply to message #438479] Sat, 09 January 2010 15:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what is the best way ?
There is no one size fits all solution.

>multiple schema in the same database or multiple database.....
Yes

>and what is advantage and disadvantage for each one
Storing all apples in a single basket.


>i have 5 database each one have 10 schema .......
>is best decision to integrate them in one database ?

Fewer DB means less overhead & less maintenance; but more single points of failure

More DB mean fewer single points of failure & ability to upgrade seperately; but higher overhead in resources consumed & more time to apply individual changes/upgrades.

Each has good points & bad point.
Either can be made to work, so pick your poison.
Re: what is the best ? (merged 3) [message #438486 is a reply to message #438479] Sat, 09 January 2010 15:49 Go to previous messageGo to next message
al_hareth
Messages: 2
Registered: January 2010
Junior Member
thank you for all the quick of response

where can i find some of the comparative between two way
Re: what is the best ? (merged 3) [message #438488 is a reply to message #438486] Sat, 09 January 2010 16:23 Go to previous message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
Maybe you should also have a look at the applications which are talking to the databases.

If all the databases are used by one type of application(server )(lets say oracle) then it doesn't matter that much. But if one is queried by OAS, and another one by php and yet another one by websphere you may run into trouble when upgrading. (think of also upgrading middleware)

Also you could consider whether maybe some db's are state-of-the-art bleeding-edge technology, and maybe others are 10 year old legacy db's. Then you can also run into trouble while upgrading.

Previous Topic: cardinality of join affected by transitivity
Next Topic: how to reduce the response time of the sql query
Goto Forum:
  


Current Time: Tue Dec 03 08:31:01 CST 2024