Actions
task #7319
open[CHECK] Import synonyms correctly in E+M
Status:
Resolved
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:
90%
Estimated time:
2:00 h
Severity:
normal
Description
Since CDM 4.1 synonyms may belong only to exactly 1 taxon (#5803, #5974). Therefore pro parte/partial synonyms should be handled as different concept with pro parte synonym concept relationships instead.
In E+M there are multiple synonyms having more than 1 accepted taxon. Those being pro parte/partial synonyms should be handled as described above and be converted to accepted taxa, while ordinary synonyms with >1 accepted taxa should be corrected in data.
Possible candidates can be found via
SELECT ta.PTNameFk AS synNameID, ta.PTRefFk, syn.StatusFk, st.Status synStatus, synName.FullNameCache,
rel1.RelQualifierFk relTyp1, relStatus1.RelPTQualifier relTyp1_, acc1.StatusFk st1, acc1.RIdentifier taxon1, accName1.NameId name1, acc1.PTRefFk ref1, accName1.FullNameCache,
rel2.RelQualifierFk relTyp2, relStatus2.RelPTQualifier relTyp2_, acc2.StatusFk st2, acc2.RIdentifier taxon2, accName2.NameId name2, acc2.PTRefFk ref2, accName2.FullNameCache
FROM dbo.v_cdm_exp_taxaAll ta LEFT OUTER JOIN PTaxon syn ON syn.RIdentifier = ta.RIdentifier
LEFT OUTER JOIN Status st ON st.StatusId = syn.StatusFk
LEFT OUTER JOIN Name synName ON syn.PTNameFk = synName.NameId
LEFT OUTER JOIN RelPTaxon rel1 ON rel1.PTNameFk1 = syn.PTNameFk AND rel1.PTRefFk1 = syn.PTRefFk
LEFT OUTER JOIN PTaxon acc1 ON rel1.PTNameFk2 = acc1.PTNameFk AND rel1.PTRefFk2 = acc1.PTRefFk
LEFT OUTER JOIN RelPTQualifier relStatus1 ON rel1.RelQualifierFk = relStatus1.RelPTQualifierId
LEFT OUTER JOIN Name accName1 ON accName1.NameId = acc1.PTNameFk
LEFT OUTER JOIN RelPTaxon rel2 ON rel2.PTNameFk1 = syn.PTNameFk AND rel2.PTRefFk1 = syn.PTRefFk
LEFT OUTER JOIN PTaxon acc2 ON rel2.PTNameFk2 = acc2.PTNameFk AND rel2.PTRefFk2 = acc2.PTRefFk
LEFT OUTER JOIN RelPTQualifier relStatus2 ON rel2.RelQualifierFk = relStatus2.RelPTQualifierId
LEFT OUTER JOIN Name accName2 ON accName2.NameId = acc2.PTNameFk
WHERE syn.StatusFk NOT IN ( 1) AND acc1.RIdentifier < acc2.RIdentifier AND rel1.RelQualifierFk <> -99 AND rel2.RelQualifierFk <> -99
ORDER BY syn.StatusFk, relTyp1, st1, relTyp2, st2, syn.PTRefFk, synNameID
with
AND NOT (acc1.StatusFk <> 1 OR acc2.StatusFk <> 1) -- rel to accepted only
AND NOT (syn.StatusFk = 4 AND rel1.RelQualifierFk = 4 AND rel2.RelQualifierFk = 4) -- no pure pro parte synonyms
inconsistent pro parte:
AND
(
(syn.StatusFk NOT IN (3,4) AND ( rel1.RelQualifierFk NOT IN (2,6,7) OR rel2.RelQualifierFk NOT IN (2,6,7)))
OR
(syn.StatusFk IN (3,4) AND ( rel1.RelQualifierFk IN (2,6,7) OR rel2.RelQualifierFk IN (2,6,7)))
)
Related issues
Updated by Andreas Müller about 5 years ago
- Status changed from New to In Progress
Updated by Andreas Müller about 5 years ago
- Copied from task #6521: Check existing imports for handling new synonym structure correctly added
Updated by Andreas Müller about 5 years ago
- Due date set to 11/15/2016
- Start date changed from 03/19/2018 to 11/15/2016
- Follows feature request #5974: Remove synonym relationships added
Updated by Andreas Müller about 5 years ago
- Description updated (diff)
- Due date deleted (
11/15/2016) - Start date changed from 11/15/2016 to 03/19/2018
Updated by Andreas Müller about 5 years ago
- Related to feature request #7334: Make pro parte and partial synonyms real concept relationships added
Updated by Andreas Müller about 5 years ago
- Priority changed from Highest to Priority13
Updated by Andreas Müller over 4 years ago
- Target version changed from Euro+Med Portal Release to Euro+Med Migration
Updated by Andreas Müller over 4 years ago
- Subject changed from Import synonyms correctly in E+M to [CHECK] Import synonyms correctly in E+M
- Priority changed from Priority13 to Highest
Updated by Andreas Müller about 4 years ago
- Status changed from In Progress to Resolved
- % Done changed from 70 to 90
This seems to be fixed. There are only pro parte/partial synonyms left in the candidates list. And they seem to be handled correctly.
Actions