Can someone point me to a reference on the suitability of a “single centralized database” Vs “distributed databases” in a “multi-plant” (i.e. manufacturing plants in multiple locations, all in India) production environment. This is for a sort of ERP application (with the usual modules – Material Management, HR, Finance, blah, blah…). There is no Supply Chain integration though.
I am rather confused about the way to go. While the centralized database has many advantages, I have a feeling the network performance issues could really hurt. The number of transactions/sec is not too high, but it will be over a 64-128 kpbs line, in the centralized environment. Right now, I am not convinced either way.
If someone has an idea about this stuff, your help would be much appreciated.