short-paper

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

Authors:

Mohammad Sadnan Al Manir,

Alexandre Riazanov,

Christopher J.O. BakerAuthors Info & Claims

IDEAS '16: Proceedings of the 20th International Database Engineering & Applications Symposium

Pages 248 - 255

https://doi.org/10.1145/2938503.2938543

Published: 11 July 2016 Publication History

Abstract

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.

References

[1]

The Ottawa Hospital - Data Warehouse. http://cbakerlab.unbsj.ca: 8080/DWdocumentation/DWDocIndex.html, last accessed, June 2016.

[2]

M. S. Al-Manir, A. Riazanov, H. Boley, A. Klein, and C. J. O. Baker. Automated Generation of SADI Semantic Web Services for Clinical Intelligence. In Proceedings of the International Workshop on Semantic Big Data, SBD '16, pages 6:1--6:6, New York, NY, USA, 2016. ACM.

Digital Library

[3]

C. Bizer and A. Seaborne. D2RQ - Treating Non-RDF Databases as Virtual RDF Graphs. In ISWC2004.

[4]

H. Boley. A RIF-Style Semantics for RuleML-Integrated Positional-Slotted, Object-Applicative Rules. In N. Bassiliades, G. Governatori, and A. Paschke, editors, RuleML Europe, volume 6826 of Lecture Notes in Computer Science, pages 194--211. Springer, 2011.

Digital Library

[5]

H. Boley. PSOA RuleML: Integrated Object-Relational Data and Rules. In W. Faber and A. Paschke, editors, Reasoning Web. Web Logic Rules (RuleML 2015) - 11th International Summer School 2015, Berlin, Germany, July 31-August 4, 2015, Tutorial Lectures, volume 9203 of Lecture Notes in Computer Science. Springer, 2015.

[6]

D. Calvanese, G. De Giacomo, D. Lembo, M. Lenzerini, A. Poggi, and R. Rosati. MASTRO-I: Efficient integration of relational data through DL ontologies, volume 250, pages 227--234. 2007.

[7]

E. Christensen, F. Curbera, G. Meredith, and S. Weerawarana. Web Service Definition Language (WSDL). Technical report, Mar. 2001.

[8]

J. de Bruijn, H. Lausen, A. Polleres, and D. Fensel. The web service modeling language wsml: An overview. In ESWC, pages 590--604, 2006.

Digital Library

[9]

D. D. Gessler, G. S. Schiltz, G. D. May, S. Avraham, C. D. Town, D. Grant, and R. T. Nelson. Sswap: A simple semantic web architecture and protocol for semantic web services. BMC Bioinformatics, 10(1):1--21, 2009.

[10]

M. Giese, A. Soylu, G. Vega-Gorgojo, A. Waaler, P. Haase, E. Jiménez-Ruiz, D. Lanti, M. Rezk, G. Xiao, Ö. L. Özçep, and R. Rosati. Optique: Zooming in on big data. IEEE Computer, 48(3):60--67, 2015.

Digital Library

[11]

D. Martin, M. Burstein, D. Mcdermott, S. Mcilraith, M. Paolucci, K. Sycara, D. L. Mcguinness, E. Sirin, and N. Srinivasan. Bringing semantics to web services with owl-s. World Wide Web, 10(3):243--277, Sept. 2007.

Digital Library

[12]

N. Paton, R. Stevens, P. Baker, C. Goble, S. Bechhofer, and A. Brass. Query Processing in the TAMBIS Bioinformatics Source Integration System. In e. Z.M. Ozsoyoglo, editor, Proc. 11th Int. Conf. on Scientific and Statistical Database Management (SSDBM), pages 138--147, Los Alamitos, California, July 1999. IEEE Press.

Digital Library

[13]

C. Pinkel, C. Binnig, E. Kharlamov, and P. Haase. Pay-as-you-go matching of relational schemata to owl ontologies with incmap. In Proceedings of the 2013th International Conference on Posters & Demonstrations Track - Volume 1035, ISWC-PD'13, pages 225--228, Aachen, Germany, Germany, 2013. CEUR-WS.org.

Digital Library

[14]

A. Riazanov. VampirePrime reasoner. Available at http://riazanov.webs.com/software.htm.

[15]

A. Riazanov and M. A. T. Aragão. Incremental Query Rewriting with Resolution. Canadian Semantic Web II. Springer US, 2010.

[16]

A. Riazanov, A. Klein, A. Shaban-Nejad, G. W. Rose, A. J. Forster, D. L. Buckeridge, and C. J. O. Baker. Semantic querying of relational data for clinical intelligence: a semantic web services-based approach. J. Biomedical Semantics, 4:9, 2013.

[17]

M. Rodriguez-Muro and M. Rezk. Efficient sparql-to-sql with r2rml mappings. J. Web Sem., 33:141--169, 2015.

[18]

D. Roman, U. Keller, H. Lausen, J. de Bruijn, R. Lara, M. Stollberg, A. Polleres, C. Feier, C. Bussler, and D. Fensel. Web service modeling ontology. Applied Ontology, 1(1):77--106, 2005.

