2018-01-31 - SLPG Meeting

Welcome and apologies

@Former user (Deleted)

Recent comments

@Former user (Deleted)

Michael: "How can I write an ECL expression to match attribute names - for example, list all the attribute names that are used by << 404684003 |Clinical finding|.

• Added to ECL future requirements page.

Daniel: "Query language and collation"

When specifying the lexical search type for term matching there is a need to specify the collation used, and to specify the default collation for the language in which the terms are to be matched are represented.

Examples based on mysql collation behavior:

"AAO" matches "ÅÄÖ" in utf8_generic_ci and utf8_unicode_ci (and utf8_german2_ci) but not in utf8_swedish_ci collation.

"Aåa" matches "aåa" in utf8_generic_ci and utf8_swedish_ci but not in utf8_bin collation (i.e. case insesitive vs. sensitive, sometimes you need case sensitivity when searching...).

Similar behavior can be implemented e.g. by java.text.Collator in java or by the collection.find() or cursor.collation() method in MongoDB.

• Action from last week: Is there a standard or generic approach to defining Collation behaviour?

• Using LET ... IN ...

  • (LET substrate = X IN *) MINUS (LET substrate = Y IN *)

  • LET X = (<< 1234 : 5678 = << 6547) IN X MINUS >! X

    • Find leaf nodes of X

  • (LET substrate = X IN << 12345) MINUS (LET substrate = Y IN << 12345)

URI Standard

@Former user (Deleted)

• SLPG to review proposed updates to SNOMED CT URI Standard

  • In particular, 2.9 URIs for Language Syntaxes and 2.9 URIs for Language Instances.

  • Suggestions on 2.7 Comparing URIs for Equality of Reference would also be appreciated

Query Language

@Former user (Deleted)

Outstanding questions about relationship filters

Outstanding questions about lexical filters

Confirm next meeting date/time

@Former user (Deleted)

Next meeting to be held at 20:00 UTC on Wednesday 14th February 2018