{"id":"https://openalex.org/W4414654298","doi":"https://doi.org/10.1145/3769852","title":"LearnSQL: Impact of an Automatic Judge in Database Learning","display_name":"LearnSQL: Impact of an Automatic Judge in Database Learning","publication_year":2025,"publication_date":"2025-09-30","ids":{"openalex":"https://openalex.org/W4414654298","doi":"https://doi.org/10.1145/3769852"},"language":"en","primary_location":{"id":"doi:10.1145/3769852","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3769852","pdf_url":null,"source":{"id":"https://openalex.org/S2764465379","display_name":"ACM Transactions on Computing Education","issn_l":"1946-6226","issn":["1946-6226"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Computing Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5028123043","display_name":"Enrique Martin-Martin","orcid":"https://orcid.org/0000-0002-1664-018X"},"institutions":[{"id":"https://openalex.org/I121748325","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045","country_code":"ES","type":"education","lineage":["https://openalex.org/I121748325"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Enrique Martin-Martin","raw_affiliation_strings":["Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","Universidad Complutense de Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0002-1664-018X","affiliations":[{"raw_affiliation_string":"Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]},{"raw_affiliation_string":"Universidad Complutense de Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103062711","display_name":"Manuel Montenegro","orcid":"https://orcid.org/0000-0002-9686-465X"},"institutions":[{"id":"https://openalex.org/I121748325","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045","country_code":"ES","type":"education","lineage":["https://openalex.org/I121748325"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Manuel Montenegro","raw_affiliation_strings":["Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","Universidad Complutense de Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0002-9686-465X","affiliations":[{"raw_affiliation_string":"Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]},{"raw_affiliation_string":"Universidad Complutense de Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048720165","display_name":"Adri\u00e1n Riesco","orcid":"https://orcid.org/0000-0002-9716-4612"},"institutions":[{"id":"https://openalex.org/I121748325","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045","country_code":"ES","type":"education","lineage":["https://openalex.org/I121748325"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Adri\u00e1n Riesco","raw_affiliation_strings":["Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","Universidad Complutense de Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0002-9716-4612","affiliations":[{"raw_affiliation_string":"Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]},{"raw_affiliation_string":"Universidad Complutense de Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5094095435","display_name":"Rub\u00e9n Rubio","orcid":"https://orcid.org/0000-0003-2983-3404"},"institutions":[{"id":"https://openalex.org/I121748325","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045","country_code":"ES","type":"education","lineage":["https://openalex.org/I121748325"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Rub\u00e9n Rubio","raw_affiliation_strings":["Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","Universidad Complutense de Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0003-2983-3404","affiliations":[{"raw_affiliation_string":"Dpto. Sistemas Inform\u00e1ticos y Computaci\u00f3n, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]},{"raw_affiliation_string":"Universidad Complutense de Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5046988140","display_name":"Fernando S\u00e1enz-P\u00e9rez","orcid":"https://orcid.org/0000-0001-6075-4398"},"institutions":[{"id":"https://openalex.org/I121748325","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045","country_code":"ES","type":"education","lineage":["https://openalex.org/I121748325"]},{"id":"https://openalex.org/I97750245","display_name":"Software (Spain)","ror":"https://ror.org/02ethns06","country_code":"ES","type":"company","lineage":["https://openalex.org/I4210087817","https://openalex.org/I97750245"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Fernando S\u00e1enz-P\u00e9rez","raw_affiliation_strings":["Dpto. Ingenier\u00eda del Software e Inteligencia Artificial, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","Universidad Complutense de Madrid, Spain"],"raw_orcid":"https://orcid.org/0000-0001-6075-4398","affiliations":[{"raw_affiliation_string":"Dpto. Ingenier\u00eda del Software e Inteligencia Artificial, Facultad de Inform\u00e1tica, Universidad Complutense de Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I121748325","https://openalex.org/I97750245"]},{"raw_affiliation_string":"Universidad Complutense de Madrid, Spain","institution_ids":["https://openalex.org/I121748325"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.26703411,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"26","issue":"1","first_page":"1","last_page":"37"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9702000021934509,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9702000021934509,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.964900016784668,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9358999729156494,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.47679999470710754},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.39149999618530273},{"id":"https://openalex.org/keywords/semi-automatic","display_name":"Semi automatic","score":0.3862999975681305},{"id":"https://openalex.org/keywords/higher-education","display_name":"Higher education","score":0.30230000615119934},{"id":"https://openalex.org/keywords/fully-automatic","display_name":"Fully automatic","score":0.2721000015735626}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8004999756813049},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.47679999470710754},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46070000529289246},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.39149999618530273},{"id":"https://openalex.org/C3017741341","wikidata":"https://www.wikidata.org/wiki/Q1047852","display_name":"Semi automatic","level":2,"score":0.3862999975681305},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3479999899864197},{"id":"https://openalex.org/C120912362","wikidata":"https://www.wikidata.org/wiki/Q136822","display_name":"Higher education","level":2,"score":0.30230000615119934},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.28850001096725464},{"id":"https://openalex.org/C3019831412","wikidata":"https://www.wikidata.org/wiki/Q5778278","display_name":"Fully automatic","level":2,"score":0.2721000015735626},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.25060001015663147},{"id":"https://openalex.org/C2778625365","wikidata":"https://www.wikidata.org/wiki/Q5227393","display_name":"Database application","level":2,"score":0.25029999017715454}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3769852","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3769852","pdf_url":null,"source":{"id":"https://openalex.org/S2764465379","display_name":"ACM Transactions on Computing Education","issn_l":"1946-6226","issn":["1946-6226"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Computing Education","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5488409164","display_name":null,"funder_award_id":"INNOVA-Docencia 2020-21/18 and 2021-22/387","funder_id":"https://openalex.org/F4320321585","funder_display_name":"Universidad Complutense de Madrid"}],"funders":[{"id":"https://openalex.org/F4320321585","display_name":"Universidad Complutense de Madrid","ror":"https://ror.org/02p0gd045"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W30495410","https://openalex.org/W1512840853","https://openalex.org/W1526703352","https://openalex.org/W1536708336","https://openalex.org/W1793692183","https://openalex.org/W1869234223","https://openalex.org/W1990112237","https://openalex.org/W1999389087","https://openalex.org/W2049258042","https://openalex.org/W2131653381","https://openalex.org/W2132516581","https://openalex.org/W2156086800","https://openalex.org/W2221289407","https://openalex.org/W2573894086","https://openalex.org/W2753439427","https://openalex.org/W2786372958","https://openalex.org/W2789990417","https://openalex.org/W2809284492","https://openalex.org/W2885090162","https://openalex.org/W2911054143","https://openalex.org/W2914184225","https://openalex.org/W2963384866","https://openalex.org/W3028243744","https://openalex.org/W3037883989","https://openalex.org/W3041823931","https://openalex.org/W3084167506","https://openalex.org/W3086342064","https://openalex.org/W3092848728","https://openalex.org/W3100612072","https://openalex.org/W3117409070","https://openalex.org/W3177923307","https://openalex.org/W3181583505","https://openalex.org/W4211066152","https://openalex.org/W4213170345","https://openalex.org/W4213421742","https://openalex.org/W4244719017","https://openalex.org/W4250471797","https://openalex.org/W4252692452","https://openalex.org/W4299627282","https://openalex.org/W4381550868","https://openalex.org/W4391266222","https://openalex.org/W4393262094","https://openalex.org/W4400224603","https://openalex.org/W4401879597","https://openalex.org/W6948928597"],"related_works":[],"abstract_inverted_index":{"Databases":[0],"are":[1,18,82,151],"a":[2,13,55,63,109,231],"key":[3],"topic":[4],"in":[5,87,108,125,138,210,225,230],"many":[6,22],"technical":[7],"university":[8],"degrees.":[9],"As":[10],"databases":[11],"have":[12,54,120,197],"strong":[14],"practical":[15],"nature,":[16],"students":[17,158,181,229],"expected":[19],"to":[20,53,66,85],"solve":[21],"exercises":[23,59],"before":[24],"mastering":[25],"the":[26,33,88,96,122,130,134,140,155,162,175,179,183,186,201,204,208],"different":[27],"aspects":[28],"involved:":[29],"querying":[30],"and":[31,39,41,68,78],"modifying":[32],"database,":[34],"writing":[35],"procedural":[36],"code":[37],"(functions":[38],"procedures),":[40],"defining":[42],"triggers,":[43],"among":[44],"others.":[45],"In":[46,91],"this":[47,92,117,217],"scenario,":[48],"it":[49],"is":[50,207,219],"very":[51],"important":[52],"substantial":[56],"number":[57],"of":[58,99,161,203,212],"available":[60],"but":[61],"also":[62,198],"timely":[64],"feedback":[65,81],"detect":[67],"fix":[69],"mistakes.":[70],"Therefore,":[71],"automatic":[72,103,131,141,163,184,205],"judges":[73],"that":[74,148,178,216],"execute":[75],"students\u2019":[76],"solutions":[77],"generate":[79],"immediate":[80],"valuable":[83],"tools":[84],"include":[86],"teaching":[89],"practice.":[90],"article,":[93],"we":[94,119,196],"assess":[95],"real":[97],"impact":[98,170,202],"using":[100],"an":[101,167],"online":[102],"judge":[104,142,206],"for":[105],"free":[106],"practice":[107],"database":[110,172,232],"course":[111],"over":[112],"four":[113],"academic":[114,127],"years.":[115],"For":[116],"purpose,":[118],"contrasted":[121],"marks":[123,150,190],"obtained":[124],"one":[126],"year,":[128],"without":[129],"judge,":[132,164,185],"against":[133],"three":[135],"following":[136],"years":[137,156],"which":[139],"was":[143],"used.":[144],"The":[145],"results":[146,176],"show":[147,177],"final":[149,189],"statistically":[152],"higher":[153,187],"during":[154],"when":[157,222],"make":[159],"use":[160,182],"thus":[165],"showing":[166],"overall":[168],"positive":[169],"on":[171],"learning.":[173],"Similarly,":[174],"more":[180],"their":[188],"are.":[191],"Besides":[192],"these":[193],"two":[194],"insights,":[195],"studied":[199],"if":[200],"same":[209],"groups":[211],"high-profile":[213],"students,":[214],"concluding":[215],"tool":[218],"less":[220],"effective":[221],"improving":[223],"learning":[224],"top-performing,":[226],"highly":[227],"self-motivated":[228],"course.":[233]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}