Keeping related data together

You should group related data together to aid in data recovery.

In the process of designing your database, you will develop an understanding of the relationships that exist between tables. These relationships can be expressed:
  • At the application level, when transactions update more than one table
  • At the database level, where referential integrity exists between tables, or where triggers on one table affect another table.

You should consider these relationships when developing a recovery plan. You will want to back up related sets of data together. Such sets can be established at either the table space or the database level. By keeping related sets of data together, you can recover to a point where all of the data is consistent. This is especially important if you want to be able to perform point-in-time rollforward recovery on table spaces.