Sunday, July 21, 2019

Subsetting Your Database

Once your data is cleaned up, consider whether all your scanned tests need to be in a single database. It doesn't always make sense.

For example, I have scanned tests for four very distant cousins on my mother's side, while most of my tests are from close family on my father's side. There is no need to keep Mom's cousins with Dad's siblings and nieces. However, I relate to everyone, so need to be in all the databases.

My plan is to break up my one large database into three smaller databases, each being a subset of the full database. The subsets are:
  • Four cousins on Mom's side, plus my brother, my daughter and myself.
  • Dad, four close relatives on that side, plus my brother, my daughter and myself.
  • My descendants and myself.

Work in a copy of your database. Before you begin, make sure you have good backups. If you are unsure, see the page titled Backups Are Priceless. Keep your large database, in addition to the new subsets.

Finish your data cleanup first. Then decide on the tests that relate to each other and should be in a subset.

Your strategy is to remove all the tests that do not apply to the subset. When done, close and rename the database. Grab a new working copy and remove tests that do not apply to the next subset. Repeat until you have created all the subsets you want.

This process is a bit tedious, but you only have to do it one time.

The index page has links to instructions for data cleanup and for removing a test.