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/
Go to the corresponding OASIcs Volume Portal


Seipel, Dietmar ; Förster, Benjamin ; Liebl, Magnus ; Waleska, Marcel ; Abreu, Salvador

Querying Relational Databases with Speech-Recognition Driven by Contextual Knowledge

pdf-format:
OASIcs-SLATE-2023-6.pdf (0.6 MB)


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}
}

Keywords: Knowledge Bases, Natural Language Interface, Logic Programming, Definite Clause Grammars, Referential Integrity Constraints, Speech-to-Text
Collection: 12th Symposium on Languages, Applications and Technologies (SLATE 2023)
Issue Date: 2023
Date of publication: 15.08.2023
Supplementary Material: Software (Source Code): https://gitlab2.informatik.uni-wuerzburg.de/Wissensbasierte-Systeme/declare/declare.git archived at: https://archive.softwareheritage.org/swh:1:dir:fc9f1d42f6306261bee5a7fae45776845d7b1025


DROPS-Home | Fulltext Search | Imprint | Privacy Published by LZI