InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Is There Any Disadvantage Of Splitting Up Your Application Data Into A Number Of Different Databases? |
|
Answer» When there are relations between TABLES / OBJECTS across the DIFFERENT databases, then there is a disadvantage indeed: if you would restore a dump of one of the databases, those relations may not be consistent anymore. This means that you should always back up a consistent set of databases is the unit of backup / restore. Therefore, when MAKING this KIND of design decision, backup/restore issues should be considered (and the DBA should be consulted). When there are relations between tables / objects across the different databases, then there is a disadvantage indeed: if you would restore a dump of one of the databases, those relations may not be consistent anymore. This means that you should always back up a consistent set of databases is the unit of backup / restore. Therefore, when making this kind of design decision, backup/restore issues should be considered (and the DBA should be consulted). |
|