Skip to Content

Bidirectional logical relationships

Partitioned databases support both unidirectional and bidirectional logical relationships.

image2018-12-19_18-41-14.png

Bill-of-Materials

The classic use of unidirectional logical relationships is the bill-of-materials, also known as the parts explosion. As long as symbolic pointing is used for the logical parent, recursive logical relationships, within the same database, are supported.

image2018-12-19_18-42-41.png

The logical children and logical parents are in the same database but not necessarily the same partition. The concatenated key of the logical parent in the symbolic logical parent pointer is used with the HDAM randomizing routine or HIDAM index to locate the logical parent.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Partitioned Database Facility for IMS 9.1.00