Record Relationships

When using record relationships in TIBCO MDM, you can bundle together and retrieve collections of related records.

When a parent record is queried, TIBCO MDM must evaluate all of the related records and potentially retrieve these and any related subrecords (if configured to do so). Relationships in TIBCO MDM can be a powerful tool. However, misused relationships can negatively impact performance.

Use relationships only when they are required to obtain bundles of data. Some examples include the following:

  • Using the relationship between a rail line table and the track table you can query all of the tracks that make up a line.
  • Using the relationship between CarModel and CarParts you can identify which car Models use which car parts. (You can use reverse relationships in TIBCO MDM, for example, which car models use a car part.)