License: Creative Commons Attribution 4.0 International license (CC BY 4.0)
When quoting this document, please refer to the following
DOI: 10.4230/OASIcs.SLATE.2023.6
URN: urn:nbn:de:0030-drops-185202
URL: http://dagstuhl.sunsite.rwth-aachen.de/volltexte/2023/18520/
Seipel, Dietmar ;
Förster, Benjamin ;
Liebl, Magnus ;
Waleska, Marcel ;
Abreu, Salvador
Querying Relational Databases with Speech-Recognition Driven by Contextual Knowledge
Abstract
We are extending the keyword-based query interface DdQl for relational databases which is based on contextual background knowledge such as suitable join conditions and which was proposed in [{Dietmar Seipel, 2021]. In the previous paper, join conditions were extracted from existing referential integrity (foreign key) constraints of the database schema, or they could be learned from other, previous database queries.
In this paper, we describe a speech-to-text component for entering the query keywords based on the system Whisper. Keywords, which have been recognized wrongly by Whisper can be corrected to similarly sounding words. Again, the context of the database schema can help here.
For users with a limited knowledge of the schema and the contents of the database, the approach of DdQl can help to provide useful suggestions for query implementations in Sql or Datalog, from which the user can choose one. Our tool DdQl can be run in a docker image; it yields the possible queries in Sql and a special domain specific rule language that extends Datalog. The Datalog variant allows for additional user-defined aggregation functions which are not possible in Sql.
BibTeX - Entry
@InProceedings{seipel_et_al:OASIcs.SLATE.2023.6,
author = {Seipel, Dietmar and F\"{o}rster, Benjamin and Liebl, Magnus and Waleska, Marcel and Abreu, Salvador},
title = {{Querying Relational Databases with Speech-Recognition Driven by Contextual Knowledge}},
booktitle = {12th Symposium on Languages, Applications and Technologies (SLATE 2023)},
pages = {6:1--6:15},
series = {Open Access Series in Informatics (OASIcs)},
ISBN = {978-3-95977-291-4},
ISSN = {2190-6807},
year = {2023},
volume = {113},
editor = {Sim\~{o}es, Alberto and Ber\'{o}n, Mario Marcelo and Portela, Filipe},
publisher = {Schloss Dagstuhl -- Leibniz-Zentrum f{\"u}r Informatik},
address = {Dagstuhl, Germany},
URL = {https://drops.dagstuhl.de/opus/volltexte/2023/18520},
URN = {urn:nbn:de:0030-drops-185202},
doi = {10.4230/OASIcs.SLATE.2023.6},
annote = {Keywords: Knowledge Bases, Natural Language Interface, Logic Programming, Definite Clause Grammars, Referential Integrity Constraints, Speech-to-Text}
}