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 structures generate the Snapshot Transitive Closure file from the snapshot version of the Relationship File.


The

Gloss
SpacePreSpacetruefalse
tTransitive Closure
is the complete set of
Gloss
SpacePreSpacetruefalse
trelationships
between every
Gloss
SpacePreSpacetruefalse
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 

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.bookmarker

Caption label

...

Typestart
Namefilespec

...

Field

...

Data type

...

Purpose

...

subtypeId

...

Specref
RefType(data type)
tSCTID

...

Id of the

Gloss
Spacetrue
tconcept
playing the
Gloss
Spacetrue
tsubtype
role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

...

supertypeId

...

Specref
RefType(data type)
tSCTID

...

Id of the

Gloss
Spacetrue
tconcept
playing the supertype role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

...

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

Bookmarked content insert
Startfilespec
PageREUSE:Transitive Closure Snapshot File

Scroll Pagebreak

Bookmarker
Typeend
Namefilespec

Versioned Transitive Closure

A versioned view of the

Gloss
SpacePreSpacetruefalse
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

...

Specref
RefType(data type)
tSCTID

...

Id of the

Gloss
Spacetrue
tconcept
playing the
Gloss
Spacetrue
tsubtype
role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

...

supertypeId

...

Specref
RefType(data type)
tSCTID

...

Id of the

Gloss
Spacetrue
tconcept
playing the supertype role. Set to an
Gloss
Spacetrue
tIdentifier
of a
Gloss
tconcept
.

...

YES

...

Specref
RefType(field)
teffectiveTime

...

Specref
RefType(data type)
tTime

...

Specifies the inclusive date at which the

Gloss
Spacetrue
ttransitive closure
record was added or changed its active state.

...

Specref
RefType(field)
tactive

...

Specref
RefType(data type)
tBoolean

...

Specifies whether at the

Gloss
Spacetrue
ttransitive closure
represented by the subtypeId and supertypeId became valid
Gloss
Spacetrue
t(active)
or invalid
Gloss
Spacetrue
t(inactive)
from the point in time specified by the
Specref
RefType(field)
teffectiveTime
.

...

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