{"id":"https://openalex.org/W3172255581","doi":"https://doi.org/10.1145/3430895.3460979","title":"Analyzing Patterns in Student SQL Solutions via Levenshtein Edit Distance","display_name":"Analyzing Patterns in Student SQL Solutions via Levenshtein Edit Distance","publication_year":2021,"publication_date":"2021-06-07","ids":{"openalex":"https://openalex.org/W3172255581","doi":"https://doi.org/10.1145/3430895.3460979","mag":"3172255581"},"language":"en","primary_location":{"id":"doi:10.1145/3430895.3460979","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3430895.3460979","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth ACM Conference on Learning @ Scale","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/A5022587958","display_name":"Sophia Yang","orcid":"https://orcid.org/0000-0003-1274-4851"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sophia Yang","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Champaign, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Champaign, IL, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038925711","display_name":"Ziyuan Wei","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ziyuan Wei","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Champaign, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Champaign, IL, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038676484","display_name":"Geoffrey Herman","orcid":"https://orcid.org/0000-0002-9501-2295"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Geoffrey L. Herman","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Champaign, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Champaign, IL, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014235464","display_name":"Abdussalam Alawini","orcid":"https://orcid.org/0000-0003-1106-7190"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Abdussalam Alawini","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Champaign, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Champaign, IL, USA","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":1.6789,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.86900689,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"323","last_page":"326"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9994000196456909,"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"}},{"id":"https://openalex.org/T10636","display_name":"Innovative Teaching and Learning Methods","score":0.9952999949455261,"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.9825999736785889,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8737632632255554},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8521865606307983},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.7214230298995972},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5993078947067261},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5151368379592896},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.484527051448822},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4490993320941925},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.43662041425704956},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42805570363998413},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.42295217514038086},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4200914204120636},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3316679000854492},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.27790987491607666}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8737632632255554},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8521865606307983},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7214230298995972},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5993078947067261},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5151368379592896},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.484527051448822},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4490993320941925},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.43662041425704956},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42805570363998413},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.42295217514038086},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4200914204120636},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3316679000854492},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27790987491607666},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3430895.3460979","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3430895.3460979","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth ACM Conference on Learning @ Scale","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7099999785423279}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W43076228","https://openalex.org/W2071100465"],"related_works":["https://openalex.org/W151073879","https://openalex.org/W2750425440","https://openalex.org/W2512476881","https://openalex.org/W3021637214","https://openalex.org/W638381921","https://openalex.org/W2240099544","https://openalex.org/W2898367493","https://openalex.org/W2738342198","https://openalex.org/W2917505743","https://openalex.org/W4238156210"],"abstract_inverted_index":{"Structured":[0],"Query":[1],"Language":[2],"(SQL),":[3],"the":[4,45,82,88,99,131,163],"standard":[5],"language":[6],"for":[7,16,37,162],"relational":[8],"database":[9],"management":[10],"systems,":[11],"is":[12,30],"an":[13],"essential":[14],"skill":[15],"software":[17],"developers,":[18],"data":[19],"scientists,":[20],"and":[21,33,106,118,148,165],"professionals":[22],"who":[23],"need":[24],"to":[25,39,49,58,78,110,137,143],"interact":[26],"with":[27],"databases.":[28],"SQL":[29,48,63,76,139,160,169],"highly":[31],"structured":[32],"presents":[34],"diverse":[35],"ways":[36],"learners":[38],"acquire":[40],"this":[41,71],"skill.":[42],"However,":[43],"despite":[44],"significance":[46],"of":[47,81,90],"other":[50],"related":[51],"fields,":[52],"little":[53],"research":[54],"has":[55],"been":[56],"done":[57],"understand":[59,111],"how":[60,112,119],"students":[61,113,167],"learn":[62,168],"as":[64],"they":[65,120],"work":[66],"on":[67],"homework":[68,79],"assignments.":[69],"In":[70],"paper,":[72],"we":[73,97],"analyze":[74],"students'":[75,135],"submissions":[77,136],"problems":[80],"Database":[83],"Systems":[84],"course":[85],"offered":[86],"at":[87,92],"University":[89],"Illinois":[91],"Urbana-Champaign.":[93],"For":[94],"each":[95],"student,":[96],"compute":[98],"Levenshtein":[100],"Edit":[101],"Distances":[102],"between":[103,134],"every":[104],"submission":[105,109],"their":[107,115,125,156],"final":[108,116],"reached":[114],"solution":[117],"overcame":[121],"any":[122],"obstacles":[123],"in":[124,158],"learning":[126,146],"process.":[127],"Our":[128],"system":[129],"visualizes":[130],"edit":[132],"distances":[133],"a":[138],"problem,":[140],"enabling":[141],"instructors":[142,154],"identify":[144],"interesting":[145],"patterns":[147],"approaches.":[149],"These":[150],"findings":[151],"will":[152],"help":[153,166],"target":[155],"instruction":[157],"difficult":[159],"areas":[161],"future":[164],"more":[170],"effectively.":[171]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":2}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}