<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Archiving and Interchange DTD v1.0 20120330//EN" "JATS-archivearticle1.dtd">
<article xmlns:xlink="http://www.w3.org/1999/xlink">
  <front>
    <journal-meta />
    <article-meta>
      <title-group>
        <article-title>Translation of Instance Data using RDF and Structured Mapping De nitions</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Mehmet Aydar</string-name>
          <email>maydar@kent.edu</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Austin Melton</string-name>
          <email>amelton@kent.edu</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Kent State University, Department of Computer Science</institution>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>Translation of Instance Data</institution>
        </aff>
      </contrib-group>
      <abstract>
        <p>We present a healthcare information interoperability project in development. The idea behind the system is achieving semantic interoperability of di erent healthcare data models, by enabling translation of instance data based on structured mapping de nitions, and using RDF as a common information representation. We have developed a framework that allows the domain experts to de ne linkages between di erent data elements and utilizes the mappings to translate the data models from one format to another.</p>
      </abstract>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>Introduction</title>
      <p>A healthcare IT environment breeds incredibly complex data ecosystems.
Clinical data exist in multiple layers and forms ranging from the heterogeneous of
structured, semi-structured, and unstructured data captured in enterprise-wide
electronic medical record and billing systems, through a wide variety of
departmental, study, and lab-based registries and databases. In many cases the data
need to be retrieved from multiple independent sources. Because of the lack of
interoperability between disparate data sources, retrieving data from multiple
sources is extremely time consuming, wasteful and costly.</p>
      <p>Interoperability can be achieved by adopting standards and translations
between di erent standards. There exist many di erent standards in healthcare,
each having its own uses and advantages. It is unrealistic to have one
universal standard that ts all the use cases. Therefore an e cient way of translation
between di erent data models is needed. Since each data model can be in a
different format, adopting a common information representation model is
unavoidable for the translation. In this sense, RDF (Resource Description Framework)
[5] is a good choice since it is schemaless and is a commonly accepted
information representation model by the semantic web community. Translation requires
mappings between the sets of data elements in the di erent data models.
Capturing the mappings between the data models in a structured format enables
auto-generation of the translation code.
1
Data Models</p>
      <p>Data source 1
Data source 2
Data source 3
Data source N</p>
      <p>Convert
to RDF
5</p>
      <p>Capture
Data
Models</p>
      <p>4
Read
Mappings
for:</p>
      <p>2</p>
      <p>Target Data Source X
Translation Engine
6</p>
      <p>Metadata &amp; Mappings</p>
      <p>Database
UI for Metadata &amp; Mappings</p>
      <p>3
7</p>
      <p>
        CSV Output
lation components work together. The metadata for each data source (
        <xref ref-type="bibr" rid="ref1">1</xref>
        ) are
captured and saved in the metadata repository or database (
        <xref ref-type="bibr" rid="ref2">2</xref>
        ). Further, the
data managers de ne the linkages (mappings) between the data elements using
a user-friendly interface, and these linkages are also saved in the metadata
repository (
        <xref ref-type="bibr" rid="ref3">3</xref>
        ). In preparation for a translation, the de ned mappings from the source
data model to the target data model are retrieved (
        <xref ref-type="bibr" rid="ref4">4</xref>
        ). The source instance data
are represented or lifted to RDF format (
        <xref ref-type="bibr" rid="ref5">5</xref>
        ). Then the translation engine uses
the source RDF data, the target data model metadata, and the mappings from
the source data model to the target data model to translate the source instance
data into target data (
        <xref ref-type="bibr" rid="ref6">6</xref>
        ). The translation engine produces the results in a CSV
(comma separated values) le format, and these results are conveyed to the
attened target data model (
        <xref ref-type="bibr" rid="ref7">7</xref>
        ). More details about the components are given in
the following sections.
2.1
      </p>
      <sec id="sec-1-1">
        <title>Metadata Repository &amp; Mapping Tool</title>
        <p>For each of the data sources, a data dictionary is captured and stored in a
metadata repository [7]. In our work a data dictionary includes data model
details for classes, attributes, attribute values, and their associations to each
other. As an example, for a relational data model, the metadata consists of tables,
table elds, allowed eld value sets for the elds, as well as the relationships
between di erent metadata elements such as parent-child relationships.</p>
        <p>The metadata repository also includes a mapping schema. The goal is to
enable storing the mappings between di erent data models in a structured format.
The mapping schema is designed so that a target eld can be mapped to from
multiple candidate source elds that belong to one or more candidate source
data models with eld-level priorities, and a value set translation from source
values to target values, and a pre-de ned transformation logic from source elds
to the target eld. A user-friendly interface is used by the data managers to view
the data dictionaries, manage the term de nitions and de ne mappings between
di erent data elements. In addition, the interface also has a test module that
lets the data managers write and execute tests to validate their mappings.
2.2</p>
      </sec>
      <sec id="sec-1-2">
        <title>Translation Engine</title>
        <p>The exibility of RDF allows di erent schemata and models to be converted,
represented and connected via RDF. In this work, the translation engine
performs the translation on the RDF representation of the source data elements.
The conversion from a source data format to the RDF representation di ers for
each data model, i.e., a di erent RDF data conversion routine is executed for
each data format. The conversion from source instance data to the RDF
representation happens on the y during the translation process; only the speci c
source instance data, which is required by the mapping, is converted.</p>
        <p>The usage of a metadata repository provides valuable bene ts in data
interoperability. Capturing the mapping knowledge in a structured format provides
connectivity between disparate data elements, and it enables an automatic
generation of the data translation code to some extent. This leads to more
transparency in the transformation process; i.e., in case of any data error it helps to
track the source of the problem by checking the documented data mappings.</p>
        <p>Data value translation enables the translation of a concept term in one data
