A Novel Framework for User-Friendly Ontology-Mediated Access to Relational Databases

A large amount of data is typically stored in relational databases (DB). The latter can efficiently handle user queries which intend to elicit the appropriate information from data sources. However, direct access and use of this data requires the end users to have an adequate technical background, while they should also cope with the internal data structure and values presented. Consequently the information retrieval is a quite difficult process even for IT or DB experts, taking into account the limited contributions of relational databases from the conceptual point of view. Ontologies enable users to formally describe a domain of knowledge in terms of concepts and relations among them and hence they can be used for unambiguously specifying the information captured by the relational database. However, accessing information residing in a database using ontologies is feasible, provided that the users are keen on using semantic web technologies. For enabling users form different disciplines to retrieve the appropriate data, the design of a Graphical User Interface is necessary. In this work, we will present an interactive, ontology-based, semantically enable web tool that can be used for information retrieval purposes. The tool is totally based on the ontological representation of underlying database schema while it provides a user friendly environment through which the users can graphically form and execute their queries. Keywords—Ontologies, Relational Databases, SPARQL, Web Interface.

[1]  Ian Horrocks,et al.  OptiqueVQS: towards an ontology-based visual query system for big data , 2013, MEDES.

[2]  George Tsatsaronis,et al.  The OpenScienceLink architecture for novel services exploiting open access data in the biomedical domain , 2014, Panhellenic Conference on Informatics.

[3]  Deborah L. McGuinness,et al.  OWL Web ontology language overview , 2004 .

[4]  Robert Meersman,et al.  Data modelling versus ontology engineering , 2002, SGMD.

[5]  Donald D. Chamberlin,et al.  SEQUEL: A structured English query language , 1974, SIGFIDET '74.

[6]  E. Prud hommeaux,et al.  SPARQL query language for RDF , 2011 .

[7]  R. McClatchey,et al.  Using Assertion Capabilities of an OWL-Based Ontology for Query Formulation , 2008, 2008 3rd International Conference on Information and Communication Technologies: From Theory to Applications.

[8]  P. Oakes Quest , 2000 .

[9]  Marcelo Arenas,et al.  Querying semantic web data with SPARQL , 2011, PODS.

[10]  Kokou Yétongnon,et al.  DB2OWL : A Tool for Automatic Database-to-Ontology Mapping , 2007, SEBD.

[11]  Keith L. Clark,et al.  Negation as Failure , 1987, Logic and Data Bases.

[12]  Diego Calvanese,et al.  The MASTRO system for ontology-based data access , 2011, Semantic Web.

[13]  Yarden Katz,et al.  Pellet: A practical OWL-DL reasoner , 2007, J. Web Semant..

[14]  Michel Klein,et al.  Combining and relating ontologies: an analysis of problems and solutions , 2001, OIS@IJCAI.

[15]  Thomas Ertl,et al.  SparqlFilterFlow: SPARQL Query Composition for Everyone , 2014, ESWC.

[16]  Theodora A. Varvarigou,et al.  PAT: An Intelligent Authoring Tool for Facilitating Clinical Trial Design , 2014, MIE.

[17]  Theodora A. Varvarigou,et al.  An Intelligent Ontology Alignment Tool Dealing with Complicated Mismatches , 2014, SWAT4LS.

[18]  Pierre Siegel,et al.  Saturation, Nonmonotonic Reasoning and the Closed-World Assumption , 1985, Artif. Intell..

[19]  George Papastefanatos,et al.  rdf: SynopsViz - A Framework for Hierarchical Linked Data Visual Exploration and Analysis , 2014, ESWC.

[20]  Theodora A. Varvarigou,et al.  A novel query rewriting mechanism for semantically interlinking clinical research with electronic health records , 2012, WIMS '12.

[21]  Dan Brickley,et al.  Rdf vocabulary description language 1.0 : Rdf schema , 2004 .