I need a suggestion on the scenario I have, multiple application sharing same data.
-I have a set of tools which is developed independetly, but there is a set of data they share.
-Its around 7 Applications sharing some of the basic data and few data are specific to the application.
-I also have to maintain a local copy of the central DB and update accordingly.
-Is it a better idea to for independent database per application or having a single application?
I find it is better to go for single database per application since,
-Maintanance becomes easy
-Need not have an extra job of hiding one application data in another.
-Achieve scalability
-Time saving in terms of implementation, need not check for too many things.
-Update logic also becomes easy
Anyhow I am worried about the common data which I would be duplicating in the above case, is there a way to expose common data to all the applications having specific data separate?