what is the best ? (merged 3) [message #438479] |
Sat, 09 January 2010 15:26 |
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 |
|
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 ? (merged 3) [message #438488 is a reply to message #438486] |
Sat, 09 January 2010 16:23 |
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.
|
|
|