Multiple Tables or Multiple Databases?

Question

Scenario:-

A company will have many branches and there will be many companies registering to the system.
All tables which store data about each branch will be the same for all companies.(eg:- employee table, services table,etc.)

Question:-

Is it advisable to replicate the table structure for each new instance of a company branch, or to use a new database for each new company registered to the system?

Alaa Alweish · Accepted Answer · 2013-06-21 08:06:59Z

2

it depends on the developed system (Online or local), the required tasks (the query rate, and Reports),

If this company will always query the data for all branches or needs a frequent statistics and reports (now or in the future) then you must do it in one database.

if you are afraid of the performance then enhance the server capabilities and the database engine will manage the rest with no issues.

However, take into consideration that the database design will have a major effects on the performance so you will need to do it perfect by using indexes, correct relations, and mainly by understanding the current needs and the expected future needs, try to imagine every query or report that might be needed when the company is having the maximum expected number of branches,

I believe that one database will be enough for almost all scenarios, and remember that having many databases will cost a real headache in the future (mirroring, synchronizing, reporting, maintenance, backups..etc)

answered Jun 21, 2013 at 8:06

Alaa Alweish

9,11617 gold badges63 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akila Galappatthy Over a year ago

Thank you very much for the answer, this is the exact response i was looking for. We actually do have to query the database for all companies very frequently since the customer end requires details of all companies.

Aboelseoud · Accepted Answer · 2013-06-18 08:13:45Z

0

The better structure is to have two tables Companies and CompaniesBranches

answered Jun 18, 2013 at 8:13

Aboelseoud

5552 gold badges7 silver badges22 bronze badges

2 Comments

Akila Galappatthy Over a year ago

i have both tables, and there is another set of tables such as, employee,stock,schedule,etc. What i want to know is, when adding new branches, should i re-create entire table structure for each additional branch, or just add all data to a single set of tables. Thank you for the quick response Abo!

Aboelseoud Over a year ago

I'm not sure so maybe you should wait for another answer.

Collectives™ on Stack Overflow

Multiple Tables or Multiple Databases?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related