Solved

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

Posted on 2011-02-23
4
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

623 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