SNOB - A SNOMED Browser

Source code

The TCM was constructed within a mySQL environment, using mySQL server 5.1.23-rc-community and mySQL Query Browser 1.2.12.

The source code comprises a set of SQL script files all but one of which defines one or more stored procedures. These stored procedures are executed from a build script TCM-BuildTCM.sql which may also be edited to alter the two build configuration parameters, whose purpose and value range is documented in that build script.

The ‘Small’ configuration build script takes less than a minute to execute. The ‘Large’ configuration takes around 50 minutes, and ‘Huge’ correspondingly still longer. Most of the build time is spent generating Verhoeff check IDs; the underlying code has not yet been optimised to avoid regenerating check IDs more than once for the same entity if it appears more than once in the tables. The ‘Small’ configuration is probably sufficient for almost all use cases.