Universal Relations

These universal relations (or universal relationships) are a high-level set of relations, also known as fundational relations, that apply across business areas and domains. Many domain-specific relations are subtypes of these relations, frequently with domain-specific names.

We're making this list publicly available to support the data management community. We encourage you to use this information for non-commercial purposes and tell others. Please contact us with any proposed additions. We'll credit you for accepted additions.

Universal Relations: what, why, who, when, where, and how

What are they? A tool for identifying, naming, and specifying entity relationships.

Why should I bother? Because utilizing universal relations:

Who? Who assigns these universal relations? Any knowledgeable person, certainly the data modeler or business analyst would be responsible for this. I've found that subject matter experts frequently understand them easily enough they can sometimes select one themselves! Who uses the universal relations? The people that need to understand the business: business managers, subject matter experts, data modelers, business analysts, data analysts, data scientists, etc.

When do we assign them? As early as practical during the process of gathering and documenting your data requirements.

Where do we document the Universal Relations? Wherever you document your data requirements. I recommend using an analysis data model in whatever format your organization uses.

How do I determine the most appropriate relation? Review the name, examples, definitions, and domain and range entity constraints.

Universal Relations
Relation CategoryRelation NameReverse Relation Name
typehoodis type ofhas type
parthoodis part of (material or spatial)has part (material)
parthoodis part of (process)has part (process)
participationis participant inhas participant
participationis subject participant inhas subject participant
participationis target participant inhas target participant
classificationis classification ofhas classification
containmentis contained in contains
spatialis located inspatially contains
spatialis spatially contained inspatially contains
temporalfollowsis followed by
causationis causally related tohas cause
causationtriggersis triggered by
concretizationis concretized asis concretization of
transformationis transformation oftransforms into

Acknowledgements

Thanks to the following people for their contributions:

References

back to top