Article

Generating SPARQL executable mappings to integrate ontologies

Authors:

Carlos R. Rivero,

Inma Hernández,

David Ruiz, and

Rafael CorchueloAuthors Info & Claims

ER'11: Proceedings of the 30th international conference on Conceptual modeling

October 2011

Pages 118 - 131

Published: 31 October 2011 Publication History

Abstract

Data translation is an integration task that aims at populating a target model with data of a source model by means of mappings. Generating them automatically is appealing insofar it may reduce integration costs. Matching techniques automatically generate uninterpreted mappings, a.k.a. correspondences, that must be interpreted to perform the data translation task. Other techniques automatically generate executable mappings, which encode an interpretation of these correspondences in a given query language. Unfortunately, current techniques to automatically generate executable mappings are based on instance examples of the target model, which usually contains no data, or based on nested relational models, which cannot be straightforwardly applied to semantic-web ontologies. In this paper, we present a technique to automatically generate SPARQL executable mappings between OWL ontologies. The original contributions of our technique are as follows: 1) it is not based on instance examples but on restrictions and correspondences, 2) we have devised an algorithm to make restrictions and correspondences explicit over a number of language-independent executable mappings, and 3) we have devised an algorithm to transform language-independent into SPARQL executable mappings. Finally, we evaluate our technique over ten scenarios and check that the interpretation of correspondences that it assumes is coherent with the expected results.

References

[1]

Alexe, B., Chiticariu, L., Miller, R.J., Pepper, D., Tan, W.C.: Muse: a system for understanding and designing mappings. In: SIGMOD, pp. 1281-1284 (2008).

Digital Library

[2]

Alexe, B., Tan, W.C., Velegrakis, Y.: STBenchmark: towards a benchmark for mapping systems. PVLDB 1(1), 230-244 (2008).

Digital Library

[3]

Antoniou, G., van Harmelen, F.: A SemanticWeb Primer, 2nd edn. The MIT Press, Cambridge (2008).

Digital Library

[4]

Bernstein, P.A., Haas, L.M.: Information integration in the enterprise. Commun. ACM 51(9), 72-79 (2008).

Digital Library

[5]

Bernstein, P.A., Melnik, S.: Model management 2.0: manipulating richer mappings. In: SIGMOD, pp. 1-12 (2007).

Digital Library

[6]

Bizer, C.: The emerging web of linked data. IEEE Int. Sys. (2009).

Digital Library

[7]

Bizer, C., Lehmann, J., Kobilarov, G., Auer, S., Becker, C., Cyganiak, R., Hellmann, S.: DBpedia - a crystallization point for the web of data. J. Web Sem. (2009).

Digital Library

[8]

Bizer, C., Schultz, A.: The R2R framework: Publishing and discovering mappings on the web. In: COLD (2010).

[9]

Choi, N., Song, I.-Y., Han, H.: A survey on ontology mapping. SIGMOD Record 35(3), 34-41 (2006).

Digital Library

[10]

Euzenat, J., Polleres, A., Scharffe, F.: Processing ontology alignments with SPARQL. In: CISIS, pp. 913-917 (2008).

Digital Library

[11]

Euzenat, J., Shvaiko, P.: Ontology Matching. Springer, Heidelberg (2007).

Digital Library

[12]

Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336(1), 89-124 (2005).

Digital Library

[13]

Fuxman, A., Hernández, M.A., Ho, C.T.H., Miller, R.J., Papotti, P., Popa, L.: Nested mappings: Schema mapping reloaded. In: VLDB, pp. 67-78 (2006).

Digital Library

[14]

Haas, L.M., Hernández, M.A., Ho, H., Popa, L., Roth, M.: Clio grows up: from research prototype to industrial tool. In: SIGMOD, pp. 805-810 (2005).

Digital Library

[15]

Halevy, A.Y.: Answering queries using views: A survey. VLDB J. 10(4), 270-294 (2001).

Digital Library

[16]

Heath, T., Motta, E.: Revyu: Linking reviews and ratings into the web of data. J. Web Sem. 6(4), 266-273 (2008).

Digital Library

[17]

Karvounarakis, G., Magkanaraki, A., Alexaki, S., Christophides, V., Plexousakis, D., Scholl, M., Tolle, K.: Querying the semantic web with RQL. Computer Networks 42(5), 617-640 (2003).

