SNOMED CT Languages Project Group

Space shortcuts

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Linda Bird

Saved on

compared with

New Version Current

changes.mady.by.user Michael Lawley

Saved on

Key

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

Date & Time

20:00 UTC Wednesday 9th May 2018

Teleconference Details

To join the meeting please go to https://snomed.zoom.us/j/471420169. 

Further information can be found at SLPG meeting information

Goals

  • Progress SNOMED Query language
  • Future goals: 
    • Transitive relationships in ECL
    • Ability to execute maps from within ECL
    • URI standard

Attendees 

Apologies


Agenda and Meeting Notes

Advanced Tables - Table Plus
border2
rowStylesbackground-color:#ccccff;font-weight:bold;,background-color:"#eeeeff";font-weight:normal;,background-color:#eeffff;font-weight:normal;
autoNumberSorttrue
autoNumbertrue
enableSortingfalse


Description
Owner
Notes

Welcome and apologies

Linda Bird


Query Language
- Recap from previous meetings

Linda Bird

Examples: version and language

Notes

    • Allow nested where, version, language
    • Scope of variables is inner query


Examples: where

Notes

      • Allow nested variable definitions, but recommend that people don't due to readability
      • Scope of variables is the inner query
      • No recursion e.g X WHERE X = 1234 MINUS X
        • ie can't use a variable in its own definition
        • ie X is only known on the left of the corresponding WHERE, and not on the right of the WHERE
Filters for Lexical Searching


Linda Bird

What filter keywords will we introduce for Term-based searching, and what are their exact meanings?

  • D.term
    • D.term = "*heart*"
    • D.term = wild:"*heart*"
    • D.term = regex:".*heart.*"
    • D.term = match:"hear att"
    • D.term = (sv) wild: "*heart*"
  • D.languageCode
    • D.languageCode = "en"
    • D.languageCode = "es"
  • D.caseSignificanceId
    • D.caseSignificanceId = 900000000000448009 |entire term case insensitive|
    • D.caseSignificanceId = 900000000000017005 |entire term case sensitive|
    • D.caseSignificanceId = 900000000000020002 |only initial character case insensitive|
  • D.caseSignificance
    • D.caseSignificance = "insensitive"
    • D.caseSignificance = "sensitive"
    • D.caseSignificance = "initialCharInsensitive"
  • D.typeId
    • D.typeId = 900000000000003001 |fully specified name|
    • D.typeId = 900000000000013009 |synonym|
    • D.typeId = 900000000000550004 |definition|
  • D.type
    • D.type = "FSN"
    • D.type = "fullySpecifiedName"
    • D.type = "synonym"
    • D.type = "textDefinition"
  • D.acceptabilityId
    • D.acceptabilityId = 900000000000549004 |acceptable|
    • D.acceptabilityId = 900000000000548007 |preferred|
  • D.acceptability
    • D.acceptability = "acceptable"
    • D.acceptability = "preferred"

