patternMinor
Single versus Multiple databases
Viewed 0 times
multiplesingledatabasesversus
Problem
I am working on a hospital management system using DB2 with pureXML.
Is better to use a single database for all the data (patient, doctor details, appointments, history, medicines, etc) or to use multiple databases in order to be scalable?
Is better to use a single database for all the data (patient, doctor details, appointments, history, medicines, etc) or to use multiple databases in order to be scalable?
Solution
Designing a platform: one database or multiple databases? is relevant background reading for your question.
You're possibly approaching this from the wrong angle. Is there really going to be a single, all mighty, all encompassing, one true system called "THE Hospital Management System"? Or will there be:
I'm sure there are dozens of other applications to add the list. Each of these is a separate application and probably a separate database, all of which need to talk to each other via a defined interface. One big application with one big database is a fast road to chaos.
You're possibly approaching this from the wrong angle. Is there really going to be a single, all mighty, all encompassing, one true system called "THE Hospital Management System"? Or will there be:
- Appointments Management System
- Patient Records Systems
- Medicines/pharmacology database (highly likely to be something bought in, rather than re-invented)
- ... ?
I'm sure there are dozens of other applications to add the list. Each of these is a separate application and probably a separate database, all of which need to talk to each other via a defined interface. One big application with one big database is a fast road to chaos.
Context
StackExchange Database Administrators Q#8431, answer score: 3
Revisions (0)
No revisions yet.