Performance of XML Databases for Epidemiological Queries in Archetype-Based EHRs

Freire, Sergio MirandaLinköpings universitet,Medicinsk informatik,Tekniska högskolan (författare)

There are very few published studies regarding the performance of persistence mechanisms for systems that use the openEHR multi level modelling approach. This paper addresses the performance and size of XML databases that store openEHR compliant documents. Database size and response times to epidemiological queries are described. An anonymized relational epidemiology database and associated epidemiological queries were used to generate openEHR XML documents that were stored and queried in four opensource XML databases. The XML databases were considerably slower and required much more space than the relational database. For population-wide epidemiological queries the response times scaled in order of magnitude at the same rate as the number of records (total database size) but were orders of magnitude slower than the original relational database. For individual focused clinical queries where patient ID was specified the response times were acceptable. This study suggests that the tested XML database configurations without further optimizations are not suitable as persistence mechanisms for openEHR-based systems in production if population-wide ad hoc querying is needed.

Sundvall, Erik,1973-Linköpings universitet,Medicinsk informatik,Tekniska högskolan(Swepub:liu)erisu87 (författare)
Karlsson, DanielLinköpings universitet,Medicinsk informatik,Tekniska högskolan(Swepub:liu)danka74 (författare)
Lambrix, PatrickLinköpings universitet,Databas och informationsteknik,Tekniska högskolan,IDA/ADIT(Swepub:liu)patla00 (författare)
Linköpings universitetMedicinsk informatik (creator_code:org_t)

Ingår i:Proceedings Scandinavian Conference on Health Informatics 2012Linköping : Linköping University Electronic Press, s. 51-579789175197586

Av författaren/redakt...: Freire, Sergio M ...; Sundvall, Erik, ...; Karlsson, Daniel; Lambrix, Patrick

Om ämnet

Kungliga biblioteket hanterar dina personuppgifter i enlighet med EU:s dataskyddsförordning (2018), GDPR. Läs mer om hur det funkar här.
Så här hanterar KB dina uppgifter vid användning av denna tjänst.