research-article Open Access Share on Identifying SQL misconceptions of novices: findings from a think-aloud study Authors: Daphne Miedema Eindhoven University Technology TechnologyView Profile , Efthimia Aivaloglou Universiteit UniversiteitView George Fletcher Authors Info & Claims ACM InroadsVolume 13Issue 1March 2022 pp 52–65https://doi.org/10.1145/3514214Online:14 February 2022Publication H...

Zusammenfassung Mit PowerPoint oder LaTeX Beamer erstellte Vorlesungsfolien sind meist statisch und dienen hauptsächlich der Präsentation von Lehrinhalten. Als Alternative dazu werden drei Erweiterungen für das HTML- JavaScript-basierte Präsentationsframework reveal.js vorgestellt, die mehr Interaktion in Datenbankenlehre sorgen sollen: (1) Eine Live-Ausführung SQL-Anfragen eine Darstellung des...

In cyberspace, there exists a prevalent problem that heavily occurs to web application databases and is the exploitation of websites by using SQL injection attacks. This kind attack becomes more difficult when it comes blind vulnerabilities. this paper, we will first make use vulnerability, subsequently, build an ontology (OBSQL) address detection weakness. Therefore, achieve exploitation, repr...

Current search engines can hardly cope adequately with fuzzy predicates defined by complex preferences. The biggest problem of search engines implemented with standard SQL is that SQL does not directly understand the notion of preferences. Preference SQL extends SQL by a preference model based on strict partial orders (presented in more detail in the companion paper [Kie02]), where preference q...

Most recently, there has been significant interest in learning contextual representations for various NLP tasks, by leveraging large scale text corpora to train powerful language models with self-supervised objectives, such as Masked Language Model (MLM). Based on a pilot study, we observe three issues of existing general-purpose when they are applied the text-to-SQL semantic parsers: fail dete...

We present the SQL Performance Analyzer, a novel approach in Oracle Database 11g to testing database changes, such as upgrades, parameter changes, schema changes, and gathering optimizer statistics. The SQL Performance Analyzer offers a comprehensive solution to enable users to forecast and analyze how a system change will impact SQL query plans and run time performance, so they can tune their ...