{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T17:38:32Z","timestamp":1740159512637,"version":"3.37.3"},"reference-count":36,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2021,3,3]],"date-time":"2021-03-03T00:00:00Z","timestamp":1614729600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2021,3,3]],"date-time":"2021-03-03T00:00:00Z","timestamp":1614729600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/100016135","name":"Universit\u00e4t Passau","doi-asserted-by":"crossref","id":[{"id":"10.13039\/100016135","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Datenbank Spektrum"],"published-print":{"date-parts":[[2021,7]]},"abstract":"<jats:title>Zusammenfassung<\/jats:title><jats:p>In diesem Artikel berichten wir \u00fcber den erstmaligen Einsatz der Software <jats:italic>Praktomat<\/jats:italic> im Rahmen einer einf\u00fchrenden Datenbankvorlesung an der Universit\u00e4t Passau. Unser Ziel war es, den ca. 300 Studierenden aus Informatik und Wirtschaftsinformatik w\u00e4hrend des \u201eCorona-Semesters\u201c die M\u00f6glichkeit zu bieten, Anfragen in relationaler Algebra und SQL im Selbststudium zu \u00fcben und dabei automatisierte R\u00fcckmeldungen zu bekommen. Insbesondere wollten wir kein neues E\u2011Learning-System von Grund auf implementieren, sondern auf einem bestehenden, quelloffenen Werkzeug aufsetzen. Wir beschreiben in diesem Artikel die notwendigen Anpassungen der <jats:italic>Praktomat<\/jats:italic>-Software, urspr\u00fcnglich f\u00fcr die grundst\u00e4ndige Programmierausbildung konzipiert. Wir evaluieren den Zufriedenheitserfolg unserer Studierenden und berichten weiter anekdotisch \u00fcber die Erfahrungen der Studierenden und Lehrenden.<\/jats:p>","DOI":"10.1007\/s13222-021-00374-y","type":"journal-article","created":{"date-parts":[[2021,3,3]],"date-time":"2021-03-03T18:20:09Z","timestamp":1614795609000},"page":"91-98","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Toolunterst\u00fctzung f\u00fcr den \u00dcbungsbetrieb in der Datenbanklehre: Erfahrungen mit der Software Praktomat"],"prefix":"10.1007","volume":"21","author":[{"given":"Christina","family":"Ehrlinger","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Thomas","family":"Fritsch","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2933-5093","authenticated-orcid":false,"given":"Michael","family":"Fruth","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Franz","family":"Lehner","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Stefanie","family":"Scherzinger","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2021,3,3]]},"reference":[{"issue":"2","key":"374_CR1","doi-asserted-by":"publisher","first-page":"181","DOI":"10.1007\/s12599-018-0522-8","volume":"60","author":"S Strecker","year":"2018","unstructured":"Strecker S, Kundisch D, Lehner F, Leimeister JM, Schubert P (2018) Higher education and the opportunities and challenges of educational technology. Bus Inf Syst Eng 60(2):181\u2013189","journal-title":"Bus Inf Syst Eng"},{"key":"374_CR2","unstructured":"Zeller A (1999) Funktionell und verst\u00e4ndlich programmieren \u2013 so lernen es die Passauer. Softwaretech Trend 19(3):29\u201334"},{"key":"374_CR3","first-page":"376","volume-title":"Proc. EUROCAST","author":"H Dobler","year":"2007","unstructured":"Dobler H, Ramler R, Wolfmaier K (2007) A study of tool support for the evaluation of programming exercises. In: Proc. EUROCAST, S 376\u2013383"},{"key":"374_CR4","first-page":"274","volume-title":"Proc. ISKE","author":"B Hass","year":"2019","unstructured":"Hass B, Yuan C, Li Z (2019) On the automatic assessment of learning outcome in programming techniques. In: Proc. ISKE, S 274\u2013278"},{"key":"374_CR5","first-page":"195","volume-title":"Teaching Trends 2018. Die Pr\u00e4senzhochschule und die digitale Transformation","author":"O M\u00fcller","year":"2019","unstructured":"M\u00fcller O, Garmann R, Rod O (2019) Systeme zur automatisierten Bewertung von Programmen und das ProFormA-Aufgabenaustauschformat. In: Teaching Trends 2018. Die Pr\u00e4senzhochschule und die digitale Transformation, S 195\u2013200"},{"key":"374_CR6","first-page":"503","volume-title":"Proc. BTW, LNI","author":"J Kessler","year":"2019","unstructured":"Kessler J, Tschuggnall M, Specht G (2019) RelaX: a webbased execution and learning tool for relational algebra. In: Proc. BTW, LNI, S 503\u2013506"},{"key":"374_CR7","unstructured":"M\u00fche H (2012) IRA \u2013 Interaktive Relationale Algebra. Website, TU M\u00fcnchen. https:\/\/db.in.tum.de\/~muehe\/ira\/ Zugegriffen: 10. Dez. 2020"},{"key":"374_CR8","unstructured":"Yang J (2019) RA (radb): a relational algebra interpreter over relational databases. https:\/\/github.com\/junyang\/radb. Zugegriffen: 10. Dez. 2020"},{"issue":"2","key":"374_CR9","doi-asserted-by":"publisher","first-page":"33","DOI":"10.1145\/3377330.3377336","volume":"48","author":"S Scherzinger","year":"2019","unstructured":"Scherzinger S (2019) Build your own SQL-on-hadoop query engine: a report on a term project in a master-level database course. SIGMOD Rec 48(2):33\u201338","journal-title":"SIGMOD Rec"},{"key":"374_CR10","first-page":"38","volume-title":"Proc. LWDA, CEUR Workshop Proceedings","author":"S Scherzinger","year":"2019","unstructured":"Scherzinger S (2019) Have your students build their own mini hive in just eight weeks. In: Proc. LWDA, CEUR Workshop Proceedings, Bd. 2454, S 38\u201341"},{"issue":"29","key":"374_CR11","first-page":"5","volume":"9","author":"TC Rakow","year":"2009","unstructured":"Rakow TC, Faeskorn-Woyke H, Schiefer B, Vossen G, W\u00e4sch J (2009) Tools f\u00fcr die Lehre im Fach Datenbanken. Datenbank Spektrum 9(29):5\u201313","journal-title":"Datenbank Spektrum"},{"key":"374_CR12","doi-asserted-by":"crossref","unstructured":"Obivonwu V, Broneske D, Hawiltschek A, K\u00f6ppen V, Saake G (2020) SQLValidator \u2013 An Online Student Playground to Learn SQL. Tech. rep. https:\/\/propra14.iti.cs.ovgu.de\/sqlvali\/index.php. Zugegriffen: 22. Dez. 2020","DOI":"10.1007\/s13222-021-00372-0"},{"issue":"12","key":"374_CR13","doi-asserted-by":"publisher","first-page":"2997","DOI":"10.14778\/3415478.3415528","volume":"13","author":"Z Miao","year":"2020","unstructured":"Miao Z, Chen T, Bendeck A, Day K, Roy S, Yang J (2020) I\u2011rex: an interactive relational query explainer for SQL. Proc VLDB Endow 13(12):2997\u20133000","journal-title":"Proc VLDB Endow"},{"key":"374_CR14","first-page":"503","volume-title":"Proc. SIGMOD","author":"Z Miao","year":"2019","unstructured":"Miao Z, Roy S, Yang J (2019) Explaining wrong queries using small examples. In: Proc. SIGMOD, S 503\u2013520"},{"issue":"12","key":"374_CR15","doi-asserted-by":"publisher","first-page":"1872","DOI":"10.14778\/2824032.2824089","volume":"8","author":"T M\u00fcller","year":"2015","unstructured":"M\u00fcller T, Grust T (2015) Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile. Proc VLDB Endow 8(12):1872\u20131875","journal-title":"Proc VLDB Endow"},{"key":"374_CR16","volume-title":"Proc. TaPP","author":"D O\u2019Grady","year":"2018","unstructured":"O\u2019Grady D, M\u00fcller T, Grust T (2018) How \u2019how\u2019 explains what \u2019what\u2019 computes \u2013 how-provenance for SQL and query compilers. In: Proc. TaPP"},{"key":"374_CR17","volume-title":"Automatisierte Bewertung in der Programmierausbildung","author":"OJ Bott","year":"2017","unstructured":"Bott OJ, Fricke P, Priss U, Striewe M (2017) Automatisierte Bewertung in der Programmierausbildung. Waxmann,"},{"key":"374_CR18","unstructured":"Krinke J, St\u00f6rzer M, Zeller A (2002) Web-basierte Programmierpraktika mit Praktomat. Softwaretech Trend 22(3): S 6"},{"key":"374_CR19","first-page":"159","volume-title":"Automatisierte Bewertung in der Programmierausbildung, Digitale Medien in der Hochschullehre","author":"J Breitner","year":"2017","unstructured":"Breitner J, Hecker M, Snelting G (2017) Der Grader Praktomat. In: Automatisierte Bewertung in der Programmierausbildung, Digitale Medien in der Hochschullehre, S 159\u2013172"},{"issue":"5","key":"374_CR20","doi-asserted-by":"publisher","first-page":"630","DOI":"10.1016\/j.jss.2005.06.028","volume":"79","author":"S Brass","year":"2006","unstructured":"Brass S, Goldberg C (2006) Semantic errors in SQL queries: a quite complete list. J\u00a0Syst Softw 79(5):630\u2013644","journal-title":"J Syst Softw"},{"key":"374_CR21","first-page":"198","volume-title":"Proc. SIGCSE","author":"T Taipalus","year":"2019","unstructured":"Taipalus T, Per\u00e4l\u00e4 PMH (2019) What to expect and what to focus on in SQL query teaching. In: Proc. SIGCSE, S 198\u2013203"},{"key":"374_CR22","volume-title":"Proc. ABP, CEUR Workshop Proceedings","author":"M Kruse","year":"2013","unstructured":"Kruse M, Jensen N (2013) Automatische Bewertung von Datenbankaufgaben unter Verwendung von LON- CAPA und Praktomat. In: Proc. ABP, CEUR Workshop Proceedings"},{"key":"374_CR23","unstructured":"Widom J (2014) Database Mini-Courses. Online Kurs. https:\/\/cs.stanford.edu\/people\/widom\/DB-mooc.html. Zugegriffen: 10. Dez. 2020"},{"key":"374_CR24","volume-title":"Evaluating training programs: the four levels","author":"DL Kirkpatrick","year":"1994","unstructured":"Kirkpatrick DL (1994) Evaluating training programs: the four levels. Berrett-Koehler,"},{"key":"374_CR25","first-page":"805","volume-title":"Proc. MKWI","author":"M Scholz","year":"2014","unstructured":"Scholz M, Lehner F, Dorner V (2014) A Respecification of the DeLone and mclean model to measure the success of an electronic mediated learning systems. In: Proc. MKWI, S 805\u2013819"},{"issue":"4","key":"374_CR26","doi-asserted-by":"publisher","first-page":"9","DOI":"10.1080\/07421222.2003.11045748","volume":"19","author":"WH Delone","year":"2003","unstructured":"Delone WH, McLean ER (2003) The delone and mclean model of information systems success: a ten-year update. J\u00a0Manag Inf Syst 19(4):9\u201330","journal-title":"J Manag Inf Syst"},{"issue":"6","key":"374_CR27","doi-asserted-by":"publisher","first-page":"817","DOI":"10.1089\/cpb.2007.9948","volume":"10","author":"HF Lin","year":"2007","unstructured":"Lin HF (2007) Measuring online learning systems success: applying the updated delone and mclean model. Cyberpsychology Behav 10(6):817\u2013820","journal-title":"Cyberpsychology Behav"},{"key":"374_CR28","volume-title":"Taxonomy of educational objectives: the classification of educational goals","author":"B Bloom","year":"1956","unstructured":"Bloom B, Krathwohl D, Masia B (1956) Taxonomy of educational objectives: the classification of educational goals Bd. 1"},{"key":"374_CR29","first-page":"53","volume":"63","author":"S Dekeyser","year":"2007","unstructured":"Dekeyser S, de Raadt M, Lee TY (2007) Computer assisted assessment of SQL query skills. Proc Adc CRPIT 63:53\u201362","journal-title":"Proc Adc CRPIT"},{"key":"374_CR30","volume-title":"Proc. ASEE Annual Conference and Exposition","author":"Q Do","year":"2014","unstructured":"Do Q, Agrawal R, Rao D, Gudivada V (2014) Automatic generation of SQL queries. In: Proc. ASEE Annual Conference and Exposition"},{"key":"374_CR31","unstructured":"Bidgood J, Merrill JB (2017) As computer coding classes swell, so does cheating. New York Times. https:\/\/www.nytimes.com\/2017\/05\/29\/us\/computer-science-cheating.html. Zugegriffen: 10. Dez. 2020"},{"issue":"11","key":"374_CR32","first-page":"1016","volume":"8","author":"L Prechelt","year":"2002","unstructured":"Prechelt L, Malpohl G, Philippsen M (2002) Finding plagiarisms among a set of programs with JPlag. J\u00a0Univers Comput Sci 8(11):1016","journal-title":"J Univers Comput Sci"},{"key":"374_CR33","first-page":"46","volume-title":"Proc. TLAD","author":"G Russell","year":"2005","unstructured":"Russell G, Cumming A (2005) Online assessment and checking of SQL: detecting and plagiarism. In: Proc. TLAD, S 46\u201350"},{"key":"374_CR34","first-page":"321","volume-title":"Proc. ICL","author":"N Scerbakov","year":"2017","unstructured":"Scerbakov N, Schukin A, Sabinin O (2017) Plagiarism detection in SQL student assignments. In: Proc. ICL, S 321\u2013326"},{"key":"374_CR35","first-page":"6:1","volume-title":"Proc. UKICER","author":"A Kleerekoper","year":"2019","unstructured":"Kleerekoper A, Schofield A (2019) The False-Positive Rate of Automated Plagiarism Detection for SQL Assessments. In: Proc. UKICER, S 6:1\u20136:6"},{"key":"374_CR36","first-page":"15","volume-title":"Proc. CSEDU","author":"N Kratzke","year":"2019","unstructured":"Kratzke N (2019) Smart like a fox: how clever students trick dumb automated programming assignment assessment systems. In: Proc. CSEDU, S 15\u201326"}],"container-title":["Datenbank-Spektrum"],"original-title":[],"language":"de","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-021-00374-y.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s13222-021-00374-y\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-021-00374-y.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,8,6]],"date-time":"2021-08-06T10:33:13Z","timestamp":1628245993000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s13222-021-00374-y"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,3,3]]},"references-count":36,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2021,7]]}},"alternative-id":["374"],"URL":"https:\/\/doi.org\/10.1007\/s13222-021-00374-y","relation":{},"ISSN":["1618-2162","1610-1995"],"issn-type":[{"type":"print","value":"1618-2162"},{"type":"electronic","value":"1610-1995"}],"subject":[],"published":{"date-parts":[[2021,3,3]]},"assertion":[{"value":"4 November 2020","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"20 January 2021","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 February 2021","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"3 March 2021","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}