IWONTO – SQL BASED MAPPING FROM RELATIONAL DATABASES TO ONTOLOGIES

Karsten Tolle, Mario Bachmann

2012

Abstract

Ontologies are a formal representation of knowledge and semantics. With the emergence of the Semantic Web in the early 2000s, ontologies were pushed and from a theoretical point of view, many things could be solved. However, on the applicability level even finding the right tool to extract and load relational data into an existing ontology is a challenge and performing it remains a time consuming task. Based on various real case scenarios from the archaeological domain, we tried ontology-based approaches to integrate data. In those scenarios we had to deal with relational schema violating academic design principles. This complicated the situation. After an analysis of existing tools, we decided to implement our own tool to import relational data from different sources into our ontology. This paper will explain our motivation for implementing our tool called IwOnto and how it works. We decided to base it on SQL, which is known by our main target audience. Thereby we reached our design goal to avoid the necessity of learning another query language (e.g. SPARQL).

References

  1. Bachmann, M. (2011). Informationsintegration mit Ontologien am Beispiel von archäologischen Daten, Diploma Thesis at Goethe University Frankfurt am Main.
  2. Barrasa, J., Corcho, Ó and, Gómez-Pérez, A. (2004). R2O, an extensible and semantically based database-toontology mapping language. In: Proceedings of the Second Workshop on Semantic Web and Databases, Springer-Verlag, Berlin, Germany, pp. 1069-1070. ISBN 978-3-540-24576-6.
  3. Bizer, C. (2003). D2R MAP - A Database to RDF Mapping Language. The Twelfth International World Wide Web Conference, Budapest, Hungary.
  4. Ghawi, R. and Cullot, N. (2007). Database-to-Ontology Mapping Generation for Semantic Interoperability, 3rd International Workshop on Database Interoperability (InterDB 2007), held in conjunction with VLDB 2007, Vienna, Austria.
  5. Konstantinou, N., Spantos, D-E., Chalas, M., Solidakis E. and Mitrou, N. (2006). VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents. International Workshop on Web Information Systems Modeling (WISM 2006), Luxembourg.
  6. Svihla, M. and Jelinek, I. (2005). The Database to RDF Mapping Module for an Easy Semantic Extending of Dynamic Web Sites. IADIS International Conference WWW/Internet, Lisabon, Portugal.
Download


Paper Citation


in Harvard Style

Tolle K. and Bachmann M. (2012). IWONTO – SQL BASED MAPPING FROM RELATIONAL DATABASES TO ONTOLOGIES . In Proceedings of the 8th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8565-08-2, pages 430-433. DOI: 10.5220/0003934304300433


in Bibtex Style

@conference{webist12,
author={Karsten Tolle and Mario Bachmann},
title={IWONTO – SQL BASED MAPPING FROM RELATIONAL DATABASES TO ONTOLOGIES},
booktitle={Proceedings of the 8th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2012},
pages={430-433},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003934304300433},
isbn={978-989-8565-08-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 8th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - IWONTO – SQL BASED MAPPING FROM RELATIONAL DATABASES TO ONTOLOGIES
SN - 978-989-8565-08-2
AU - Tolle K.
AU - Bachmann M.
PY - 2012
SP - 430
EP - 433
DO - 10.5220/0003934304300433