(ii) availability of services, bookings, etc. are
dynamic data, i.e. they are time-varying by
nature;
3.2 Database Layer: the Hybrid LDAP-
SQL System
These requirements suggest the use of a hybrid
database structure for data storage: an LDAP
directory service [Yeong et al, 1995, Howes et al,
2003, Kandlur et al, 1998] for static data and a
relational DBMS for dynamic information.
LDAP (Lightweight Directory Access Protocol)
provides both a modelling and an implementation
tool, it is used in a wide number of applications,
including enterprise databases and network
configuration. LDAP is highly indicated for Internet
applications, both from the data representation
viewpoint and for an efficient access. Furthermore, it
is scalable, extendable and optimised for reading
operations, so it is particularly suitable for static
data. It also supports standards and interfaces of
many multimedia broadband applications, as well as
integrated access to services.
Another important feature is that the LDAP data
model uses a hierarchy of classes, each class
described by single-valued or multi-valued
attributes. This tree structure allows to organise and
navigate data in a very efficient, simple and user-
friendly way. Furthermore, LDAP schemes can be
very easily modified and extended in order to add
new attributes and new classes. Such operations, in
contrast, would be very time-consuming if
traditional database systems were used.
This feature can be very useful when designing
EHRs: as a matter of fact, new objects and new
attributes are very likely to be modified or added,
due to new needs, experiences or improvements
made by the people who are developing them.
Finally, LDAP was built for the integration of
distributed environments, so it suits the distributed
location of medical material and patients’ histories
very well.
As far as the dynamic part of the database is
concerned, it mainly concerns the time-varying
information. In more detail, the dynamic database
stores data about services, their scheduling,
bookings, etc. In this case, an SQL database is more
suitable. As a matter of fact, such models are
optimised for reading/writing operations and time-
varying data. The connection between the LDAP
and the SQL databases are LDAP object identifiers
which, used as user identifiers, guide the joint
navigation of LDAP and SQL data.
3.3 LDAP Schema for EHRs
The approach sketched in 3.1 can be formalised by
means of the LDAP tree structure in Fig. 4, where an
EHR is defined by means of the following hierarchy.
The 0-level class describes the EHR in general and
addresses all its items, such as different
examinations. This class stores the EHR identifier,
the data source of each item (e.g.: the database of
another hospital from which an examination comes
from) and dimension of the component in KB (e.g.:
dimension of an X-ray image).
The 1-level classes are demographics and
medical data.
The former stores the patient’s name, contacts and
similar data.
The latter is defined by the following attributes: type
of data, description, date, physician, paramedic,
technician. A possible instance is: (examination,
chest X-ray, June 24
th
2008, Dr Robert Hill, --, Mr
John Green), meaning that the information concerns
a chest X-ray examination made on June 24
th
2008,
prescribed by Dr Robert Hill and made by the
technician Mr John Green.
The medical data class has as many subclasses as
the types of medical information in EHRs. In
particular: medical parameters, such as blood group;
first aid parameters, such as the list of allergies; data
about past and current assistance, such as symptoms,
diagnosis and prescriptions.
Further subclasses are examinations and operation,
here represented as a single class. By means of the
subclasses text result and images, results of
examinations and operations are stored in text
format and images, if available.
For instance, the examination class, which inherits
all the attributes of the parent classes, has two
subclasses text results and image result. Possible
instances of such subclasses are (fracture of the first
and second ribs) and the available images
respectively. A further subclass other was defined in
case other data were needed.
3.4 SQL Schema for Accessing Services
Even if this issue is not the focus of the work, the
main objects that must be represented in the
dynamical part of the database are services, their
availability and their booking. Roughly speaking,
this means representing four classes of information:
DIFFERENTIATED ACCESS TO EHRS FROM EMERGENCY MOBILE UNITS, CONSULTING ROOMS AND
HOSPITALS
241