Logo des Repositoriums

Auflistung nach Autor:in "Heinz, Florian"

1 - 2 von 2
  • Konferenzbeitrag
    Interactive SQL Queries and Program Code in Presentations
    (BTW 2023, 2023) Schildgen, Johannes; Heinz, Florian
    Nowadays, most database lectures are performed with an accompanying visual presentation that further illustrates the conveyed facts. Conventional presentation software allows dynamic elements up to a certain level, for example revealing or changing parts of the slide step by step, or even an interaction with the viewers by means of polls or similar mechanisms. Recently, HTML-and browser-based frameworks for presentations have emerged, which allow an even higher degree of flexibility due to the manifold possibilities of HTML5 and JavaScript. This paper presents an approach of how to interactively modify parts of a slide during the presentation, like SQL-based queries or program code snippets, and show the results pretty-printed on the corresponding slide in real-time. This enables the lecturer to easily show more examples, and answer and illustrate side questions, which they did not prepare in advance.
  • Konferenzbeitrag
    Using SQL/MED to Query Heterogeneous Data Sources with Alexa Voice Commands
    (BTW 2023, 2023) Schildgen, Johannes; Heinz, Florian; Olijnyk, Andreas; Lindenau, Arvid
    Typical Alexa skills and other add-ons for voice assistants need to be custom developed for their one specific use case. This paper presents an approach to map arbitrary data sources (databases, APIs, services) to the relational model by using SQL/MED and to transform voice-based queries into SQL. The key challenges for such a universal skill are to correctly map the natural-language question into a SQL query on the correct source table in the federated database and to convert the result set back to a compact and well-understandable answer.