Transcript Slide 1

RIMBAA Overview
Full source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
René Spronk
Trainer / Senior Consultant
Ringholm bv
Haarlem, the Netherlands
Tel.
Fax:
+31 (0)318 589 789
+31 (0)318 548 090
eMail: [email protected]
Web:
http://www.Ringholm.com
Twitter: @Ringholm
HL7/IHE roles:
•HL7 Fellow
•Co-chair of the international HL7 RIMBAA Working Group
•Co-chair of various Committees, HL7 Germany, HL7 Netherlands
•Member of HL7 UK, HL7 FR, HL7 CH, HL7 NO
•Contributor to the IHE Laboratory Technical Framework
•HL7 volunteer of the year - 2008
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
2
RIMBAA WG Activities
•
The International RIMBAA Work Group
1. Promotes RIMBAA architectures , and
2. Gathers, documents and publishes best
practices when it comes to the (model
driven) implementation of HL7 version 3
• Product presentations
• Open forum discussions
•
Page: http://wiki.hl7.org/index.php?title=RIMBAA
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Key Objectives



Understand some of the architectural
approaches and techniques for using the
HL7 RIM data model in clinical data
repositories
Show some of the ‘best practices’ collected
by the HL7 RIMBAA Workgroup
Note: interoperability is “out of scope” of this
presentation .. and “in scope” for RIMBAA
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
The HL7 RIM
Scope, Origins of the
Reference Information Model
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
RIM (1995-1999)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
6
7/17/2015
Sources of the RIM:
data(base) models
..and UK / Australian national healthcare data models.
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
7
7/17/2015
RIM (current version, 2001+)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
8
The RIM as a model for persistence

All healthcare domains can be represented
and integrated using one single ISO
standard information model (the RIM)


This means one does not have to develop and
support different databases and interfaces
between systems for different healthcare domains
RIM Based Application Architecture
(RIMBAA)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
RIM in UML
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
10
Essential components of the RIM
• Class Diagram
• Constraint Language
• State transition diagrams
• Definitions (classes, attributes, ..)
• Data type definitions
• Vocabularies (notably:structural vocabularies, e.g. ActClass)
Slide courtesy of Nicolas Canu (HL7 France)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Use of RIM (-based) models
Persistence
Layer
Other
RIM
Application
Object Layer
Interoperability
Paradigms
User Interfaces
Messages
RIM-based
Documents
Other
Other
RIM-based
RIMBAA
Services
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Application Layer
Full source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
RIM – Generated Code

RIM



State transitions


Constraint on RIM classes
Vocabulary definitions/bindings


MIF or XSD based class/code generators
Includes support for constraint language
Terminology Server functionality, CTS II
Data type

Custom library, partly XSD generated
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
14
01/01/2011
Constraint Language

To express additional constraints



OCL, ADL, Gello
No solution has been formally adopted
Typical (OCL) example:


The Person object should have either an id or a
name
context Person

inv: id.hasContent or name.hasContent
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
15
Data Types – custom code

Custom library with support for data types



Mostly: ISO data types, patched to support data
types R1 as well
Relationship with Terminology Server (C* data
types)
Needs custom coding: data types MIF is abstract.
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
16
MDD - Application Generation
Generic Software
Components
-Terminology
-Data types
Software
application
RIM
Persistence
Database
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
MDD –Prescription Example



RIM based
model for
Prescription
Business
workflow
Exchange
Pattern
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Software
application
Class Generators


Class generators – XML Schema driven

Every major development platform provides tools
to generate classes from XML Schemas

E.g. JAXB, .NET Framework/Mono (XSD.EXE), XML
Beans…
Class Generators – Model driven

Model Driven Software development
environments allow classes to be generated from
(UML-) models

E.g. MARC Everest API Generator (XML ITS/RIM
ITS), MDHT (for CDA)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Example: Philips Research (1/2)
application
HL7v3 Standard
MIF
ABCD HL7v3 Generator
object model
generator
object model
C#
generator
SQL
C#
XML
XSD