Digital Library

[18]

Kensche, D., Quix, C., Li, Y., Jarke, M.: Generic schema mappings. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 132-148. Springer, Heidelberg (2007).

Digital Library

[19]

Lenzerini, M.: Data integration: A theoretical perspective. In: PODS, pp. 233-246 (2002).

Digital Library

[20]

Mecca, G., Papotti, P., Raunich, S.: Core schema mappings. In: SIGMOD, pp. 655-668 (2009).

Digital Library

[21]

Motik, B., Horrocks, I., Sattler, U.: Bridging the gap between OWL and relational databases. J. Web Sem. 7(2), 74-89 (2009).

Digital Library

[22]

Noy, N.F.: Semantic integration: A survey of ontology-based approaches. SIGMOD Record 33(4), 65-70 (2004).

Digital Library

[23]

Noy, N.F., Klein, M.C.A.: Ontology evolution: Not the same as schema evolution. Knowl. Inf. Syst. 6(4), 428-440 (2004).

Digital Library

[24]

Papotti, P., Torlone, R.: Schema exchange: A template-based approach to data and metadata translation. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 323-337. Springer, Heidelberg (2007).

Digital Library

[25]

Parreiras, F.S., Staab, S., Schenk, S., Winter, A.: Model driven specification of ontology translations. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds.) ER 2008. LNCS, vol. 5231, pp. 484-497. Springer, Heidelberg (2008).

Digital Library

[26]

Pedrinaci, C., Liu, D., Maleshkova, M., Lambert, D., Kopecky, J., Domingue, J.: iServe: a linked services publishing platform. In: ORES (2010).

[27]

Petropoulos, M., Deutsch, A., Papakonstantinou, Y., Katsis, Y.: Exporting and interactively querying web service-accessed sources: The CLIDE system. ACM Trans. Database Syst. 32(4) (2007).

Digital Library

[28]

Popa, L., Velegrakis, Y., Miller, R.J., Hernández, M.A., Fagin, R.: Translating web data. In: VLDB, pp. 598-609 (2002).

Digital Library

[29]

Qin, H., Dou, D., LePendu, P.: Discovering executable semantic mappings between ontologies. In: Chung, S. (ed.) OTM 2007, Part I. LNCS, vol. 4803, pp. 832-849. Springer, Heidelberg (2007).

Digital Library

[30]

Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334-350 (2001).

Digital Library

[31]

Rivero, C.R., Hernández, I., Ruiz, D., Corchuelo, R.: Mosto: Generating sparql executable mappings between ontologies. In: Jeusfeld, M., Delcambre, L., Ling, T.W. (eds.) ER 2011. LNCS, vol. 6998, pp. 118-131. Springer, Heidelberg (2011).

Digital Library

[32]

Rivero, C.R., Hernández, I., Ruiz, D., Corchuelo, R.: On using database techniques for generating ontology mappings. In: SWWS (2011).

[33]

Rivero, C.R., Hernández, I., Ruiz, D., Corchuelo, R.: A reference architecture for building semantic-web mediators. In: IWSSA (2011)

[34]

Rivero, C.R., Ruiz, D., Corchuelo, R.: On benchmarking data translation systems for semantic-web ontologies (Tech. Report), http://tdg-seville.info/Download.ashx?id=205

[35]

Shadbolt, N., Berners-Lee, T., Hall, W.: The semantic web revisited. IEEE Int. Sys. 21(3), 96-101 (2006)

Digital Library

[36]

ten Cate, B., Chiticariu, L., Kolaitis, P.G., Tan, W.C.: Laconic schema mappings: Computing the core with SQL queries. PVLDB 2(1), 1006-1017 (2009)

Digital Library

[37]

Yu, C., Popa, L.: Constraint-based XML query rewriting for data integration. In: SIGMOD, pp. 371-382 (2004).

Digital Library

Cited By

Bashardoost BMiller RLyons KNargesian F(2020)Knowledge translationProceedings of the VLDB Endowment10.14778/3407790.340780613:12(2018-2032)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3407790.3407806
GarcíA JJunghans MRuiz DAgarwal SRuiz-CortéS A(2013)Integrating semantic Web services ranking mechanisms using a common preference modelKnowledge-Based Systems10.1016/j.knosys.2013.04.00749(22-36)Online publication date: 1-Sep-2013
https://dl.acm.org/doi/10.1016/j.knosys.2013.04.007
Mecca GRull GSantoro DTeniente E(2013)Semantic-Based MappingsProceedings of the 32nd International Conference on Conceptual Modeling - Volume 821710.1007/978-3-642-41924-9_22(255-269)Online publication date: 11-Nov-2013
https://dl.acm.org/doi/10.1007/978-3-642-41924-9_22
Show More Cited By

