Database Design

[kompallikedar]

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

Kedar

[ferryferdian]

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