I am working on a application that has following requirements :
we have 200 hundred branch and one head office . it financial large scale system .
that has -Accounting , cash, loan management module. Every branch operate those module .
and user hit/transaction rate is high. it is kind of banking system .
our system currently run on distributed database with Desktop application .
Now , for better maintainability , We want to run it web application server with one centralized db environment .Now , I have a confusion ,
Q1 . if we go to the centralized database system for above scenario, is it right decision for me ?
Q2 . Actually , personally i have no working experience about distributed db , so.
what are the real advantages distributed db over centralized db for above requirements ?
Q3 . is it possible to achievement performance using centralized db without distributed db for above business requirements ?