Boosting the Querying Accuracy of Multi-Level Occupancy Data with Ontology-Guided LLMs

Stefan Neubig (), Rahul Radhakrishnan, Linus Göhl, Ronja Loges, Madalina Polgar, Andreas Hein and Helmut Krcmar
Additional contact information
Stefan Neubig: Outdooractive AG
Rahul Radhakrishnan: Outdooractive AG
Linus Göhl: Outdooractive AG
Ronja Loges: Outdooractive AG
Madalina Polgar: Outdooractive AG
Andreas Hein: University of St. Gallen
Helmut Krcmar: Technical University of Munich

A chapter in Information and Communication Technologies in Tourism 2025, 2025, pp 51-63 from Springer

Abstract: Abstract As overtourism and local overcrowding are becoming increasingly critical concerns, determining and predicting occupancy levels based on real-time data and predictive models that serve as a decision-making basis for necessary countermeasures are gaining popularity. Moreover, with the rise of large language models (LLMs), approaches that automate related data access have become tempting. However, real-world databases are often inherently complex and heterogeneously structured, complicating using LLM-based text-to-SQL. Previous studies report an accuracy of only 16%, which indicates the need for better approaches. This paper investigates how ontologies can support LLMs in increasing the accuracy of querying real-world databases. Based on the need to reduce overcrowding, we propose an ontology for modeling complex, multi-level occupancy data. Our ontology, based on previous work, is theoretically well-founded and compatible with existing tourism ontologies. In a case study based on a real-world database from Outdooractive, one of the largest European outdoor tourism platforms, we compare vanilla LLM-based text-to-SQL's performance with ontology-based data access. Our results show that the ontology-based approach almost triples the querying accuracy, which illustrates the effectiveness and potential of such semantic approaches.

Keywords: Smart tourism; Visitor management; Occupancy prediction; Ontologies; Knowledge graphs; Large language models (search for similar items in EconPapers)
Date: 2025
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:prbchp:978-3-031-83705-0_5

Ordering information: This item can be ordered from
http://www.springer.com/9783031837050

DOI: 10.1007/978-3-031-83705-0_5

Access Statistics for this chapter

More chapters in Springer Proceedings in Business and Economics from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().