Chapter 9: Structure Analysis

Chapter 9: Structure Analysis

Overview

Having completed an analysis
of individual column properties, the next step is to look at structure
constraints that are, or should be, defined over the data. This may reveal
additional problems in the data.

There are two issues to look for in structure analysis. One is to
find violations to the rules that should apply. This points to inaccurate data.
The other is to determine and document the structure rules of the metadata.
This can be extremely valuable when moving data, mapping it to other
structures, or merging it with other data.

Structure rules are often ignored when looking at data. This can have
serious consequences when trying to extract the data for use in other data
structures. The primary reason for ignoring them is that the analyst is not
familiar with the basic concepts of database architecture. This makes structure
analysis difficult. It is important that this step be performed by someone who
has the right background. Any analyst can learn the basic concepts and should
take the time to do so.