Search



Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
iconfalse
titleImportant Note

Transitive Closure Files are not distributed in the SNOMED CT International Release
The two file structures documented here are intended as points of reference for those generating transitive closure table from the release data. SNOMED International provides a script file that can be used to generating the first of these structure generate the Snapshot Transitive Closure file from the snapshot version of the Relationship File.


Theis the complete set ofbetween everyand The

Gloss
PreSpacefalse
tTransitive Closure
is the complete set of
Gloss
PreSpacefalse
trelationships
between every
Gloss
PreSpacefalse
tconcept
and each of its super-type
Gloss
PreSpacefalse
tconcepts
, in other words both its parents and
Gloss
PreSpacefalse
tancestors
.

A transitive closure table is one of the most efficient ways to test for subsumption between concepts.

Snapshot Transitive Closure File

SNOMED International provides an example of a Transitive Closure Perl script file (click to download)  that can be used to generating a snapshot view of the transitive closure from the snapshot release of the  relationship file

Specref
RefTypefile
tRelationship
. The output of this script conforms to the following following file structure. Note that the primary key for this table consists of both columns.

...

Field

...

Data type

...

Purpose

...

subtypeId

...

SCTID (data type)

...

Id of theplaying therole. Set to anof a.

...

Caption label
CapIdtransitive-closure-file-detailed-specification
CapTypeTable
Transitive Closure File - Detailed Specification

Bookmarked content insert
Startfilespec
PageREUSE:Transitive Closure Snapshot File

Scroll Pagebreak

...

supertypeId

...

SCTID (data type)

...

Id of theplaying the supertype role. Set to anof a.

...

Versioned Transitive Closure

A versioned view of thecan the

Gloss
PreSpacefalse
tTransitive Closure
can also be generated by combining the snapshot views for different effective times and removing redundant rows (e.g. where the transitive closure has not changed between release versions). The generated file could then be represented using the example specification below. Note that the unique key for this file would consist of the subtypeId, supertypeId and effectiveTime.

...

Field

...

Data type

...

Purpose

...

subtypeId

...

SCTID (data type)

...

Id of theplaying therole. Set to anof a.

...

supertypeId

...

SCTID (data type)

...

Id of theplaying the supertype role. Set to anof a.

...

YES

...

effectiveTime (field)

...

Time (data type)

...

Specifies the inclusive date at which therecord became valid.

...

active (field)

...

Boolean (data type)

...

Specifies whether theversion's state wasorfrom the point in time specified by the effectiveTime (field) .

...

Caption label
CapIdversioned-transitive-closure-file-example-specification
CapTypeTable
Versioned Transitive Closure File - Example Specification

Bookmarked content insert
Startfilespec
PageREUSE:Transitive Closure File

Related Links

Scroll Pagebreak