Sirvi Autor "Konnula, Herbert" järgi

Tulemuste filtreerimiseks trükkige paar esimest tähte
Nüüd näidatakse 1 - 1 1
  • Pisipilt
    listelement.badge.dso-type Kirje ,
    PostgreSQL logifailide analüsaatori edasiarendus ning SQL-lausetes tehtud vigade analüüs
    (Tartu Ülikool, 2025) Konnula, Herbert; Luik, Piret, juhendaja; Lepp, Marina, juhendaja; Tartu Ülikool. Loodus- ja täppisteaduste valdkond; Tartu Ülikool. Arvutiteaduse instituut
    The log files of PostgreSQL contain a lot of information that instructors can use to analyze how students reached a given goal. Since manual log file analysis is time-consuming, a web application was built in 2024 to automate the process. The goal of this thesis was to further develop the application to make log file analysis more convenient and effective. The application was used with log files from the Databases course (spring 2025) to identify the types of errors students made while learning SQL. The results showed that 41% of the SQL statements contained at least one error, with the most common mistakse related to constraint violations or issues with SQL syntax.