code system into an equivalent concept term in another data code system. For
instance, a male gender can be represented with the term \Male" in one system
while it is represented with the term \M" in another system. The associations
in the documented value mappings are used to discover the term conversion
from \Male" to \M". In many cases a single target data eld is mapped to from
more than one source data eld. In this case the translation engine needs to
know the priority of the source elds and/or a derivation logic to translate from
multiple source elds. The priorities and the derivation logic can be de ned by
the data managers using the mapping interface. The translation engine is then
able to generate the translation code by utilizing the de ned priorities and the
derivation logic.
3</p>
      </sec>
    </sec>
    <sec id="sec-2">
      <title>Discussion</title>
      <p>
        Healthcare data interoperability requires the necessary tools, an e cient roadmap
and a strong commitment from relevant communities. Several studies have been
suggested for this purpose. For instance, the Yosemite Project [4] suggests an
ambitious roadmap for healthcare information interoperability on a global scale,
by using RDF as a universal information representation and creating a hub for
crowd-sourcing translation rules.
In this work we presented a framework to achieve interoperability between
di erent healthcare data models. It tries to alleviate the lack of interoperability
solutions and works fairly well on a small scale. However, our approach may
need improvements for use on a larger scale. In our work, we assumed that
there is already a de ned data dictionary in place for each data source. This
assumption may not be correct for all data sources. Also, manually de ning
the mappings can also require signi cant amounts of time due to the size of the
healthcare data. As future work, we plan to work on the following improvements:
(
        <xref ref-type="bibr" rid="ref1">1</xref>
        ) Creating OWL ontologies for the source data models along with a mapping
ontology, instead of using a relational schema. (
        <xref ref-type="bibr" rid="ref2">2</xref>
        ) Converting the user interface
of the Metadata &amp; Mapping to a web based collaborative interface utilizing
common semantic web tools such as Web-Protege [6]. (
        <xref ref-type="bibr" rid="ref3">3</xref>
        ) Having the translation
engine output the translated results into RDF format and then convert them
back to the target data model format as suggested in the Yosemite Project [4].
(
        <xref ref-type="bibr" rid="ref4">4</xref>
        ) Auto-generating the data dictionary from the RDF representation of a data
source. (
        <xref ref-type="bibr" rid="ref5">5</xref>
        ) Auto-generating mappings between di erent data models using graph
node similarity metrics and suggesting the auto-generated mappings to the data
managers, utilizing our previous studies [1, 3, 2].
      </p>
      <p>Acknowledgments Our work is implemented in the Cleveland Clinic
Cardiology Application Department to support interoperability between legacy data
models. The authors would like to thank the Kent State University Semantic
Web Research Group (SWRG) members, Cleveland Clinic Cardiology
Application Group members and Semantic Web Health Care and Life Sciences (HCLS)
Interest group members for their helpful feedback.</p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          1.
          <string-name>
            <given-names>Mehmet</given-names>
            <surname>Aydar</surname>
          </string-name>
          , Serkan Ayvaz, and Austin C Melton.
          <article-title>Automatic weight generation and class predicate stability in rdf summary graphs</article-title>
          .
          <source>In Workshop on Intelligent Exploration of Semantic Data (IESD2015)</source>
          ,
          <source>co-located with ISWC2015</source>
          ,
          <year>2015</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          2.
          <string-name>
            <given-names>Mehmet</given-names>
            <surname>Aydar</surname>
          </string-name>
          and Austin C Melton.
          <article-title>Rinsmatch: a suggestion-based instance matching system in rdf graphs</article-title>
          .
          <source>In Workshop on Ontology Matching (OM-2015), co-located with ISWC2015</source>
          ,
          <year>2015</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          3.
          <string-name>
            <given-names>Serkan</given-names>
            <surname>Ayvaz</surname>
          </string-name>
          , Mehmet Aydar, and Austin C Melton.
          <article-title>Building summary graphs of rdf data in semantic web</article-title>
          .
          <source>In Computer Software and Applications Conference (COMPSAC)</source>
          ,
          <source>2015 IEEE 39th International. IEEE</source>
          ,
          <year>2015</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref4">
        <mixed-citation>
          4.
          <string-name>
            <given-names>David</given-names>
            <surname>Booth</surname>
          </string-name>
          et al.
          <article-title>Yosemite manifesto on rdf as a universal healthcare exchange language</article-title>
          ,
          <year>2013</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref5">
        <mixed-citation>
          5.
          <string-name>
            <given-names>Graham</given-names>
            <surname>Klyne</surname>
          </string-name>
          and
          <string-name>
            <surname>Jeremy J Carroll</surname>
          </string-name>
          .
          <article-title>Resource description framework (rdf): Concepts and abstract syntax</article-title>
          .
          <year>2006</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref6">
        <mixed-citation>
          6.
          <string-name>
            <given-names>T</given-names>
            <surname>Tudorache</surname>
          </string-name>
          ,
          <string-name>
            <given-names>J</given-names>
            <surname>Vendetti</surname>
          </string-name>
          , and
          <string-name>
            <given-names>N</given-names>
            <surname>Noy</surname>
          </string-name>
          .
          <article-title>Web-protege: A lightweight owl ontology editor for the web</article-title>
          . sdr. Cit. on p,
          <year>2008</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref7">
        <mixed-citation>
          7.
          <string-name>
            <surname>Wikipedia</surname>
          </string-name>
          .
          <article-title>Data dictionary | wikipedia, the free encyclopedia</article-title>
          ,
          <year>2015</year>
          . [Online; accessed 3-July-2015].
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>