Aliases help lookup but must resolve to stable identifiers before joins.

highlighted = computed this step

Aliases are not safe primary keys

Aliases help humans search, but aliases can merge, split, or collide. This slice has 4 records with aliases.

alias rows=4\text{alias rows}=4
Aliases point back to identifiersAliases are lookup hints, not durable join keys.IdentifierAliasesCanonical labelMONDO:0007254breast cancerbreast cancerHGNC:1100BRCA1, RNF53BRCA1UniProt:P38398BRCA1_HUMANBRCA1 proteinGO:0006281DNA repairDNA repair

Resolve aliases before joining data

The safe workflow is resolve first, then join by identifier. The canonical label is display text; it is not the database key.

aliasidentifierjoin\text{alias} \to \text{identifier} \to \text{join}
Aliases point back to identifiersAliases are lookup hints, not durable join keys.IdentifierAliasesCanonical labelMONDO:0007254breast cancerbreast cancerHGNC:1100BRCA1, RNF53BRCA1UniProt:P38398BRCA1_HUMANBRCA1 proteinGO:0006281DNA repairDNA repair