{"id":"https://openalex.org/W4300616186","doi":"https://doi.org/10.1109/compsac54236.2022.00027","title":"SQL Murder Mystery: a serious game to learn querying databases","display_name":"SQL Murder Mystery: a serious game to learn querying databases","publication_year":2022,"publication_date":"2022-06-01","ids":{"openalex":"https://openalex.org/W4300616186","doi":"https://doi.org/10.1109/compsac54236.2022.00027"},"language":"en","primary_location":{"id":"doi:10.1109/compsac54236.2022.00027","is_oa":false,"landing_page_url":"https://doi.org/10.1109/compsac54236.2022.00027","pdf_url":null,"source":{"id":"https://openalex.org/S4363607883","display_name":"2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC)","raw_type":"proceedings-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/A5007698952","display_name":"Lorenzo Canale","orcid":"https://orcid.org/0000-0002-7556-595X"},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Polytechnic University of Turin","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Lorenzo Canale","raw_affiliation_strings":["Politecnico di Torino,Torino,Italy","Politecnico di Torino, Torino, Italy"],"affiliations":[{"raw_affiliation_string":"Politecnico di Torino,Torino,Italy","institution_ids":["https://openalex.org/I177477856"]},{"raw_affiliation_string":"Politecnico di Torino, Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008223229","display_name":"Laura Farinetti","orcid":"https://orcid.org/0000-0001-8614-4192"},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Polytechnic University of Turin","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Laura Farinetti","raw_affiliation_strings":["Politecnico di Torino,Torino,Italy","Politecnico di Torino, Torino, Italy"],"affiliations":[{"raw_affiliation_string":"Politecnico di Torino,Torino,Italy","institution_ids":["https://openalex.org/I177477856"]},{"raw_affiliation_string":"Politecnico di Torino, Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5007698952"],"corresponding_institution_ids":["https://openalex.org/I177477856"],"apc_list":null,"apc_paid":null,"fwci":3.4736,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.93286713,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"129","last_page":"138"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9933000206947327,"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/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9847000241279602,"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/session","display_name":"Session (web analytics)","score":0.8300598859786987},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.776187539100647},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.755077600479126},{"id":"https://openalex.org/keywords/serious-game","display_name":"Serious game","score":0.5377106666564941},{"id":"https://openalex.org/keywords/exploratory-research","display_name":"Exploratory research","score":0.5050142407417297},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.4360054135322571},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.369101881980896},{"id":"https://openalex.org/keywords/multimedia","display_name":"Multimedia","score":0.3429378271102905}],"concepts":[{"id":"https://openalex.org/C2779182362","wikidata":"https://www.wikidata.org/wiki/Q17126187","display_name":"Session (web analytics)","level":2,"score":0.8300598859786987},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.776187539100647},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.755077600479126},{"id":"https://openalex.org/C3018769082","wikidata":"https://www.wikidata.org/wiki/Q1506693","display_name":"Serious game","level":2,"score":0.5377106666564941},{"id":"https://openalex.org/C85973986","wikidata":"https://www.wikidata.org/wiki/Q1091731","display_name":"Exploratory research","level":2,"score":0.5050142407417297},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4360054135322571},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.369101881980896},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.3429378271102905},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/compsac54236.2022.00027","is_oa":false,"landing_page_url":"https://doi.org/10.1109/compsac54236.2022.00027","pdf_url":null,"source":{"id":"https://openalex.org/S4363607883","display_name":"2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4099999964237213,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W222568289","https://openalex.org/W2021265033","https://openalex.org/W2023745308","https://openalex.org/W2087879225","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2293990718","https://openalex.org/W2400038930","https://openalex.org/W2493946644","https://openalex.org/W2502626378","https://openalex.org/W2524230755","https://openalex.org/W2736304355","https://openalex.org/W2748454491","https://openalex.org/W2887678261","https://openalex.org/W2908720855","https://openalex.org/W2954940357","https://openalex.org/W3037285559","https://openalex.org/W3109705051","https://openalex.org/W3180707269","https://openalex.org/W4251054599","https://openalex.org/W4253772050","https://openalex.org/W4294572622","https://openalex.org/W6727569133","https://openalex.org/W6832653193"],"related_works":["https://openalex.org/W4230197055","https://openalex.org/W4296749040","https://openalex.org/W621808327","https://openalex.org/W644007644","https://openalex.org/W2497198634","https://openalex.org/W3012257603","https://openalex.org/W1586784764","https://openalex.org/W4292264782","https://openalex.org/W1559289099","https://openalex.org/W3016450995"],"abstract_inverted_index":{"What":[0,3],"is":[1,4,7,11,18],"serious?":[2],"funny?":[5],"Who":[6,10],"a":[8,12,48,73,80],"player?":[9],"student?":[13],"But,":[14],"most":[15],"importantly,":[16],"who":[17],"the":[19,53,95,99,126,138,141,145,150],"murderer?":[20],"Serious":[21],"games":[22,39],"are":[23,134],"gaining":[24],"an":[25],"ever":[26],"increasing":[27],"interest":[28],"in":[29,72,83,87,125],"education":[30],"and":[31,33,68,111,128],"training,":[32],"recent":[34],"studies":[35],"have":[36],"used":[37],"board":[38,55],"as":[40],"inspirational.":[41],"This":[42,58],"study":[43],"introduces":[44],"SQL":[45,66,117,131],"Murder":[46],"Mystery,":[47],"serious":[49],"game":[50,56,59,127,139],"inspired":[51],"by":[52,101],"popular":[54],"Cluedo.":[57],"has":[60,69],"been":[61,70],"designed":[62],"to":[63,93,112,143,152],"assess":[64],"students'":[65],"skills":[67],"tested":[71],"university":[74],"database":[75],"management":[76],"system":[77],"course":[78],"during":[79],"lab":[81],"session":[82],"which":[84],"students":[85],"played":[86],"teams.":[88],"Query":[89],"logs":[90],"were":[91],"examined":[92],"explore":[94],"behavioural":[96],"patterns":[97],"of":[98,105,130,149],"teams,":[100],"distinguishing":[102],"different":[103],"categories":[104],"queries:":[106],"exploratory,":[107],"focused,":[108],"review":[109],"queries,":[110],"relate":[113],"behaviour":[114],"with":[115],"specific":[116],"learning":[118,132],"goals.":[119],"The":[120],"analysis":[121],"revealed":[122],"that":[123],"success":[124],"fulfilment":[129],"goals":[133],"correlated.":[135],"In":[136],"addition,":[137],"helped":[140],"instructors":[142],"identify":[144],"major":[146],"knowledge":[147],"gaps":[148],"students,":[151],"allow":[153],"on-time":[154],"recovery.":[155]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1}],"updated_date":"2026-04-22T08:38:42.863108","created_date":"2025-10-10T00:00:00"}