Is it better to have multiple databases?

Should you have multiple databases?

Try to keep logically related information together and unrelated information separate. Try to avoid multiple databases or tables with the same design or purpose. Multiple database apps are usually apps which have their own data requirements but also have to integrate with another existing app or service's database.

Is it better to have one database or multiple databases?

Single database to backup, less maintainance. You don't need to manage multiple connections. Multiple databases can break the chance to perform atomic transactions, a feature I would never throw away. You avoid synchronizing two or more databases to avoid integrity problems.

Why is it important to use multiple databases?

A combination of multiple databases would yield more articles than Medline alone, which can help us to make accurate decisions.

When should you separate databases?

If the data has different back up and recovery requirements, then they are very good candidates for separate databases. That is only half the problem, though. In most environments, backup/recovery is pretty much the same for all databases. It becomes a question of application design.