Clinical Database Design and Implementation with openEHR

Objective

The central objective of this course is to shorten the gap between the openEHR specifications and their implementation, specifically in the area of clinical data storage and retrieval, using concrete database technologies. Upon completing the course, the student will have performed implementation tasks and will have a thorough understanding of the main challenges, best practices and solutions to some common problems when implementing the openEHR standard.

Why is it needed?

Clinical databases are complex to design and difficult to implement. The challenge increases when these databases must contemplate standards, be generic, consistent and of high quality. These elements will enable the interoperability of systems and the information they manage.

The openEHR standard offers specifications for good clinical documentation models, well organized and extremely flexible, but does not offer any recommendations for implementing the standard at the database level. This is the main reason we designed this course, to fill that gap.

We have more than 20 years of experience working with openEHR, and we designed the first open clinical data repository based on openEHR. We have channeled all our experience into this course, unique in the world.

Who is it for?

The course is aimed at IT professionals and students: software architects, programmers, database administrators, technical leads, among others. Clinical professionals with some background in programming languages and databases can also take the course without problems.

Knowledge of a programming language is recommended (Java/Groovy will be used as reference languages), relational databases and SQL.

Certification

PARTICIPATION certificates will be issued to all students enrolled in the course.

COMPLETION certificates will be issued to those who complete practical tasks and have an evaluation score above 6/10.

Modules

Introduction

• Clinical data, requirements and uses
• Clinical record structure
• openEHR information model: data and metadata

Design and Implementation

• Database implementation technologies
• openEHR implementation techniques at the database level

Archetypes and Templates

• Using openEHR archetypes and templates in software
• Data validation

Advanced concepts

• Indexing, versioning, auditing, synchronization, ETL

Related courses

• openEHR Master Class
• openEHR Fundamentals and Implementation
• Health Information Systems Implementation with openEHR
• EHRServer Implementation and Management Workshop