Valet SADI: Provisioning SADI Web Services for Semantic Querying of Relational Databases

Semantic Querying (SQ) is emerging as an attractive approach for retrieval of data from relational and other conceptually similar databases, targeting users with limited or no technical expertise. Using SQ queries can be formulated using terminologies from a specific domain, which are then either translated in real time into the equivalent SQL queries, or executed against a materialised semantic database obtained by transforming the source relational data. This approach is suitable for non-technical users who are familiar with describing a domain using the terminologies in an ontology but lack expertise in writing SQL queries over complex relational schemas. As an alternative to the existing methods, we implement the vision of SQ on relational databases by deploying Semantic Web services over one or more databases and querying them with SPARQL queries. The approach based on manual Semantic Web service writing under-utilises easily manageable declarative mappings between source data schemas and domain ontologies. In this paper we introduce the Valet SADI framework to automate the creation of SADI Semantic Web services from declarative mappings, and demonstrate that Valet SADI, together with SADI query engines, establishes semantic querying as a viable, economical and user friendly way of querying relational databases.

[1]  Giovanna Guerrini,et al.  Detecting and Correcting Conservativity Principle Violations in Ontology-to-Ontology Mappings , 2014, SEMWEB.

[2]  Marcelo A. T. Aragão,et al.  Incremental Query Rewriting with Resolution , 2010 .

[3]  Alan J. Forster,et al.  Semantic querying of relational data for clinical intelligence: a semantic web services-based approach , 2013, J. Biomed. Semant..

[4]  Carole A. Goble,et al.  Query processing in the TAMBIS bioinformatics source integration system , 1999, Proceedings. Eleventh International Conference on Scientific and Statistical Database Management.

[5]  Harold Boley,et al.  PSOA RuleML: Integrated Object-Relational Data and Rules , 2015, Reasoning Web.

[6]  Mariano Rodriguez-Muro,et al.  Efficient SPARQL-to-SQL with R2RML mappings , 2015, J. Web Semant..

[7]  Deborah L. McGuinness,et al.  Bringing Semantics to Web Services with OWL-S , 2007, World Wide Web.

[8]  Web Services Definition Language (WSDL) , 2014, Encyclopedia of Social Network Analysis and Mining.

[9]  Alessandro Solimando Detecting and Correcting Conservativity Principle Violations in Ontology Mappings , 2014, International Semantic Web Conference.

[10]  Christopher D. Town,et al.  SSWAP: A Simple Semantic Web Architecture and Protocol for semantic web services , 2009, BMC Bioinformatics.

[11]  Geoff Sutcliffe The TPTP Problem Library and Associated Infrastructure , 2009, Journal of Automated Reasoning.

[12]  Harold Boley,et al.  Automated generation of SADI semantic web services for clinical intelligence , 2016, SBD '16.

[13]  Mark D. Wilkinson,et al.  SHARE: A Semantic Web Query Engine for Bioinformatics , 2009, ASWC.

[14]  Harold Boley A RIF-Style Semantics for RuleML-Integrated Positional-Slotted, Object-Applicative Rules , 2011, RuleML Europe.

[15]  Jos de Bruijn,et al.  Web Service Modeling Ontology , 2005, Appl. Ontology.

[16]  Jos de Bruijn,et al.  The Web Service Modeling Language WSML: An Overview , 2006, ESWC.

[17]  Carsten Binnig,et al.  Pay as you go Matching of Relational Schemata to OWL Ontologies with IncMap , 2013, International Semantic Web Conference.

[18]  Diego Calvanese,et al.  MASTRO-I: Efficient Integration of Relational Data through DL Ontologies , 2007, Description Logics.

[19]  D. Box,et al.  Simple object access protocol (SOAP) 1.1 , 2000 .

[20]  Geoff Sutcliffe The TPTP Problem Library and Associated Infrastructure , 2017, Journal of Automated Reasoning.

[21]  Mark D. Wilkinson,et al.  The Semantic Automated Discovery and Integration (SADI) Web service Design-Pattern, API and Reference Implementation , 2011, J. Biomed. Semant..

[22]  Peter Haase,et al.  Optique: Zooming in on Big Data , 2015, Computer.