2020-11-02 SEC Meeting notes

5min

Opening

adding Kjetil Jørgensen (DIPS) as a new member of the openEHR SEC Expert group

10min

AQL: quick review issue list, progress

Sebastian Iancu

• QUERY Release 1.1.0

• see AQL Release-1.1.0 goals & requirements

45min

AQL: Cartesian product, permutation, etc

Refs:

• Discourse - simplest possible question

• Diego Bosca paper DETAILED CLINICAL MODELS AND THEIR RELATION WITH ELECTRONIC HEALTH RECORDS

Bjørn Næss Seref Arikan

• https://discourse.openehr.org/t/the-aql-cartesian-product-problem-specquery-9/1017

• Seref Arikan : need a semantics of query execution to solve this properly; SQL query semantics w.r.t. relational tables is definitive; doesn’t yet exist in AQL;

• Matija Polajnar : squash doesn’t solve everything; there is a rule for dealing with interior container objects (e.g. CLUSTER.items)

• Bjørn Næss : DIPS has a heuristic solution that handles some cases, e.g. the terminal ‘array of comments’ example.

• Seref Arikan (Personal) : one unique thing in AQL is that FROM predicates are not only filters, but can be used in the SELECT part - cf Xpath etc; other Q: is AQL its own thing, or can we consider it in a more general class of query language? BTW don’t forget the AND/OR question…

• Kjetil Jørgensen : agree with Seref Arikan - need an agreed execution algorithm.

AQL: functions

Sebastian Iancu

• Matija Polajnar ; funcs on server mainly to reduce data retrieved (i.e. reduce first)

• Seref Arikan , Bjørn Næss , Sebastian Iancu : stick to ‘classic’ style of 'FUNCNAME(args)', document in a self-standing way.

• Thomas Beale - could document function semantics by reference to Foundation / Base types that already exist.

• Erik Sundvall (@sundvall.org) - defined ‘core’ group of funcs, and progressively more sophisticated collections. Use these profiles in conformance claims (eventually).

• Seref Arikan : consider how Xpath, Xquery do functions.

If time permits

10min

BASE spec status

Thomas Beale

• BASE Release 1.2.0 status

• Propose to add Terminology_service - draft idea here.

10min

AM spec

Thomas Beale Pieter Bos

• ADL2/AOM2 1

• some note from teh past: https://openehr.atlassian.net/wiki/spaces/spec/pages/717651969/2020-05-18+SEC+call+notes#ADL2

Outstanding issues

DV_EHR_URI analysis https://openehr.atlassian.net/wiki/spaces/spec/pages/786956289/DV+EHR+URI-related+Issues

Serial data formats: https://specifications-test.openehr.org/releases/SM/latest/serial_data_formats.html

Integration package link to presentation

REST Release 1.1.0

View Entries, Problem Lists etc. Initial UML here.

Tags (RM 1.2.0)

ITS status: XML, JSON, BMM

Website: adding examples, type definitions/navigator

CDS-hooks