Recommendations

Mosto: generating SPARQL executable mappings between ontologies
ER'11: Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions

Data translation is an integration task that aims at populating a target model with data of a source model, which is usually performed by means of mappings. To reduce costs, there are some techniques to automatically generate executable mappings in a ...
Read More
Using SPARQL to query bioportal ontologies and metadata
ISWC'12: Proceedings of the 11th international conference on The Semantic Web - Volume Part II

BioPortal is a repository of biomedical ontologies--the largest such repository, with more than 300 ontologies to date. This set includes ontologies that were developed in OWL, OBO and other languages, as well as a large number of medical terminologies ...
Read More
Discovering Executable Semantic Mappings Between Ontologies
On the Move to Meaningful Internet Systems 2007: CoopIS, DOA, ODBASE, GADA, and IS
Abstract
Creating executable semantic mappings is an important task for ontology-based information integration. Although it is argued that mapping tools may require interaction from humans (domain experts) for best accuracy, in general, automatic ontology ...
Read More

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

ER'11: Proceedings of the 30th international conference on Conceptual modeling

October 2011

527 pages

ISBN:9783642246050

Editors:
Manfred A. Jeusfeld
Tilburg University, Tilburg, The Netherlands
,
Lois Delcambre
Portland State University, Maseeh College of Engineering and Computer Science, Portland, OR
,
Tok Wang Ling
National University of Singapore, Department of Computer Science, Singapore

Sponsors

FNRS: National Fund for Scientific Research - Belgium
FWO: Fund for Scientific Research - Flanders (Belgium)
NSF
Microsoft Research: Microsoft Research
IBM: IBM

In-Cooperation

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 31 October 2011

Check for updates

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

7
Total Citations
View Citations
0
Total Downloads

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

Other Metrics

View Author Metrics

Citations

Cited By

Bashardoost BMiller RLyons KNargesian F(2020)Knowledge translationProceedings of the VLDB Endowment10.14778/3407790.340780613:12(2018-2032)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3407790.3407806
GarcíA JJunghans MRuiz DAgarwal SRuiz-CortéS A(2013)Integrating semantic Web services ranking mechanisms using a common preference modelKnowledge-Based Systems10.1016/j.knosys.2013.04.00749(22-36)Online publication date: 1-Sep-2013
https://dl.acm.org/doi/10.1016/j.knosys.2013.04.007
Mecca GRull GSantoro DTeniente E(2013)Semantic-Based MappingsProceedings of the 32nd International Conference on Conceptual Modeling - Volume 821710.1007/978-3-642-41924-9_22(255-269)Online publication date: 11-Nov-2013
https://dl.acm.org/doi/10.1007/978-3-642-41924-9_22
Makris KBikakis NGioldasis NChristodoulakis S(2012)SPARQL-RWProceedings of the 15th International Conference on Extending Database Technology10.1145/2247596.2247678(610-613)Online publication date: 27-Mar-2012
https://dl.acm.org/doi/10.1145/2247596.2247678
Hernández IRivero CRuiz DCorchuelo RMille AGandon FMisselis JRabinovich MStaab S(2012)A statistical approach to URL-based web page clusteringProceedings of the 21st International Conference on World Wide Web10.1145/2187980.2188109(525-526)Online publication date: 16-Apr-2012
https://dl.acm.org/doi/10.1145/2187980.2188109
Rivero CHernández IRuiz DCorchuelo R(2011)MostoProceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions10.5555/2075202.2075258(345-348)Online publication date: 31-Oct-2011
https://dl.acm.org/doi/10.5555/2075202.2075258
Rivero CHernández IRuiz DCorchuelo R(2011)On benchmarking data translation systems for semantic-web ontologiesProceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2063810(1613-1618)Online publication date: 24-Oct-2011
https://dl.acm.org/doi/10.1145/2063576.2063810

View Options

View options

Media

Figures

Other

Tables

View Table of Contents