CODEWITHSUNDEEP
mysqlmedical
Brian Dolan
Brian Dolan

Reputation: 3136

NIH UMLS Data Model on MRREL

I am working with the Unified Medical Language System (UMLS) database within a local copy of MySQL. I am currently attempting to understand the data structures via this webpage: http://www.ncbi.nlm.nih.gov/books/NBK9685/

I am attempting to identify concepts in CUI2. However, I am confused by this result:

SELECT y.* FROM mrrel r INNER JOIN mrconso y ON r.cui2 = y.CUI;

Exactly 1 result. Rather than wildly speculate—is it my sql? is it an error on the tables? did I misunderstand the schema?—I would really appreciate some feedback from the UMLS community. How do I correctly link MRREL.cui2 to other tables within the database? Is there a COMPLETE data model published somewhere?

Thanks!

Upvotes: 1

Views: 738

Answers (1)

user3653270
user3653270

Reputation: 166

Brian,

Not knowing anything about how you created your subset, I modified your query a bit and ran it against a full Metathesaurus subset from the 2015AA release. SELECT count(DISTINCT y.cui) FROM mrrel r INNER JOIN mrconso y ON r.cui2 = y.CUI ; I got back 3074046 unique CUIs. Perhaps you can send me your mmsys.log file to make sure that your subset completed properly? Also, you can several ER diagrams and sample queries on our website that could help in understanding the RRF data model. Also, how many total rows are in your MRREL table?

Upvotes: 2

Related Questions