Hello, guys!
One company hired me to unify (and redo) several systems they own.
The work is to create single administrative panel for various sectors and products.
When thinking about storing the data, I came across the following question:
Do I create a single database for all systems or one database for each system?
What is recommended? What are good practices today? Which one consumes less processing?
I thank you for your help!
The ideal would be to work with independent but unified databases by normalizing relational databases.
Each industry would be an independent base and each base would work with related products. If necessary, separate bases can be linked through the entity-relationship model, where information from one database can be queried in others, thus making its basis more secure, since the information would be "dismembered" but without impact. Another advantage is that the access time would be significantly reduced because the page would access a smaller base and, if necessary, would use its relational fields to directly access information from other databases.
In my company, we have been working with this model of related bases since 2008, and the production gain is very high.
If you want more information, I leave a link that my college professor has left us for further reading.
