single database vs multiple databases
Posted by: Radhakant Samal
Date: February 24, 2011 11:10PM

I want to know which type of database designing helps in better performance.

suppose there is a main organization under which several organization are working.

the functioning of every child organization is same. so the er modeling is same

for all. so in this case i want to know, should i go for separate tables for

every
child organization. Table structure and no of tables in the database is same for

every child organization,but the data is different for every child organization.

So should i maintain separate set of tables for each child organization. Or

should i have a single table which contains all the data of all the child

organization, and they all will be identified by any unique key. so while

retrieving we can filter them by this key. So i want to know which one is better.

Group of same tables for each child organization or a single table for all this.

Which will come good on performance. kindly reply earlier.

Please reply why no one is replying ? Is the information not sufficient ?

Options: ReplyQuote


Subject
Written By
Posted
single database vs multiple databases
February 24, 2011 11:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.