This 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. The guide 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 this document 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. For more scalable and performant approaches to implementing SNOMED CT please visit SNOMED International's Github repository - e.g. https://github.com/IHTSDO.
Web browsable version: http://snomed.org/sqlpg
SNOMED CT Document Library: http://snomed.org/doc
© Copyright 2024 International Health Terminology Standards Development Organisation, all rights reserved. This document is a publication of International Health Terminology Standards Development Organisation, trading as SNOMED International. SNOMED International owns and maintains SNOMED CT®. Any modification of this document (including without limitation the removal or modification of this notice) is prohibited without the express written permission of SNOMED International. This document may be subject to updates. Always use the latest version of this document published by SNOMED International. This can be viewed online and downloaded by following the links on the front page or cover of this document. SNOMED®, SNOMED CT® and IHTSDO® are registered trademarks of International Health Terminology Standards Development Organisation. SNOMED CT® licensing information is available at http://snomed.org/licensing. For more information about SNOMED International and SNOMED International Membership, please refer to http://www.snomed.org or contact us at info@snomed.org. |
Latest PDF Version for Download: | Note This PDF document was generated from the web version on . Any changes made to the web pages since this date will not appear in the PDF. For information about recent changes please see Recent Updates. |
Search this document
Contents
1. Introduction
2. Objectives, Audiences and Uses
3. SNOMED CT Example Database
4. Database Design
- 4.1. Essential Reference Information
- 4.2. Release Type Options
- 4.3. Data Type Options
- 4.4. Database Table Naming
- 4.5. Database Table Design
- 4.6. Enabling Versioned Views
- 4.7. Enabling Subtype Testing
- 4.8. Composite Views
- 4.9. Stored Procedures
5. Creating and Populating a SNOMED CT Database
- 5.1. Creating the Database
- 5.2. Creating Tables for Components
- 5.3. Creating Tables for Reference Sets
- 5.4. Importing Release Files
Appendix A: Building the SNOMED CT Example Database
- A.1 Download the SNOMED CT Example Database Package
- A.2 Download the Release File Package
- A.3 Instructions for Mac OS Users
- A.4 Instructions for Windows Users
- A.5 Using MySQL Workbench to Query SNOMED CT
- A.6 Overview of the SNOMED CT MySQL Database
- A.7 MySQL Reference Data
Appendix B: Obtaining SNOMED CT Release Files
Appendix C: Release Types and Versioned Views
- C.1. Practical Uses for Versioned Views
- C.2. Release Type Support for Versioned Views
- C.3. Common Mistakes with Snapshot Generation
Previous Versions
Recent Updates
Feedback
Overview
Content Tools
Apps