UMLS Database Query Diagrams:
How to perform searches for content view metadata concepts

This diagram shows how to perform searches for content view metadata concepts. Content views are pre-computed subsets of the UMLS that are useful for specific purposes. Each content view contained within the UMLS is also represented as a concept in the UMLS. These concepts contain atoms with SAB = 'MTH' and TTY = 'CV'. The STR of the CV atom is the "name" of the content view. These atoms are associated with a variety of attributes (found in MRSAT.RRF) that provide the content view metadata.

Corresponding Oracle Queries:

1. Find atoms of MetaMap NLP View content view concept.

SELECT * FROM mrconso
WHERE sab = 'MTH'
     AND tty = 'CV'
     AND str = 'MetaMap NLP View';

2. Find semantic type of MetaMap NLP View content view concept.
The join on MRCONSO.RRF is not necessary, but it provides access to fields of the atom that may be useful.

SELECT * FROM mrconso a, mrsty b
WHERE a.sab = 'MTH'
     AND a.tty = 'CV'
     AND a.str = 'MetaMap NLP View'
     AND a.cui = b.cui;

3. Find attributes of MetaMap NLP View content view concept.
The join on MRCONSO.RRF is not necessary, but it provides access to fields of the atom that may be useful.

SELECT * FROM mrconso a, mrsat b
WHERE a.sab = 'MTH'
     AND a.tty = 'CV'
     AND a.str = 'MetaMap NLP View'
     AND a.cui = b.cui;

4. Find atoms that are members of the MetaMap NLP content view (using CV_CODE attribute).

SELECT c.* FROM mrconso a, mrsat b, mrconso c
WHERE a.sab = 'MTH'
     AND a.tty = 'CV'
     AND a.str = 'MetaMap NLP View'
     AND a.cui = b.cui
     AND b.atn = 'CV_CODE'
     AND BITAND(c.cvf,to_number(b.atv)) != 0;

Last Reviewed: July 29, 2016