Additional Syntactic Sugar

  • FSNpreferredSynonym *
    • preferredSynonym FSN = "*heart"
      • D.term = "*heart", D.type = "
      synonym", D.acceptability = "preferred
      • FSN"
      • D.term = "*heart", D.typeId =
      900000000000013009
      • 900000000000003001 |
      synonym|, D.acceptabilityId = 900000000000548007 |preferred|
    preferredFSN
      • fully specified name|
    • FSN preferredFSN = "*heart" LANGUAGE X
      • D.term = "*heart", D.type = "FSN", D.acceptability =
      "preferred"
      • *
      • D.term = "*heart", D.typeId = 900000000000003001 |fully specified name|,
      D.
      • acceptabilityId =
      900000000000548007 |preferred|
      • *
  • synonym
    • synonym
    preferredTextDefinition
    • preferredTextDefinition = "*heart"
      • D.term = "*heart", D.type = "
      TextDefinition", D.acceptability = "preferred"
      • synonym"
      • D.term = "*heart", D.typeId =
      900000000000550004
      • 900000000000013009 |
      definition|, D.acceptabilityId = 900000000000548007 |preferred|
    acceptableSynonym *
      • synonym|
    • synonym
    • acceptableSynonym = "*heart" LANGUAGE X
      • D.term = "*heart", D.type = "synonym", D.acceptability =
      "acceptable"
      • *
      • D.term = "*heart", D.typeId = 900000000000013009 |synonym|, (D.acceptabilityId = 900000000000549004 |acceptable| OR D.acceptabilityId = 900000000000548007 |preferred|)
    acceptableFSN *
  • synonymOrFSNacceptableTextDefinition
    • acceptableTextDefinition = "*heart*"
    • acceptableFSN synonym = "*heart*"
    • D.term = "*heart", D.type = "FSN", D.acceptability = "acceptable"
    • D.term = "*heart", D.typeId = 900000000000003001 |fully specified name|, D.acceptabilityId = 900000000000549004 |acceptable|
    • " OR FSN = "*heart"
          • D.term = "*heart", (D.type = "
          TextDefinition
          • synonym"
          ,
          • OR D.
          acceptability
          • type = "
          acceptable
          • fullySpecifiedName")
          D.term
        • synonym = "*heart" , D.typeId = 900000000000550004 |definition|, D.acceptabilityId = 900000000000549004 |acceptable|
        FSN ? (ie preferredOrAcceptableFSN)
        • OR FSN = "*heart" LANGUAGE X
          • D.term = "*heart", (D.type = "
          FSN", (D.acceptability = "acceptable
          • synonym" OR D.
          acceptability
          • type = "
          preferred
          • fullySpecifiedName")

          • , D.
          term
          • acceptability =
          "
          • *
          heart", D.typeId = 900000000000003001 |fully specified name|, (D.acceptabilityId = 900000000000549004 |acceptable| OR D.acceptabilityId = 900000000000548007 |preferred|)
        synonym ? (ie preferredOrAcceptableSynonym)

      • textDefinition
        • textDefinition synonym = "*heart"
          • D.term = "*heart", D.type = "
          synonym", (D.acceptability = "acceptable" OR D.acceptability = "preferred")
          • definition"
          • D.term = "*heart", D.typeId =
          900000000000013009
          • 900000000000550004 |
          synonym|, (D.acceptabilityId = 900000000000549004 |acceptable| OR D.acceptabilityId = 900000000000548007 |preferred|)
        TextDefinition ? (ie preferredOrAcceptableTextDefinition)
          • definition|
        • textDefinition = "*heart" LANGUAGE X
          • D.term = "*heart", D.type = "definition",
          (
          • D.acceptability =
          "acceptable" OR D.acceptability = "preferred")
          • *
          • D.term = "*heart", D.typeId = 900000000000550004 |definition|,
          (
          • D.acceptabilityId =
          900000000000549004 |acceptable| OR D.acceptabilityId = 900000000000548007 |preferred|)
          • *
      • Unacceptable Terms
        • (D.
        Term ? (ie preferredOrAcceptableTerm)
        • term = "*heart" LANGUAGE900000000000508004 |GB English|) MINUS (D.term = "*heart", (D.acceptability = "acceptable" OR D.acceptability = "preferred") LANGUAGE 900000000000508004 |GB English|
          D.term = "*heart", (D.acceptabilityId = 900000000000549004 |acceptable| OR D.acceptabilityId = 900000000000548007 |preferred|) LANGUAGE900000000000508004 |GB English|X)
    Query Language - Combining language reference sets

    Linda Bird

    How do we support language preferences, which are defined over multiple language reference sets? For example:

    • Suggestion: Use '+' to indicate additive (except for PT), and ',' to indicate priority order (with concept-level override). For example:

      • LANGUAGE 999001891000000105 |Paediatric neurodisability outpatient diagnosis language reference set| , 900000000000508004 |GB English|

        • Priority order: This means that if a concept has descriptions in the Paediatric LRS, then this LRS is used. But if a concept has no descriptions in the Paediatric LRS, then GB English is used

      • LANGUAGE 999001881000000108|GB clinical extension LRS| + 900000000000508004 |GB English|
        • Additive: This means that if a concept has a PT in both LRSs, then the PTs in the Paediatric LRS take priority, and the PT in the GB English LRS becomes acceptable. Other terms are acceptable if they are acceptable in either LRS.
      • LANGUAGE 999001891000000105 |Paediatric neurodisability outpatient diagnosis language reference set| ,
        999001881000000108|GB clinical extension LRS| + 900000000000508004 |GB English|
        • Priority order and Additive: This means that if a concept has a PT in both LRSs, then the PTs in the Paediatric LRS take priority, and the PT in the GB English LRS becomes acceptable. Other terms are acceptable if they are acceptable in either LRS.
    Other topics

    Linda Bird

    Other topics for discussion. For example:

    • Query language - Can we de-scope relationship filters?
    • URI standard - Any updates on the purpose of SNOMED computable language URIs?
    • ECL suggestions - Ability to execute maps in ECL
      • The specific use-case here comes initially from Jeremy and relates to being able to work with inactive concepts via the historical association maps. For example, given an ECL expression, e, that identifies a set of concepts to be used for retrieving patient records, you probably also want to retrieve records for sameAs(e) and replacedWith(e)
    Confirm next meeting date/time
    Linda Bird

    The next SLPG meeting will be held in 2 weeks at 20:00 UTC on Wednesday 23rd May. Topics for next meeting?


    Attachments