P331 - BTW2023- Datenbanksysteme für Business, Technologie und Web

Permanent URI for this collectionhttps://dl.gi.de/handle/20.500.12116/40312

Authors with most Documents  

König-Ries, Birgitta
6
Habich, Dirk
5
Lehner, Wolfgang
4
Binnig, Carsten
3
Hartmann, Claudio
3

Browse

Subject: search.filters.subject.SQL

Search Results

1 - 3 of 3
  • Conference Paper
    To Iterate Is Human, to Recurse Is Divine --- Mapping Iterative Python to Recursive SQL
    (Gesellschaft für Informatik e.V., 2023) Fischer, Tim; König-Ries, Birgitta; Scherzinger, Stefanie; Lehner, Wolfgang; Vossen, Gottfried
    Writing complex algorithms and iterative computations in SQL is difficult at best, commonly leading to code that intermingles looping control flow with database access. This yields programs with control flow that rapidly hops in and out of the database, with each roundtrip incurring significant overhead. We present the ByePy compiler, which can compile entire Python functions directly to plain recursive SQL:1999 queries. By doing so, the compilation eliminates all but a single roundtrip, leading to runtime speedups of up to an order of magnitude.
  • Conference Paper
    Interactive SQL Queries and Program Code in Presentations
    (Gesellschaft für Informatik e.V., 2023) Schildgen, Johannes; Heinz, Florian; König-Ries, Birgitta; Scherzinger, Stefanie; Lehner, Wolfgang; Vossen, Gottfried
    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.
  • Conference Paper
    Semantic Watermarks for Detecting Cheating in Online Database Exams
    (Gesellschaft für Informatik e.V., 2023) Brass, Stefan; Hinneburg, Alexander; König-Ries, Birgitta; Scherzinger, Stefanie; Lehner, Wolfgang; Vossen, Gottfried
    Due to the COVID-19 pandemic,we were forced to conduct the exam for a database course as an online exam.An essential part of the exam was to write non-trivial SQL queries for given tasks.In order to ensure that cheating has a certain risk,we used several techniques to detect cases of plagiarism.One technique was to use a kind of ``watermarks'' invariants of the exercises that are randomly assigned to the students.Each variant is marked by small variationsthat need to be included in submitted solutions.Those markers might go through undetectedwhen a student decides to copy a solution from someone else.In this case,the student would reveal to know a ``secret''that he cannot know without the forbidden communication with another student.This can be used as a proof for plagiarisminstead of just a subjective feeling about the likelihoodof similar solutions without communication.We also used a log of SQL queries that were tried during the exam.Finally,we evaluated similarity-based techniques for SQL plagiarism detection.
Load citations