Skip to main content

DBSpark: A System for Natural Language to SPARQL Translation

  • Conference paper
  • First Online:
Research Challenges in Information Science: Information Science and the Connected World (RCIS 2023)

Abstract

Knowledge bases offer clear advantages when compared to traditional databases, mainly due to semantic connections and automated reasoning over large datasets. However, limited knowledge of the specialized knowledge base query language (SPARQL) makes it difficult for most users to freely access these resources. To solve this issue, we propose a question-answering system able to translate natural language questions into SPARQL queries. The presented method is a rule-based approach that integrates information regarding dependency and constituency parsing, WordNet and named entity recognition to capture the structural and semantic representation of the question. The proposed solution is able to handle a wide variety of question types (list, count, yes/no, wh-questions, questions involving rankings, ordinals, and/or superlatives). Moreover, all involved steps except the phrase mapping phase (in which properties and entities from the ontological model are mapped to words from the natural language question) are knowledge base independent. Tests performed over the QALD-9 question-answering dataset using the DBpedia knowledge base have shown that our system obtains state-of-the-art results and a very good time-performance balance.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 79.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://wordnet.princeton.edu/documentation/.

  2. 2.

    https://www.dbpedia.org/.

  3. 3.

    https://www.wikidata.org/wiki/Wikidata:Main_Page.

  4. 4.

    https://qald.aksw.org/.

  5. 5.

    https://spacy.io/.

  6. 6.

    https://pypi.org/project/word2number/.

  7. 7.

    https://pypi.org/project/geonamescache/.

  8. 8.

    https://www.mpi-inf.mpg.de/departments/databases-and-information-systems/research/yago-naga/patty.

  9. 9.

    https://pypi.org/project/sparqlwrapper/.

References

  1. Berners-Lee, T., Hendler, J., Lassila, O.: The semantic web. Sci. Am. 284(5), 34–43 (2001). https://doi.org/10.1038/scientificamerican0501-34

    Article  Google Scholar 

  2. Wang, C., Xiong, M., Zhou, Q., Yu, Y.: PANTO: a portable natural language interface to ontologies. In: Franconi, E., Kifer, M., May, W. (eds.) The Semantic Web: Research and Applications. LNCS, vol. 4519, pp. 473–487. Springer, Heidelberg (2007). https://doi.org/10.1007/978-3-540-72667-8_34

    Chapter  Google Scholar 

  3. Ochieng, P.: PAROT: translating natural language to SPARQL. Expert Syst. Appl. 176, 114712 (2021). https://doi.org/10.1016/j.eswa.2021.114712

    Article  Google Scholar 

  4. Liang, S., Stockinger, K., de Farias, T.M., Anisimova, M., Gil, M.: Querying knowledge graphs in natural language. J. Big Data 8(1), 1–23 (2021). https://doi.org/10.1186/s40537-020-00383-w

    Article  Google Scholar 

  5. Lehmann, J., Bühmann, L.: AutoSPARQL: let users query your knowledge base. In: Antoniou, G., et al. (eds.) The Semantic Web: Research and Applications. LNCS, vol. 6643, pp. 63–79. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-21034-1_5

    Chapter  Google Scholar 

  6. Jin, H., Luo, Y., Gao, C., Tang, X., Yuan, P.: ComQA: question answering over knowledge base via semantic matching. IEEE Access 7, 75235–75246 (2019). https://doi.org/10.1109/ACCESS.2019.2918675

    Article  Google Scholar 

  7. Dorobăţ, I.C., Posea, V.: onIQ: an ontology-independent natural language interface for Building SPARQL queries. In: 2020 IEEE 16th International Conference on Intelligent Computer Communication and Processing (ICCP), September 2020, pp. 139–144 (2020). https://doi.org/10.1109/ICCP51029.2020.9266272

  8. Damljanovic, D., Agatonovic, M., Cunningham, H.: FREyA: an interactive way of querying linked data using natural language. In: García-Castro, R., Fensel, D., Antoniou, G. (eds.) The Semantic Web: ESWC 2011 Workshops. LNCS, vol. 7117, pp. 125–138. Springer, Heidelberg (2012). https://doi.org/10.1007/978-3-642-25953-1_11

    Chapter  Google Scholar 

  9. Damljanovic, D., Tablan, V., Bontcheva, K.: A text-based query interface to OWL Ontologies. In: Proceedings of the Sixth International Conference on Language Resources and Evaluation (LREC 2008), Marrakech, Morocco, May 2008. Accessed 18 Oct 2022. http://www.lrec-conf.org/proceedings/lrec2008/pdf/64_paper.pdf

  10. Ferré, S.: Sparklis: an expressive query builder for SPARQL endpoints with guidance in natural language. Semant. Web 8, 405–418 (2017). https://doi.org/10.3233/SW-150208

    Article  Google Scholar 

  11. Hu, C., Ren, G., Liu, C., Li, M., Jie, W.: A Spark-based genetic algorithm for sensor placement in large scale drinking water distribution systems. Clust. Comput. 20(2), 1089–1099 (2017). https://doi.org/10.1007/s10586-017-0838-z

    Article  Google Scholar 

  12. Usbeck, R., Ngomo, A.-C., Haarmann, B., Krithara, A., Röder, M., Napolitano, G.: 7th Open challenge on question answering over linked data (QALD-7). In: Dragoni, M., Solanki, M., Blomqvist, E. (eds.) Semantic Web Challenges. CCIS, vol. 769, pp. 59–69. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-69146-6_6

    Chapter  Google Scholar 

  13. Dubey, M., Banerjee, D., Chaudhuri, D., Lehmann, J.: EARL: joint entity and relation linking for question answering over knowledge graphs. In: Vrandečić, D., et al. (eds.) The Semantic Web – ISWC 2018. LNCS, vol. 11136, pp. 108–126. Springer, Cham (2018). https://doi.org/10.1007/978-3-030-00671-6_7

    Chapter  Google Scholar 

  14. Sakor, A., Singh, K., Patel, A., Vidal, M.-E.: Falcon 2.0: an entity and relation linking tool over Wikidata. In: Proceedings of 29th ACM International Conference on Information and Knowledge Management, pp. 3141–3148, October 2020. https://doi.org/10.1145/3340531.3412777

  15. Ferragina, P., Scaiella, U.: TAGME: on-the-fly annotation of short text fragments (by wikipedia entities). In: Proceedings of the 19th ACM International Conference on Information and Knowledge Management - CIKM 2010, Toronto, ON, Canada, 2010, p. 1625. https://doi.org/10.1145/1871437.1871689

  16. Mendes, M., Jakob, A., García-Silva, A., Bizer, C.: DBpedia spotlight: shedding light on the web of documents. In: Proceedings of the 7th International Conference on Semantic Systems - I-Semantics 2011, Graz, Austria, 2011, pp. 1–8. https://doi.org/10.1145/2063518.2063519

  17. Unger, C., Usbeck, R.: QALD datasets. Semantic Computing Group@Bielefeld University, 02 October 2022. Accessed 18 Oct 2022. https://github.com/ag-sc/QALD

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Laura-Maria Cornei .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Cornei, LM., Trandabat, D. (2023). DBSpark: A System for Natural Language to SPARQL Translation. In: Nurcan, S., Opdahl, A.L., Mouratidis, H., Tsohou, A. (eds) Research Challenges in Information Science: Information Science and the Connected World. RCIS 2023. Lecture Notes in Business Information Processing, vol 476. Springer, Cham. https://doi.org/10.1007/978-3-031-33080-3_10

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-33080-3_10

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-33079-7

  • Online ISBN: 978-3-031-33080-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics