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: 2020-05-18 SEC call notes | ADL2

Outstanding issues

DV_EHR_URI analysis 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