I am currently working on an application which has a challenge.
I have a centralized database with collection of data. I have different components which needs to access those data.
Now i want to choose the best approach (or) model to achieve this.
I have two ideas which has its own Pros & Cons.
First one is,
Hitting the centralized database to collect and process all the data which will avoid data redundancy but increase the complexity in terms of server load and performance.
The other one is,
Having a separate schema (or) table for each component and allowing them to get in touch with the corresponding schema to access required data. It will have the data redundancy but good in terms of performance.
I need experts' advise to choose the best approach. Also, let me know if any other approach is best for these kind of problems.
So, Kindly suggest me.