By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Database Design

P: 3
Please Help me out in the Design of Postgres Database for the criteria

1. We have 20 Area Offices -- each Area Office to have another 20 branches -

2. One Central Server at Head Office..

Transactions are done on area basis .. Queries/Updataios/Additions are within the area office. Even Master files -- like customer data are specific to area. Transaction indexes need not be on the entire enterprise they can be limited to Area.

Kindly suggest how I should Design. at the Central Server

-- Have one Large Data Base ..for the entire enterprise

Different databases for each Area Office ...

Which will be Opimal in terms of performance ..

Thanks a lot in advance

Sep 1 '08 #1
Share this Question
Share on Google+
1 Reply

P: 2
In my humble opinion, if the head office doesn't need the store the data for real time basis it is better to put the different database in each area office (which is of course with the same design with other area office). and by timely basis, head office merge the data needed by the head office or merge the database.
or you can use data replication for the head office so it will automatically replicate data from the area office.

currently i'm working on the replication for my client company also. tell you if its works well.

humble regards

Ferry M Ferdian
Sep 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.