Solved

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

Posted on 2011-02-23
4
229 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL Error 3 43
simple mysql statement 3 37
Select Query - Group By Function Producing Unexpected Results 8 19
Upgrade MySQL 5.5 to MySQL 5.6 on Windows 13 24
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

786 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