RTblRelships Example Four

Meta Data Services Programming

Meta Data Services Programming

RTblRelships Example Four

This example shows a data set that can be consolidated to remove extraneous values.

In some situations, several relationship rows exist where one would theoretically suffice. For example, consider a row that includes these values:

OrgID  =  7
Z_OrgBrID_Z  = 4
Z_OrgVS_Z  =  3
Z_OrgVE_Z  =  8
DstID  =  888
Z_DstBrID_Z  =  4
Z_DstVS_Z  =  2
Z_DstVE_Z  =  2
RelTypeID  =  465
Z_RelFlags_Z  =  2

The row indicates that a version-to-version relationship (to a specific version of the destination object) exists from every Branch 4 version of the origin object whose version-within-branch identifier is between 3 and 8.

Compare the preceding row to the following rows. In particular, notice that the following two rows are effectively equivalent to the preceding row. Taken together, the following two rows indicate exactly what the preceding single row indicates. In other words, given two instances of the same origin-destination object pair, combining the lowest of the Z_OrgVS_Z values and the highest of the Z_OrgVE_Z values fully represents all version possibilities between this origin-destination object pair.

OrgID  =  7
Z_OrgBrID_Z  = 4
Z_OrgVS_Z  =  3
Z_OrgVE_Z  =  5
DstID  =  888
Z_DstBrID_Z  =  4
Z_DstVS_Z  =  2
Z_DstVE_Z  =  2
RelTypeID  =  465
Z_RelFlags_Z  =  2

OrgID  =  7
Z_OrgBrID_Z  = 4
Z_OrgVS_Z  =  6
Z_OrgVE_Z  =  8
DstID  =  888
Z_DstBrID_Z  =  4
Z_DstVS_Z  =  2
Z_DstVE_Z  =  2
RelTypeID  =  465
Z_RelFlags_Z  =  2

See Also

RTblRelships SQL Table