The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Design Forum
Database design help

1 reply on 1 page. Most recent reply: Feb 7, 2005 5:16 AM by Saud Zakariya

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 1 reply on 1 page
vaishu

Posts: 1
Nickname: vaishu
Registered: Feb, 2005

Database design help Posted: Feb 5, 2005 5:32 PM
Reply to this message Reply
Advertisement
Hi,
I am developing a small web based centre management system for one organization using PHP,MySQL with Apache. This system is actually my course project. The organization have few centres located at different places.The headquarter(HQ) of the organization need to access all the centres data to generate report.The problem is that i didn't know how to design the database. Do i need separate database to store each centre's data or can i store all the information involving the HQ and centres in one database which will reside at the HQ main server?If i use many databases will that effect the processing speed of the query.Will there be any problem (regarding query processing speed) if a database for a web based system have more than 25 tables and i need to query multiple tables?


Saud Zakariya

Posts: 5
Nickname: saud
Registered: Feb, 2005

Re: Database design help Posted: Feb 7, 2005 5:16 AM
Reply to this message Reply
(1)
There are factors that affect your decision on this, like communication medium between centers, size of data being communicated, servers’ capabilities...

If you choose to keep a database in each center then you have to consider properly Synchronizing/linking/Posting between them.

I would guess it's better to keep 1 database at a location that is easily accessible (may be HQ).
This way you make the data much more integrated.

(2)
Will there be any problem (regarding query processing speed) … for > 25 tables ?
There shouldn’t be, but again, query performance depends on the communication speed.

Flat View: This topic has 1 reply on 1 page
Topic: Problem with DataSource Look Up Previous Topic   Next Topic Topic: question
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use