Computer Science – Databases
Scientific paper
2010-03-17
Computer Science
Databases
12 pages, 9 figures, 6 tables
Scientific paper
The HL7 standard is widely used to exchange medical information electronically. As a part of the standard, HL7 defines scalar communication data types like physical quantity, point in time and concept descriptor but also complex types such as interval types, collection types and probabilistic types. Typical HL7 applications will store their communications in a database, resulting in a translation from HL7 concepts and types into database types. Since the data types were not designed to be implemented in a relational database server, this transition is cumbersome and fraught with programmer error. The purpose of this paper is two fold. First we analyze the HL7 version 3 data type definitions and define a number of conditions that must be met, for the data type to be suitable for implementation in a relational database. As a result of this analysis we describe a number of possible improvements in the HL7 specification. Second we describe an implementation in the PostgreSQL database server and show that the database server can effectively execute scientific calculations with units of measure, supports a large number of operations on time points and intervals, and can perform operations that are akin to a medical terminology server. Experiments on synthetic data show that the user defined types perform better than an implementation that uses only standard data types from the database server.
Dijkstra Willem
Havinga Yeb
Keijzer Ander de
No associations
LandOfFree
Adding HL7 version 3 data types to PostgreSQL does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Adding HL7 version 3 data types to PostgreSQL, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Adding HL7 version 3 data types to PostgreSQL will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-234128