Versions Compared

Version Old Version 9 New Version 10
Changes made by

Rick Wood

Rick Wood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • nci_merge: Merged SCUI current version NCI atoms

    Code Block
    select a.id clusterId, a.id conceptId 
from concepts a, concepts_atoms b, atoms c
where a.terminology = :terminology
  and a.id = b.concepts_id and b.atoms_id = c.id
  and c.terminology='NCI'
group by a.id having count(distinct c.conceptId)>1

  • nci_sub_split: Split SCUI current version NCI (or sub-source) atoms

    Code Block
    TBD: 
select a.id clusterId, a.id conceptId 
from concepts a, concepts_atoms b, atoms c
where a.terminology = :terminology
  and a.id = b.concepts_id and b.atoms_id = c.id 
  and c.terminology in (select terminology from root_terminologies where family = 'NCI' and terminology != 'NCI')
group by a.id having count(distinct c.conceptId)>1

  • sct_sepfnpt: SNOMED concept clusters where the FN and PT terms are separated

  • cdsty_coc: Find concepts with Clinical Drug STY and any other STY 

    Code Block
    SELECT 
    c.id conceptId
FROM
    concepts c
WHERE
    c.id IN (SELECT 
            c1.id
        FROM
            concepts c1,
            concepts_semantic_type_components cs,
            semantic_type_components s
        WHERE
            c1.id = cs.concepts_id
                AND cs.semanticTypes_id = s.id
                AND s.semanticType = 'Clinical Drug')
GROUP BY c.id
HAVING COUNT(c.id) > 1;

  • multsty:concepts with more than 3 STYs|

    Code Block
      SELECT
    c.id
FROM
    concepts c,
    concepts_semantic_type_components cs,
    semantic_type_components s
WHERE
	c.id = cs.concepts_id AND
    cs.semanticTypes_id = s.id
GROUP BY c.id
HAVING count(c.id)>3

  • styisa:One STY is an ancestor of another in the STY isa hierarchy
     

  • sfo_lfo: Short form in one concept, long form in another
     

  • deleted_cui: CUIs that are going away - will need bequeathal rel

...