Digital Library

[19]

A. Solimando, E. Jiménez-Ruiz, and G. Guerrini. Detecting and correcting conservativity principle violations in ontology-to-ontology mappings. In Proceedings of the 13th International Semantic Web Conference - Part II, ISWC '14, pages 1--16, New York, NY, USA, 2014. Springer-Verlag New York, Inc.

Digital Library

[20]

G. Sutcliffe. The TPTP Problem Library and Associated Infrastructure: The FOF and CNF Parts, v3.5.0. Journal of Automated Reasoning, 43(4):337--362, 2009.

Digital Library

[21]

B. P. Vandervalk, E. L. McCarthy, and M. D. Wilkinson. SHARE: A semantic web query engine for bioinformatics. In The Semantic Web, Fourth Asian Conference, ASWC 2009, Shanghai, China, December 6-9, 2009. Proceedings, pages 367--369, 2009.

Digital Library

[22]

M. Wilkinson, B. Vandervalk, and L. McCarthy. The Semantic Automated Discovery and Integration (SADI) Web service Design-Pattern, API and Reference Implementation. Journal of Biomedical Semantics, 2(1):8, 2011.

[23]

World Wide Web Consortium. Simple Object Access Protocol (SOAP) 1.2, 2003.

Cited By

Al Manir MSpencer BBaker C(2018)Decision Support for Agricultural Consultants With Semantic Data FederationInternational Journal of Agricultural and Environmental Information Systems10.4018/IJAEIS.20180701069:3(87-99)Online publication date: 1-Jul-2018
https://doi.org/10.4018/IJAEIS.2018070106
Al Manir MBrenas JBaker CShaban-Nejad A(2018)A Surveillance Infrastructure for Malaria Analytics: Provisioning Data Access and Preservation of InteroperabilityJMIR Public Health and Surveillance10.2196/102184:2(e10218)Online publication date: 15-Jun-2018
https://doi.org/10.2196/10218
Brenas JAl-Manir MBaker CShaban-Nejad A(2017)A Malaria Analytics Framework to Support Evolution and Interoperability of Global Health Surveillance SystemsIEEE Access10.1109/ACCESS.2017.27612325(21605-21619)Online publication date: 2017
https://doi.org/10.1109/ACCESS.2017.2761232

Recommendations

Automated generation of SADI semantic web services for clinical intelligence
SBD '16: Proceedings of the International Workshop on Semantic Big Data

Infection control practitioners typically lack the technical expertise to find and integrate relevant information from hospital databases and clinical applications. A promising approach to this problem is semantic querying of relational databases, as ...
The SADI plug-in to IO informatics' sentient knowledge explorer
SWAT4LS '11: Proceedings of the 4th International Workshop on Semantic Web Applications and Tools for the Life Sciences

Integrating, visualizing and exploring Semantic Web data is the primary focus of the Sentient Knowledge Explorer (KE). To date, export of displayed data to arbitrary analytical tools has not been possible through the KE interface. Here we describe a ...
WebOWL: A Semantic Web search engine development experiment

This paper presents WebOWL, an experiment in using the latest technologies to develop a Semantic Web search engine. WebOWL consists of a community of intelligent agents, acting as crawlers, that are able to discover and learn the locations of Semantic ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

IDEAS '16: Proceedings of the 20th International Database Engineering & Applications Symposium

July 2016

420 pages

ISBN:9781450341189

DOI:10.1145/2938503

Editor:
Evan Desai
ConfSys
,
General Chair:
Bipin C. Desai
Concordia University
,
Program Chairs:
Motomichi Toyama
Keio University
,
Jorge Bernardino
ISEC

Copyright © 2016 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

In-Cooperation

Keio University: Keio University

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 July 2016

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Short-paper
Research
Refereed limited

Conference

IDEAS '16

IDEAS '16: International Database Engineering & Applications Symposium

July 11 - 13, 2016

QC, Montreal, Canada

Acceptance Rates

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

3
Total Citations
View Citations
59
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 08 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Al Manir MSpencer BBaker C(2018)Decision Support for Agricultural Consultants With Semantic Data FederationInternational Journal of Agricultural and Environmental Information Systems10.4018/IJAEIS.20180701069:3(87-99)Online publication date: 1-Jul-2018
https://doi.org/10.4018/IJAEIS.2018070106
Al Manir MBrenas JBaker CShaban-Nejad A(2018)A Surveillance Infrastructure for Malaria Analytics: Provisioning Data Access and Preservation of InteroperabilityJMIR Public Health and Surveillance10.2196/102184:2(e10218)Online publication date: 15-Jun-2018
https://doi.org/10.2196/10218
Brenas JAl-Manir MBaker CShaban-Nejad A(2017)A Malaria Analytics Framework to Support Evolution and Interoperability of Global Health Surveillance SystemsIEEE Access10.1109/ACCESS.2017.27612325(21605-21619)Online publication date: 2017
https://doi.org/10.1109/ACCESS.2017.2761232

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten