SNOMED Documentation Search


 Other Documents

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titleNote

This page contains some advice on generating simple index tables. However, please note the wide availability of open source search tools and search capabilities built into databases makes this advice less relevant than it was when originally issued.

The idea of a single keyword table, (DescWordKey), provides keyword index, is to provide a pointer from each keyword used word used in any

glossary-ref
Gloss
Description
tterm
, to the glossary-ref
Gloss
Descriptions
tdescriptions
in which that keyword
Specref
RefTypefield
tKeyword
is used. The purpose of the single keyword index is to support This support a search capability, which is independent of the order in order in which words appear in a glossary-ref
Gloss
tdescription
. The single keyword index represents the minimum necessary supporting structure for searches on Glossary ref
SNOMED CT
content. Searches involving target words that appear in many
Glossary ref
descriptions
may be unacceptably slow if searches are carried out using the single keyword index alone. Developers wishing to produce applications with faster search times are encouraged to supplement their system with a multiple keyword index such the DescDualkey table (see Word Search Tables) provided as part of the
Glossary ref
SNOMED CT release
.

Note that some words that are used in

glossary-ref
Gloss
tdescription
are linking words, which are unlikely to be in the target of a search. These words are not considered to be keywords and may be can be excluded from the a keyword index. They are found in Excluded Words File.

...

Although single keyword indexes are available as part of the

Glossary ref
International Release
, developers need to know how to add keyword entries for any locally generated
Glossary ref
descriptions
added as part of an
Glossary ref
Extension
.

Generating a single keyword index

Entries may be added to the single keyword table index table by following the method outlined below.

For each

glossary-ref
Gloss
tdescription
, parse the text of the
Specref
RefTypefield
tterm
:

  • To avoid inappropriate case mismatches, convert all characters to the same case.
  • Extract words by breaking at spaces, punctuation marks, and brackets.
  • For each word:
    • If the word is not in a list of excluded words, add words add a row to keyword tableindex table.

...

Example: Generation of keywords for a sample Description

...

 

...

 

...

Glossary ref
Description Identifier

...

Glossary ref
Concept Identifier

...

Term

...

Scg expression
ShowPartsid
22565018||

...

ShowPartsid

...

Caption table
Sample Description



Gloss
tDescription Identifier

Gloss
tConcept Identifier

Term

22565018

Concept
t13185000|Pyrogallol 1,2-oxygenase

(substance)|

scg-expression

Concept

ShowParts

t

term

22565018|pyrogallol

1,2-oxygenase|

Convert all characters to the same case.

scg-expression

Concept
ShowParts
t
term
22565018|pyrogallol
1,2-oxygenase|
-> "PYROGALLOL 1,2-OXYGENASE"

Extract words by breaking at spaces, punctuation marks, and brackets.

"PYROGALLOL 1,2-OXYGENASE" -> '

(1) = "PYROGALLOL"

(2) = "1"

(3) = "2"

(4) = "OXYGENASE"

For each word

...

...

If the word is not in a list of excluded words, and length of word > 1, and first character is not numeric:

  • Add a row to keyword tables; Only the first eight characters are used in the keyword . Anchor_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__e_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__eTable 32. DescKey Words

     

     

    KeyWord

    Glossary ref
    Description Identifier

    PYROGALL

    Scg expression
    ShowPartsid
    22565018||

    OXYGENAS

    Scg expression
    ShowPartsid
    22565018||

    Anchor_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__7_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__7Table 33. ConcKeyWords

     

     

    KeyWord

    Glossary ref
    Concept Identifier

    PYROGALL

    Scg expression
    ShowPartsid
    13185000|Pyrogallol 1,2-oxygenase the keyword index table pointing from that word to the relevant description or concept identifier.

Options

  • Keyword length limits - It may be useful to limit the length or the key to a maximum number of characters as shown in the tables below

Index target - An index pointing to a 

Gloss
tdescription Identifier
 is useful as it allows the matching description to be displayed. However, an index pointing to the concept identif 
Gloss
tconcept Identifier
 may make it easier to exclude multiple matching terms that point to the same concept.


Caption table
Single Word Index of Descriptions (limited to 8 characters in length)



KeyWord

Gloss
tDescription Identifier

PYROGALL

22565018

OXYGENAS

22565018

Caption table
Single Word Index of Concepts (limited to 8 characters in length)

KeyWord

Gloss
tConcept Identifier

PYROGALL

Concept
ShowPartsid
t13185000|Pyrogallol 1,2-oxygenase (substance)|

OXYGENAS

...

Concept
ShowPartsid
t13185000|Pyrogallol

...

1,2-oxygenase

...

(substance)|

...


...

Search using the single keyword index

