{"id":"https://openalex.org/W2809686080","doi":"https://doi.org/10.1109/compsac.2018.00174","title":"Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach","display_name":"Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach","publication_year":2018,"publication_date":"2018-06-22","ids":{"openalex":"https://openalex.org/W2809686080","doi":"https://doi.org/10.1109/compsac.2018.00174","mag":"2809686080"},"language":"en","primary_location":{"id":"doi:10.1109/compsac.2018.00174","doi":"https://doi.org/10.1109/compsac.2018.00174","is_oa":false,"landing_page_url":"https://doi.org/10.1109/compsac.2018.00174","pdf_url":null,"source":{"id":"https://openalex.org/S4210194295","display_name":"IEEE Annual International Computer Software and Applications Conference (COMPSAC)","issn_l":"0730-3157","issn":["0730-3157"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://iris.polito.it/bitstream/11583/2709321/1/PID5373909.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5001746215","display_name":"Luca Cagliero","orcid":"https://orcid.org/0000-0002-7185-5247","observed_orcids":["https://orcid.org/0000-0002-7185-5247"]},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Luca Cagliero","raw_affiliation_strings":["Politecnico di Torino, Torino, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Torino, Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023909289","display_name":"Luigi De Russis","orcid":"https://orcid.org/0000-0001-7647-6652","observed_orcids":["https://orcid.org/0000-0001-7647-6652"]},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Luigi De Russis","raw_affiliation_strings":["Politecnico di Torino, Torino, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Torino, Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008223229","display_name":"Laura Farinetti","orcid":"https://orcid.org/0000-0001-8614-4192","observed_orcids":["https://orcid.org/0000-0001-8614-4192"]},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Torino, Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015936759","display_name":"Teodoro Montanaro","orcid":"https://orcid.org/0000-0003-1750-8268","observed_orcids":["https://orcid.org/0000-0003-1750-8268"]},"institutions":[{"id":"https://openalex.org/I2800599128","display_name":"Istituto Superiore Mario Boella","ror":"https://ror.org/05y6jfx28","country_code":"IT","type":"facility","lineage":["https://openalex.org/I2800599128","https://openalex.org/I4210155299"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Teodoro Montanaro","raw_affiliation_strings":["Istituto Superiore Mario Boella, Torino, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Istituto Superiore Mario Boella, Torino, Italy","institution_ids":["https://openalex.org/I2800599128"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.4156,"has_fulltext":true,"cited_by_count":11,"citation_normalized_percentile":{"value":0.79483726,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"980","last_page":"989"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.8583999872207642,"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.8583999872207642,"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/T10533","display_name":"Teaching and Learning Programming","score":0.10740000009536743,"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.022299999371170998,"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/sql-learning","display_name":"SQL learning","score":0.8700000047683716},{"id":"https://openalex.org/keywords/database-course","display_name":"database course","score":0.6700000166893005},{"id":"https://openalex.org/keywords/teaching-assistants","display_name":"teaching assistants","score":0.9169999957084656},{"id":"https://openalex.org/keywords/student-misconceptions","display_name":"student misconceptions","score":0.546999990940094},{"id":"https://openalex.org/keywords/student-behavior-analysis","display_name":"student behavior analysis","score":0.527999997138977},{"id":"https://openalex.org/keywords/educational-analytics","display_name":"educational analytics","score":0.3540000021457672}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7891256213188171},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7250820994377136},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5903242230415344},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4983377456665039},{"id":"https://openalex.org/C37789001","wikidata":"https://www.wikidata.org/wiki/Q782543","display_name":"Graphical user interface","level":2,"score":0.4639973044395447},{"id":"https://openalex.org/C2778365744","wikidata":"https://www.wikidata.org/wiki/Q2426689","display_name":"Learning environment","level":2,"score":0.4614521265029907},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.44986605644226074},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.4248647093772888},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.361283540725708},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2547033429145813},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.22773024439811707},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.10288667678833008},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09206995368003845},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/compsac.2018.00174","doi":"https://doi.org/10.1109/compsac.2018.00174","is_oa":false,"landing_page_url":"https://doi.org/10.1109/compsac.2018.00174","pdf_url":null,"source":{"id":"https://openalex.org/S4210194295","display_name":"IEEE Annual International Computer Software and Applications Conference (COMPSAC)","issn_l":"0730-3157","issn":["0730-3157"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC)","raw_type":"proceedings-article"},{"id":"pmh:oai:iris.polito.it:11583/2709321","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/11583/2709321","pdf_url":"https://iris.polito.it/bitstream/11583/2709321/1/PID5373909.pdf","source":{"id":"https://openalex.org/S7407055329","display_name":"PORTO@Iris","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:iris.unisalento.it:11587/506548","doi":null,"is_oa":false,"landing_page_url":"https://hdl.handle.net/11587/506548","pdf_url":null,"source":{"id":"https://openalex.org/S7407055257","display_name":"AIRUS","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:iris.polito.it:11583/2709321","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/11583/2709321","pdf_url":"https://iris.polito.it/bitstream/11583/2709321/1/PID5373909.pdf","source":{"id":"https://openalex.org/S7407055329","display_name":"PORTO@Iris","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[{"score":0.975600004196167,"display_name":"Quality education","id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2809686080.pdf","grobid_xml":"https://content.openalex.org/works/W2809686080.grobid-xml"},"referenced_works_count":10,"referenced_works":["https://openalex.org/W1492147539","https://openalex.org/W2023745308","https://openalex.org/W2039958052","https://openalex.org/W2050781086","https://openalex.org/W2071100465","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2151724878","https://openalex.org/W2473995384","https://openalex.org/W2754850149"],"related_works":["https://openalex.org/W4366964219","https://openalex.org/W1498833802","https://openalex.org/W4294658813","https://openalex.org/W1578611055","https://openalex.org/W3094396153","https://openalex.org/W2344117420","https://openalex.org/W4280554137","https://openalex.org/W1597181312","https://openalex.org/W7206159593","https://openalex.org/W4411307058"],"abstract_inverted_index":{"Most":[0],"engineering":[1],"courses":[2],"include":[3],"fundamental":[4],"practice":[5,99],"activities":[6],"to":[7,43,51,86,126,178,181,192,211,233],"be":[8],"performed":[9,228],"by":[10,148],"students":[11,18,62,187],"in":[12,76,165],"computer":[13],"labs.":[14],"During":[15],"lab":[16,57],"sessions,":[17],"work":[19],"on":[20,177,195],"solving":[21,166],"exercises":[22],"with":[23,138],"the":[24,53,56,61,64,69,77,88,93,127,132,154,157,163,167,171,183,186,189,203,205,208,213,220,223,230,235],"help":[25,234],"of":[26,55,79,129,159,185,225],"teaching":[27,65,136],"assistants,":[28],"who":[29],"often":[30],"have":[31,193],"a":[32,37,48,80,97,139],"hard":[33],"time":[34],"for":[35,118,122],"guaranteeing":[36],"timely,":[38],"optimized,":[39],"and":[40,63,74,110,112,121,162,180,191,199,207],"\"democratic\"":[41],"support":[42,87],"everybody.":[44],"This":[45],"paper":[46,221],"presents":[47,222],"learning":[49,89],"environment":[50,70,90],"improve":[52],"experience":[54],"sessions":[58],"participants,":[59],"both":[60,117],"assistants.":[66],"In":[67],"particular,":[68],"was":[71],"designed,":[72],"implemented,":[73],"experimented":[75],"context":[78],"database":[81],"course.":[82],"The":[83],"application":[84,133],"designed":[85],"stores":[91],"all":[92],"events":[94],"occurring":[95],"during":[96,188],"SQL":[98],"lab,":[100,190],"i.e.,":[101],"task":[102],"progression,":[103],"query":[104],"submissions,":[105],"error":[106],"feedback,":[107],"assistance":[108,144],"requests":[109],"interventions,":[111],"it":[113],"provides":[114,135],"information":[115],"useful":[116],"use":[119],"on-the-fly":[120],"later":[123,176],"analysis.":[124],"Thanks":[125],"analysis":[128],"these":[130],"data,":[131,232],"dynamically":[134],"assistants":[137],"graphical":[140],"interface":[141],"highlighting":[142],"where":[143],"is":[145],"most":[146],"needed,":[147],"considering":[149],"different":[150,226],"factors":[151],"such":[152],"as":[153],"progression":[155],"rate,":[156],"percentage":[158],"correct":[160],"solutions,":[161],"difficulties":[164],"current":[168],"exercise.":[169],"Furthermore,":[170],"stored":[172],"data":[173],"allow":[174],"teachers":[175],"analyze":[179],"interpret":[182],"behavior":[184],"insights":[194],"their":[196],"main":[197],"mistakes":[198],"misconceptions.":[200],"After":[201],"describing":[202],"environment,":[204],"interfaces,":[206],"approaches":[209],"used":[210],"identify":[212],"students'":[214,239],"teams":[215],"that":[216],"need":[217],"timely":[218],"assistance,":[219],"results":[224],"analyses":[227],"using":[229],"collected":[231],"teacher":[236],"better":[237],"understand":[238],"educational":[240],"needs.":[241]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3}],"updated_date":"2026-10-26T11:51:55.731654","created_date":"2018-06-29T00:00:00"}