Object model of MIF was generated from the MIF schemas, including
read and write methods.
MIF files are read as instances of the MIF model and mapped to object
models.
Applications are built using C# classes generated from the object
models.
20
Example: Philips Research (2/2)
Object models generated from MIF:
Clinical
Statement
CMETs
R_Patient
Universal
R_Assigned
Entity
Universal
R_Assigned
Person
Identified
RIM
(2.26)
Datatypes
(R1)
Vocabulary
21
R_Medication
Universal
R_Specimen
Universal
…..
Persistence Layer
Full source: www.ringholm.com/download/ implementation_mechanics.ppt
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Database models (Relational)
RIM
RIM or RIM-based model:
Conceptual Data Model
LDM
Logical Data Model
•Not DBMS specific, no tables, no keys
ORM – Object Relational Mapping
PDM
Physical Data Model
•DBMS specific, tables, keys
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
23
Conceptual Data model - RIM

Enormous flexibility, at the cost of a very
abstract structure.


Low number of tables


makes enforcement of data integrity rules very difficult
making it necessary to rely on stored procedures and
application logic to enforce rules.
less programming work, easier to learn, easier to add new
functionality. More data in each table, need to tune queries.
Main use-case:

If you're creating a data store for ad-hoc queries,
mining and exploration of all sorts of data from all
sorts of different sources
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
24
RIM – Interoperability Focus

Data types





Defined for ‘worst case’ interoperabilty scenarios;
within one system this scenario doesn’t apply
HIST<X>; other means of supporting versioning
Normalization of data types
Context Conduction
RIM

Lacks certain classes for non-interoperability
settings; change proposals are being made
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
25
01/01/2011
OLTP versus OLAP

OLTP: Online Transaction Processing




Persists a “stack of messages”
Fast processing
Query processing requires plowing through a
series of relevant transactions
OLAP: Online Analytical Processing


Persists an object graph
Very flexible when it comes to querying
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
26
OLTP + OLAP
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
27
OLAP + Data mart / view model
User Interface
Commands
User Interface
Query
RIM Services
RIM
(OLAP)
Events
View Model
/Datamart
View Model
/Datamart
28
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Data Marts
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
29
Database Models

EAV (“RDF Triples”)


XML


Pure EAV considered to be too slow
Example implementation
RDBMS (ER)

Focus of the presentation
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
30
Example: RIM persistence OntoReason / MD Anderson
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
31
Example: IBM (1/2)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
32
Example: IBM (2/2)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
33
Example: UMCG –
RDBMS & XML
●
XML in column
●
(e.g. SQL-Server 2005)
With XPath
index columns
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Persistence Layer
Data Types
Full source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Hiding the complexities of the
persistence model

Goal: SQL that is based on ISO/R2 data
types, and more complex class structures

Object/Relational Mapping



Wrap database objects (tables, columns, fields…)
in OO classes
Examples: Hibernate (Java), nHibernate (.NET),
HyperJAXB, Jakarta OJB, JPOX
Type definitions in databases

User Defined Types (e.g. to hide data type
specifics)
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
UDT – Data Types


User Defined Types (at the DBMS level)
A form of ORM at the database level



Allows for the definition of CD with SNOMED
support, II with an OID check, or PQ with UCUM
validation.
Native support for HL7 datatypes in SQL.
Full nullFlavor support
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
37
UDT Example: PQ
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
38
UDT Example: IVL<PQ>
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
39
Summary
Full source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
Slide contents published under the Creative Commons / Attribute-Share Alike license
Source: www.ringholm.com/download/RIMBAA_overview_tutorial.ppt
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Who uses RIMBAA ?
•
Centralized archives with medical information (research/EHR)
•
•
•
•
•
•
Toolkits for application development
•
•
•
•
•
•
National Cancer Registry, USA
BioBank, UK
Philips Research, NL
CDC NEDDS, USA
DRV Bund, DE
PHI Technology, IT
MDHT, USA
MARC-HI Everest, CA
Oracle HTB, US
dbMotion, IL
HIS/PAS systems
•
•
•
•
Axolotl Elysium, USA
CSC Clinical Suite, DK
Siegele Software, AT
PCS, AT
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Summary

The RIM is appropriate as a persistence
model if there is a requirement for a generic
data model (research, EHRs)



Combine with views/datamarts for specific
domains or target audiences
Implementation of data types (library,
persistence) is key
MDD (Application Generation) based on
RIM-based models is definitely an option
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.
Any Questions ?
Or: post your question/suggestions via
•E-mail [email protected]
•Twitter: @Ringholm
HL7 and Health Level Seven are registered trademarks of Health Level Seven International. Reg. U.S. TM Office.