Skip to main content
Top
Published in: Journal of Intelligent Information Systems 3/2019

25-07-2019

Crowd Sourced Semantic Enrichment (CroSSE) for knowledge driven querying of digital resources

Authors: Giacomo Cavallo, Francesco Di Mauro, Paolo Pasteris, Maria Luisa Sapino, K. Selcuk Candan

Published in: Journal of Intelligent Information Systems | Issue 3/2019

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Today, most information sources provide factual, objective knowledge, but they fail to capture personalized contextual knowledge which could be used to enrich the available factual data and contribute to their interpretation, in the context of the knowledge of the user who queries the system. This would require a knowledge framework which can accommodate both objective data and semantic enrichments that capture user provided knowledge associated to the factual data in the database. Unfortunately, most conventional DBMSs lack the flexibilities necessary (a) to prevent the data and metadata, evolve quickly with changing application requirements and (b) to capture user-provided and/or crowdsourced data and knowledge for more effective decision support. In this paper, we present CrowdSourced Semantic Enrichment (CroSSE) knowledge framework which allows traditional databases and semantic enrichment modules to coexist. CroSSE provides a novel Semantically Enriched SQL (SESQL) language to enrich SQL queries with information from a knowledge base containing semantic annotations. We describe CroSSE and SESQL with examples taken from our SmartGround EU project.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Footnotes
1
In Europe, there are from 150.000 to 500.000 very variable landfills. In 2008, 49% of the almost 3 billion tons of total waste generated in the EU-27 was disposed in dedicated landfills.
 
3
The SmartGround platform, which implement many of the functionalities of the CroSSE, is available, for registered users, at http://​smartground.​atosresearch.​eu/​home.
 
4
In case of multiple enrichments by select, each resulting knowledge table is combined with the others by means of an additional join in the FROM clause of the query.
 
5
For readability, we used human-readable, descriptive names to the variables in the SPARQL queries. In reality, in automatically generated queries, these names are not descriptive.
 
6
In case of multiple enrichments, each additional condition is combined in the WHERE clause of the rewritten query (see example 10).
 