A single keyword search may be conducted as follows:

  • The user-typed search string is string is converted to consistent case;
  • The string is string is parsed, breaking at spaces and punctuation characters;
  • One word is selected from the parsed word list to use as a look-up on the single keyword indexkeyword index;
  • Look-up Lookup on the single keyword index keyword index may be "exact" or "starts with," depending on wild card conventions used in the search string .

...

  • ;
    • Ideally this index search should be use the keyword with least matches in the index;
  • In the resulting list of descriptions containing matches look for matches with the other words in the search string.

Example: Search using single

...

keyword index

The user searches for "Hip* replacement*" (where "*" represents the wild card for any number of extra characters).

  • The user-typed search string is string is converted to consistent case.

"Hip* replacement" -> "HIP* REPLACEMENT*"

  • The string is string is parsed, breaking at spaces and punctuation characters.

"HIP* REPLACEMENT*" ->

(1) "HIP*"

(2) "REPLACEMENT*"

Look up "HIP" on the single

...

Specref
RefTypefield
tKeyword
index using "starts with"
Specref
RefTypefield
tquery
.

...

Caption table
Example results for a Search for "hip"

...



Count

...

Count

...

Glossary ref
Description Identifier

...

Gloss

...

 

tDescription Identifier

Gloss
tConcept Identifier

Term

1

...

Concept

...

t

...

49926016||

...

Concept

...

t

...

29836001|Hip

...

region

...

structure

...

(body

...

structure)|

...

Concept

...

t

...

29836001|hip|

2

...

Concept

...

t

...

196344018||

...

Concept

...

t

...

24136001|Hip

...

joint

...

structure

...

(body

...

structure)|

...

Concept

...

t

...

196344018|hip|

3

...

Concept

...

t

...

2296013||

...

Concept

...

t

...

736004|Abscess

...

of

...

hip

...

(disorder)|

...

Concept

...

t

...

736004|abscess

...

of

...

hip|

4

...

Concept

...

t

...

1480791012||

...

Concept

...

t

...

386649003|Partial

...

hip

...

replacement

...

by

...

prosthesis

...

(procedure)|

...

Concept

...

t

...

1480791012|partial

...

hip

...

replacement

...

by

...

prosthesis|

. . . . .

. . . . . . . . . . . . .

. . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . .

315

...

Concept

...

t

...

371616001|Methenamine

...

hippurate

...

1g

...

tablet

...

(product)|

...

Concept

...

t

...

1210239015||

...

Concept

...

t

...

1210239015|methenamine

...

hippurate

...

1g

...

tablet|

...

Gloss
tDescriptions
in the search results are converted to consistent case and screened, to see if they contain any words starting with "REPLACEMENT" - only those terms that do are included in the final search results.
Using a

...

Gloss
tDual

...

Key
index is more efficient as the same search finds only 11 matches.

...


...

Caption table
Sample results of a search for "hip replacement" using DualKey "HIPREP"

...



Count

...

Count

...

Glossary ref
Description Identifier

...

Gloss

...

 

tDescription Identifier

Gloss
tConcept Identifier

Term

1

...

Concept

...

t

...

1480791012||

...

Concept

...

t

...

386649003|Partial

...

hip

...

replacement

...

by

...

prosthesis

...

(procedure)|

...

Concept

...

t

...

386649003|partial

...

hip

...

replacement

...

by

...

prosthesis|

2

...

Concept

...

t

...

33592011||

...

Concept

...

t

...

19954002|Reconstruction

...

of

...

hip

...

with

...

use

...

of

...

methyl

...

methacrylate

...

(procedure)|

...

Concept

...

t

...

33592011|total

...

replacement

...

of

...

hip

...

with

...

use

...

of

...

methyl

...

methacrylate|

3

...

Concept

...

t

...

50150016||

...

Concept

...

t

...

29969002|Replacement

...

of

...

acetabulum

...

of

...

hip

...

(procedure)|

...

Concept

...

t

...

50150016|replacement

...

of

...

acetabulum

...

of

...

hip|

4

...

Concept

...

t

...

54398014||

...

Concept

...

t

...

32581000|Partial

...

hip

...

replacement

...

by

...

cup

...

with

...

acetabuloplasty

...

(procedure)|

...

Concept

...

t

...

54398014|partial

...

hip

...

replacement

...

by

...

cup

...

with

...

acetabuloplasty|

. . . . .

. . . . . . . . . . . . . . . .

. . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . .

11

...

Concept

...

t

...

183737015||

...

Concept

...

t

...

112728000|Total

...

revision

...

of

...

hip

...

replacement

...

with

...

use

...

of

...

methyl

...

methacrylate

...

(procedure)|

...

Concept

...

t

...

183737015|total

...

revision

...

of

...

hip

...

replacement

...

with

...

use

...

of

...

methyl

...

methacrylate|