Solved

same table in different databases with different data vs single table in singlle database

Posted on 2011-02-23
4
227 Views
Last Modified: 2012-05-11
Actually i am designing a database in MySql, In that the structure is there is one root organization  and there are several child organization. So should I go for a single databse in which the group interrelated tables store the data identified by a unique id to differentiate each child organization.
Or should I maintain different databases for each child organization with the same table structure and same tables  in all of them, but data related to each of them.
0
Comment
Question by:darien_software
  • 3
4 Comments
 
LVL 14

Accepted Solution

by:
Scott Madeira earned 500 total points
ID: 34960572
Personally I would design the database as one set of tables holding all of the data. That way you can always aggregate data should the need ever arise.  For the actual data tables I would add an organizationID to indicate which organization the data pertains to.

If you do it the other way I can almost guarantee you that somebody will want to see aggregated data and you won't have an easy way to do that.
0
 

Author Comment

by:darien_software
ID: 35230293
please answer it
0
 

Author Comment

by:darien_software
ID: 36109735
Yes that is correct in multiple database environment it is difficult to get the data organization wise and year wise.but i am concern about performance.
thanks.
0
 

Author Closing Comment

by:darien_software
ID: 36129219
I am expecting a detail anatomy about the effect on the performance and all the detail ie when the tables from  multiple databases are loaded into memory.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now