![](bg5.png)
time - before, during and after the event giving the
privileges (ZdUpr) for prescription. The prescription
for (ii) is the case when the medicine is prescribed
during the particular time depending on ZdUpr. An
ontology of the system for controlling the correctness
of medical procedures has been prepared in the TBC
editor and it is presented in Figure 2. The prepared
structure corresponds to structure organization cur-
rently used in the NHF data sources.
4 ANALYSIS OF MEDICAL
PROCEDURES USING SPARQL
AND SPIN IN THE
CONTROLLING SYSTEM
UNITS
Defined inference problems for (i) and (ii) require dif-
ferent search paths. For case (i), searching for the
numbers of incorrect prescriptions (there is no ZdUpr
record) after the modeling OWL needs only to define
the query of the type SELECT in the SPARQL lan-
guage. For case (ii), a query in SPARQL requires
many additional conditions, as many as different pe-
riods that correspond to ZdUpr in the dictionary of
events. For this group of problems, a queries of the
Construct type in the SPARQL language we found
useful in the definition of a rule. All the conditions de-
fined by the medical inspectors were taken into con-
sideration in the rule. A key SPIN features are the
following:
• possibility of calculation of property values based
on other properties,
• checking constraints and data validation,
• creating rule templates made under certain condi-
tions.
Figure 7 shows a rule defined in SPIN. The struc-
ture of this rule allows creation of libraries of similar
queries which will be important facilities for the med-
ical inspectors.
For case (ii) in our analysis, we prepared the
class Zdarzenia uprawniajace (class for privileges
to prescribe drugs) with properties: Zdarzenie upr
(event identifier), Zdarzenie upr kod (event code),
Zdarzenie upr liczba dni (the number of days just
after the date of event within the drug can be
applied), Zdarzenie upr nazwa m leku (international
drug name), each of data type properties, which allow
to refer to values of the ICD 9 and ICD 10 dictionar-
ies. The model of the controlling system supported by
TBC with embedded SPARQL and SPIN (Fuber and
Hepp, 2011) allows to create the optimal structures of
queries, and also allows further, flexible development
of the system model with another structures, rules and
queries. Furthermore, TBC allows the development
of friendly interfaces for end users of the system, i.e.,
medical specialists.
5 PROCESSING TIME OF
SEMANTIC DATA
After the system correctness confirmation the pro-
cessing time tests were carried out with the relational
database and the D2RQ converter and with the Oracle
11g database, which natively supports the storage of
RDF data.
Configuration of the server:
• Hardware: Intel Core 2 Duo E7600, 8 GB RAM.
• Software: Windows Server 2003 R2, Oracle
11.1.0.6.0, TopBraid Composer ME 3.2.0.
Processing times depending of the database access
mode shows the Table 1 and the Figure 9.
Table 1: Processing times depending of the database access
mode.
Number of RDF Time [h:m:s] Time [h:m:s]
triples D2RQ Oracle 11g
3 452 958 00:01:09 00:16:00
14 233 326 00:11:10 02:47:30
27 708 786 00:38:54 08:23:30
41 184 246 01:42:10 More than 24 hours
6 CONCLUSIONS
The result of our experiment is the achievement of a
high degree of data integration in order to obtain the
expected reports without any intervention to the exist-
ing distributed structure of the databases. The system
for controlling the correctness of medical procedures
model based on the TBC and D2RQ tools confirmed
the usefulness of SW in the analysis of the medical
procedures described by the records stored in the re-
lational databases. The experience with controlling
system modelling can be used to:
• extension of the developed model by new data
structures, relations, inference rules, and the tools
for result data visualization,
• sharing knowledge structures stored in the RDF,
RDFS, OWL, and the SPIN / SPARQLMotion
rules in description of the medical procedures,
A SEMANTIC WEB TECHNOLOGIES-BASED SYSTEM FOR CONTROLLING THE CORRECTNESS OF MEDICAL
PROCEDURES IN POLISH NATIONAL HEALTH FUND
335