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

Gloss
tterm
, to the
Gloss
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 . The single keyword index represents the minimum necessary supporting structure for searches on content. Searches involving target words that appear in many 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 .
Gloss
tdescription
.

Note that some words that are used in

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.

...

Generating a single keyword index

Although single keyword indexes are available as part of the , developers need to know how to add keyword entries for any locally generated added as part of an .

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

For each

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



Anchor_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__6_c9c25d9f-bd3a-4d0b-9493-0607bb126c39__6Table 31. Sample Description

 

 

Term

Scg expression
ShowPartsid
22565018||

Scg expression
ShowPartsid
13185000|Pyrogallol

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

    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

    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.




KeyWord

Gloss
tDescription Identifier

PYROGALL

22565018

OXYGENAS

22565018

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
.

...



...

 

...

 

...

 

...

Count

...

Term

...

1

...

Scg expression
ShowPartsid
49926016||

...

Scg expression
ShowPartsid
29836001|Hip region structure (body structure)|

...

ShowPartsterm

Count

Gloss
tDescription Identifier

Gloss
tConcept Identifier

Term

1

Concept
t49926016||

Concept
t29836001|Hip region structure (body structure)|

Concept
t29836001|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.

...




...

 

...

 

...

 

...

Count

...

Term

...

1

...

Scg expression
ShowPartsid
1480791012||

...

Scg expression
ShowPartsid
386649003|Partial hip replacement by prosthesis (procedure)|

...

Scg expression
ShowPartsterm
386649003|partial hip replacement by prosthesis|

...

2

...

Scg expression
ShowPartsid
33592011||

...

Scg expression
ShowPartsid
19954002|Reconstruction of hip with use of methyl methacrylate (procedure)|

...

Scg expression
ShowPartsterm
33592011|total replacement of hip with use of methyl methacrylate|

...

3

...

Scg expression
ShowPartsid
50150016||

...

Scg expression
ShowPartsid
29969002|Replacement of acetabulum of hip (procedure)|

...

Scg expression
ShowPartsterm
50150016|replacement of acetabulum of hip|

...

4

...

Scg expression
ShowPartsid
54398014||

...

Scg expression
ShowPartsid
32581000|Partial hip replacement by cup with acetabuloplasty (procedure)|

...

ShowPartsterm

...

Count

Gloss
tDescription Identifier

Gloss
tConcept Identifier

Term

1

Concept
t1480791012||

Concept
t386649003|Partial hip replacement by prosthesis (procedure)|

Concept
t386649003|partial hip replacement by prosthesis|

2

Concept
t33592011||

Concept
t19954002|Reconstruction of hip with use of methyl methacrylate (procedure)|

Concept
t33592011|total replacement of hip with use of methyl methacrylate|

3

Concept
t50150016||

Concept
t29969002|Replacement of acetabulum of hip (procedure)|

Concept
t50150016|replacement of acetabulum of hip|

4

Concept
t54398014||

Concept
t32581000|Partial hip replacement by cup with acetabuloplasty (procedure)|

Concept
t54398014|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|