Literature
go back to reference Minc. (2017). A social platform for fostering educational interactions. Minc. (2017). A social platform for fostering educational interactions.
go back to reference Adali, S., Candan, K., Papakonstantinou, Y., Subrahmanian, V. (1996). Query processing in the sims information mediator. In SIGMOD (pp. 137–148). Adali, S., Candan, K., Papakonstantinou, Y., Subrahmanian, V. (1996). Query processing in the sims information mediator. In SIGMOD (pp. 137–148).
go back to reference Arens, Y., Knoblock, C., Hsu, C. (1996). Query processing in the sims information mediator. In AAAI. Arens, Y., Knoblock, C., Hsu, C. (1996). Query processing in the sims information mediator. In AAAI.
go back to reference Beckett, D. (ed.) (2004). RDF/XML Syntax Specification (Revised),. W3C Recommendation. Beckett, D. (ed.) (2004). RDF/XML Syntax Specification (Revised),. W3C Recommendation.
go back to reference Caldarola, E.G., Picariello, A., Rinaldi, A.M. (2015). An approach to ontology integration for ontology reuse in knowledge based digital ecosystems. In MEDES. Caldarola, E.G., Picariello, A., Rinaldi, A.M. (2015). An approach to ontology integration for ontology reuse in knowledge based digital ecosystems. In MEDES.
go back to reference Calì, A., Gottlob, G., Pieris, A. (2010). Advanced processing for ontological queries. Proc. VLDB Endow., 3(1-2), 554–565.CrossRef Calì, A., Gottlob, G., Pieris, A. (2010). Advanced processing for ontological queries. Proc. VLDB Endow., 3(1-2), 554–565.CrossRef
go back to reference Candan, K.S., Cao, H., Qi, Y., Sapino, M.L. (2008). System support for exploration and expert feedback in resolving conflicts during integration of metadata. VLDB Journal, 17(6), 22–119.CrossRef Candan, K.S., Cao, H., Qi, Y., Sapino, M.L. (2008). System support for exploration and expert feedback in resolving conflicts during integration of metadata. VLDB Journal, 17(6), 22–119.CrossRef
go back to reference Cavallo, G., Di Mauro, F., Pasteris, P., Sapino, M.L., Candan, K.S. (2018). Contextually-enriched querying of integrated data sources. In ICDE18 Workshops. Cavallo, G., Di Mauro, F., Pasteris, P., Sapino, M.L., Candan, K.S. (2018). Contextually-enriched querying of integrated data sources. In ICDE18 Workshops.
go back to reference Davulcu, H., Freire, J., Kifer, M., Ramakrishnan, I. (1999). A layered architecture for querying dynamic web content. In SIGMOD. Davulcu, H., Freire, J., Kifer, M., Ramakrishnan, I. (1999). A layered architecture for querying dynamic web content. In SIGMOD.
go back to reference Davulcu, H., Kifer, M., Yang, G., Ramakrishnan, I. (2000). Design and implementation of the physical layer in webbases: the xrover experience. In DOOD.CrossRef Davulcu, H., Kifer, M., Yang, G., Ramakrishnan, I. (2000). Design and implementation of the physical layer in webbases: the xrover experience. In DOOD.CrossRef
go back to reference Di Mauro, F., Pasteris, P., Sapino, M.L., Candan, K.S., Dino, G.A., Rossetti, P. (2016). Crowdsourced semantic enrichment for participatory e-government. In Proceedings of the 8th International Conference on Management of Digital EcoSystems, MEDES. Di Mauro, F., Pasteris, P., Sapino, M.L., Candan, K.S., Dino, G.A., Rossetti, P. (2016). Crowdsourced semantic enrichment for participatory e-government. In Proceedings of the 8th International Conference on Management of Digital EcoSystems, MEDES.
go back to reference Di Pinto, F., Lembo, D., Lenzerini, M., Mancin, R., Poggi, A., Rosati, R., Ruzzi, M., Savo, D.F. (2013). Optimizing query rewriting in ontology-based data access. In Proceedings of the 16th international conference on extending database technology, EDBT (pp. 561–572). Di Pinto, F., Lembo, D., Lenzerini, M., Mancin, R., Poggi, A., Rosati, R., Ruzzi, M., Savo, D.F. (2013). Optimizing query rewriting in ontology-based data access. In Proceedings of the 16th international conference on extending database technology, EDBT (pp. 561–572).
go back to reference Garcia-Molina, H., Papakonstantinou, Y., Quass, D., Rajararnan, A., Sagiv, Y., Ullman, J., Vassalos, V., Widom, J. (1997). The tsimmis approach to mediation: Data models and languages. JIIS, pp. 2. Garcia-Molina, H., Papakonstantinou, Y., Quass, D., Rajararnan, A., Sagiv, Y., Ullman, J., Vassalos, V., Widom, J. (1997). The tsimmis approach to mediation: Data models and languages. JIIS, pp. 2.
go back to reference Gottlob, G., Orsi, G., Pieris, A. (2011). Ontological queries: rewriting and optimization. In 2011 IEEE 27th International Conference on Data Engineering (pp. 2–13). Gottlob, G., Orsi, G., Pieris, A. (2011). Ontological queries: rewriting and optimization. In 2011 IEEE 27th International Conference on Data Engineering (pp. 2–13).
go back to reference Kambhampati, S., Lambrecht, E., Nambiar, U., Nie, Z., Senthil, G. (2004). Optimizing recursive information gathering plans in emerac. JIIS, 2(2), 119–153.MATH Kambhampati, S., Lambrecht, E., Nambiar, U., Nie, Z., Senthil, G. (2004). Optimizing recursive information gathering plans in emerac. JIIS, 2(2), 119–153.MATH
go back to reference Kandogan, E., Roth, M., Schwarz, P.M., Hui, J., Terrizzano, I.G., Christodoulakis, C., Miller, R.J. (2015). Labbook: Metadata-driven social collaborative data analysis. In International Conference on Big Data. Kandogan, E., Roth, M., Schwarz, P.M., Hui, J., Terrizzano, I.G., Christodoulakis, C., Miller, R.J. (2015). Labbook: Metadata-driven social collaborative data analysis. In International Conference on Big Data.
go back to reference Levy, A. (1998). The information manifold approach to data integration. IEEE Intelligent Systems, 13, 12–16. Levy, A. (1998). The information manifold approach to data integration. IEEE Intelligent Systems, 13, 12–16.
go back to reference Lim, L., Wang, H., Wang, M. (2013). Semantic queries by example. Proceedings of the 16th International Conference on Extending Database Technology (EDBT 2013). Lim, L., Wang, H., Wang, M. (2013). Semantic queries by example. Proceedings of the 16th International Conference on Extending Database Technology (EDBT 2013).
go back to reference Maedche, A., Staab, S., Studer, R., Sure, Y., Volz, R. (2002). Seal – tying up information integration and web site management by ontologies. IEEE Data Engin. Bulletin, 25(1), 10–17. Maedche, A., Staab, S., Studer, R., Sure, Y., Volz, R. (2002). Seal – tying up information integration and web site management by ontologies. IEEE Data Engin. Bulletin, 25(1), 10–17.
go back to reference Mortensen, J.M., Musen, M. A., Noy, N. F. (2013a). Developing crowdsourced ontology engineering tasks: an iterative process. In Proceedings of the 1st international workshop on crowdsourcing the semantic web, CrowdSem (pp. 79–88). Mortensen, J.M., Musen, M. A., Noy, N. F. (2013a). Developing crowdsourced ontology engineering tasks: an iterative process. In Proceedings of the 1st international workshop on crowdsourcing the semantic web, CrowdSem (pp. 79–88).
go back to reference Mortensen, J.M., Alexander, P.R., Musen, M.A., Noy, N.F. (2013b). Crowdsourcing ontology verification. In Proceedings of the 4th International Conference on Biomedical Ontology, ICBO (pp. 40–45). Mortensen, J.M., Alexander, P.R., Musen, M.A., Noy, N.F. (2013b). Crowdsourcing ontology verification. In Proceedings of the 4th International Conference on Biomedical Ontology, ICBO (pp. 40–45).
go back to reference Munir, K., & Anjum, M.S. (2017). The use of ontologies for effective knowledge modelling and information retrieval. Applied Computing and Informatics, 14(2), 116–126.CrossRef Munir, K., & Anjum, M.S. (2017). The use of ontologies for effective knowledge modelling and information retrieval. Applied Computing and Informatics, 14(2), 116–126.CrossRef
go back to reference Munir, K., Odeh, M., Mcclatchey, R. (2012). Ontology-driven relational query formulation using the semantic and assertional capabilities of OWL-DL. Knowledge-Based Systems, 35, 144–159.CrossRef Munir, K., Odeh, M., Mcclatchey, R. (2012). Ontology-driven relational query formulation using the semantic and assertional capabilities of OWL-DL. Knowledge-Based Systems, 35, 144–159.CrossRef
go back to reference Suárez-Figueroa, M.C., Gómez-Pérez, A., Motta, E., Gangemi, A. (2012). Ontology engineering in a networked world, chapter 2. Berlin: Springer.CrossRef Suárez-Figueroa, M.C., Gómez-Pérez, A., Motta, E., Gangemi, A. (2012). Ontology engineering in a networked world, chapter 2. Berlin: Springer.CrossRef
go back to reference Taylor, N.E., & Ives, Z.G. (2006). Reconciling while tolerating disagreement in collaborative data sharing. In Proceedings SIGMOD06. Taylor, N.E., & Ives, Z.G. (2006). Reconciling while tolerating disagreement in collaborative data sharing. In Proceedings SIGMOD06.
go back to reference Tekli, J., Chbeir, R., Traina, A.J., Traina, C., Yetongnon, K., Ibanez, C.R., Assad, M.A., Kallas, C. (2018). Full-fledged semantic indexing and querying model designed for seamless integration in legacy rdbms. Data and Knowledge Engineering, 117, 133–173.CrossRef Tekli, J., Chbeir, R., Traina, A.J., Traina, C., Yetongnon, K., Ibanez, C.R., Assad, M.A., Kallas, C. (2018). Full-fledged semantic indexing and querying model designed for seamless integration in legacy rdbms. Data and Knowledge Engineering, 117, 133–173.CrossRef
go back to reference Xiao, G., Calvanese, D., Kontchakov, R., Lembo, D., Poggi, A., Rosati, R., Zakharyaschev, M. (2018). Ontology-based data access: a survey. In Proceedings IJCAI-18. Xiao, G., Calvanese, D., Kontchakov, R., Lembo, D., Poggi, A., Rosati, R., Zakharyaschev, M. (2018). Ontology-based data access: a survey. In Proceedings IJCAI-18.
go back to reference Xu, L., & Embley, D.W. (2002). Combining the best of global-as-view and local-as-view for data integration. In ISTA (pp. 123–136). Xu, L., & Embley, D.W. (2002). Combining the best of global-as-view and local-as-view for data integration. In ISTA (pp. 123–136).
go back to reference Ziegler, P., & Dittrich, K.R. (2007). Data integration - problems, approaches, and perspectives. In J. Krogstie, A.L. Opdahl, S. Brinkkemper (Eds.), Conceptual modelling in information systems engineering, chapter 3 (pp. 39–58). Berlin: Springer. Ziegler, P., & Dittrich, K.R. (2007). Data integration - problems, approaches, and perspectives. In J. Krogstie, A.L. Opdahl, S. Brinkkemper (Eds.), Conceptual modelling in information systems engineering, chapter 3 (pp. 39–58). Berlin: Springer.
Metadata
Title
Crowd Sourced Semantic Enrichment (CroSSE) for knowledge driven querying of digital resources
Authors
Giacomo Cavallo
Francesco Di Mauro
Paolo Pasteris
Maria Luisa Sapino
K. Selcuk Candan
Publication date
25-07-2019
Publisher
Springer US
Published in
Journal of Intelligent Information Systems / Issue 3/2019
Print ISSN: 0925-9902
Electronic ISSN: 1573-7675
DOI
https://doi.org/10.1007/s10844-019-00559-8

Other articles of this Issue 3/2019

Journal of Intelligent Information Systems 3/2019 Go to the issue

Premium Partner