SNOMED CT - SQL Practical Guide

This user guide provides a simple and practical example of how a relational database can be used to enable effective access to the content and features of SNOMED CT. It includes tested SQL scripts for loading release files into a relational database, searching the terminology and querying the terminology for concepts that meet simple but useful constraints. The primary purpose of the guide is to enhance understanding of the logical design of SNOMED CT and to provide practical ways to access the key features of SNOMED CT in a widely understood programming language. More scalable and performant approaches to implementing SNOMED CT are available via SNOMED International's Github repository.

Main sections:

· Objectives, audiences and uses

· SNOMED CT example database

· Database design

· Creating and populating a SNOMED CT database

· Appendix A: Building the SNOMED CT example database

· Appendix B: Obtaining SNOMED CT release files

· Appendix C: Release types and versioned views

· Previous versions

· Recent updates