{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,7,30]],"date-time":"2025-07-30T14:26:12Z","timestamp":1753885572801,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":17,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T00:00:00Z","timestamp":1654992000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,12]]},"DOI":"10.1145\/3531072.3535319","type":"proceedings-article","created":{"date-parts":[[2022,6,7]],"date-time":"2022-06-07T22:09:08Z","timestamp":1654639748000},"page":"10-15","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":9,"title":["Analyzing Student SQL Solutions via Hierarchical Clustering and Sequence Alignment Scores"],"prefix":"10.1145","author":[{"given":"Sophia","family":"Yang","sequence":"first","affiliation":[{"name":"Computer Science, University of Illinois at Urbana-Champaign, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Geoffrey L.","family":"Herman","sequence":"additional","affiliation":[{"name":"Computer Science, University of Illinois at Urbana-Champaign, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Abdussalam","family":"Alawini","sequence":"additional","affiliation":[{"name":"Computer Science, University of Illinois at Urbana-Champaign, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2022,6,12]]},"reference":[{"volume-title":"Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education","author":"Ahadi A.","key":"e_1_3_2_1_1_1","unstructured":"A. Ahadi , J. Prior , V. Behbood , and R. Lister . 2015. A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries . In Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education ( Vilnius, Lithuania) (ITiCSE \u201915). ACM, New York, NY, USA, 201\u2013206. A. Ahadi, J. Prior, V. Behbood, and R. Lister. 2015. A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries. In Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education (Vilnius, Lithuania) (ITiCSE \u201915). ACM, New York, NY, USA, 201\u2013206."},{"key":"e_1_3_2_1_2_1","volume-title":"https:\/\/pypi.org\/project\/sqlparse\/","author":"Albrecht Andi","year":"2020","unstructured":"Andi Albrecht .2020. 0.4.1 ( 2020 ). https:\/\/pypi.org\/project\/sqlparse\/ Andi Albrecht.2020. 0.4.1 (2020). https:\/\/pypi.org\/project\/sqlparse\/"},{"key":"e_1_3_2_1_3_1","volume-title":"Proceedings of the third annual conference on advances in cognitive systems poster collection. 26","author":"Argenta Chris","year":"2015","unstructured":"Chris Argenta and Christopher\u00a0 R Hale . 2015 . Analyzing variation of adaptive game-based training with event sequence alignment and clustering . In Proceedings of the third annual conference on advances in cognitive systems poster collection. 26 . Chris Argenta and Christopher\u00a0R Hale. 2015. Analyzing variation of adaptive game-based training with event sequence alignment and clustering. In Proceedings of the third annual conference on advances in cognitive systems poster collection. 26."},{"volume-title":"Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach. In 2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC), Vol.\u00a001","author":"Cagliero L.","key":"e_1_3_2_1_4_1","unstructured":"L. Cagliero , L. De Russis , L. Farinetti , and T. Montanaro . 2018 . Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach. In 2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC), Vol.\u00a001 . 980\u2013989. L. Cagliero, L. De Russis, L. Farinetti, and T. Montanaro. 2018. Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach. In 2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC), Vol.\u00a001. 980\u2013989."},{"volume-title":"Proceedings of the 14th International Conference on Extending Database Technology","author":"Danaparamita J.","key":"e_1_3_2_1_5_1","unstructured":"J. Danaparamita and W. Gatterbauer . 2011. QueryViz: Helping Users Understand SQL Queries and Their Patterns . In Proceedings of the 14th International Conference on Extending Database Technology ( Uppsala, Sweden) (EDBT\/ICDT \u201911). ACM, New York, NY, USA. J. Danaparamita and W. Gatterbauer. 2011. QueryViz: Helping Users Understand SQL Queries and Their Patterns. In Proceedings of the 14th International Conference on Extending Database Technology (Uppsala, Sweden) (EDBT\/ICDT \u201911). ACM, New York, NY, USA."},{"key":"e_1_3_2_1_6_1","unstructured":"Ashley DiFranza. 2020. 5 Reasons SQL is the Need-to-Know Skill for Data Analysts. (2020).  Ashley DiFranza. 2020. 5 Reasons SQL is the Need-to-Know Skill for Data Analysts. (2020)."},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/MCSE.2007.55"},{"key":"e_1_3_2_1_8_1","volume-title":"Nontraditional Students: Who Are They?SIGCSE Bull. 43, 4 (Dec.","author":"Jinkens C.","year":"2009","unstructured":"Robert\u00a0 C. Jinkens . 2009 . Nontraditional Students: Who Are They?SIGCSE Bull. 43, 4 (Dec. 2009), 979\u2013987. Robert\u00a0C. Jinkens. 2009. Nontraditional Students: Who Are They?SIGCSE Bull. 43, 4 (Dec. 2009), 979\u2013987."},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/273133.274318"},{"key":"e_1_3_2_1_10_1","volume-title":"https:\/\/pypi.org\/project\/natsort\/","author":"Morton M.","year":"2021","unstructured":"Seth\u00a0 M. Morton .2021. 8.0.2 ( 2021 ). https:\/\/pypi.org\/project\/natsort\/ Seth\u00a0M. Morton.2021. 8.0.2 (2021). https:\/\/pypi.org\/project\/natsort\/"},{"key":"e_1_3_2_1_11_1","volume-title":"Algorithms for hierarchical clustering: an overview","author":"Murtagh Fionn","year":"2012","unstructured":"Fionn Murtagh and Pedro Contreras . 2012. Algorithms for hierarchical clustering: an overview . Wiley Interdisciplinary Reviews : Data Mining and Knowledge Discovery 2 ( 2012 ). Fionn Murtagh and Pedro Contreras. 2012. Algorithms for hierarchical clustering: an overview. Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery 2 (2012)."},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-2836(70)90057-4"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"crossref","unstructured":"Frank Nielsen. 2016. Hierarchical Clustering. Springer International Publishing Cham 195\u2013211. https:\/\/doi.org\/10.1007\/978-3-319-21903-5_8  Frank Nielsen. 2016. Hierarchical Clustering. Springer International Publishing Cham 195\u2013211. https:\/\/doi.org\/10.1007\/978-3-319-21903-5_8","DOI":"10.1007\/978-3-319-21903-5_8"},{"volume-title":"Information Security Applications, Jae\u00a0Kwang Lee","author":"Park Jae-Chul","key":"e_1_3_2_1_14_1","unstructured":"Jae-Chul Park and Bong-Nam Noh . 2007. SQL Injection Attack Detection: Profiling of Web Application Parameter Using the Sequence Pairwise Alignment . In Information Security Applications, Jae\u00a0Kwang Lee , Okyeon Yi, and Moti Yung (Eds.). Springer Berlin Heidelberg , Berlin, Heidelberg , 74\u201382. Jae-Chul Park and Bong-Nam Noh. 2007. SQL Injection Attack Detection: Profiling of Web Application Parameter Using the Sequence Pairwise Alignment. In Information Security Applications, Jae\u00a0Kwang Lee, Okyeon Yi, and Moti Yung (Eds.). Springer Berlin Heidelberg, Berlin, Heidelberg, 74\u201382."},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1038\/s41592-019-0686-2"},{"key":"e_1_3_2_1_16_1","unstructured":"Matthew West Geoffrey\u00a0L. Herman and Craig\u00a0B. Zilles. 2015. PrairieLearn: Mastery-based Online Problem Solving with Adaptive Scoring and Recommendations Driven by Machine Learning.  Matthew West Geoffrey\u00a0L. Herman and Craig\u00a0B. Zilles. 2015. PrairieLearn: Mastery-based Online Problem Solving with Adaptive Scoring and Recommendations Driven by Machine Learning."},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/3430895.3460979"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"],"location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22"},"container-title":["1st International Workshop on Data Systems Education"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3531072.3535319","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3531072.3535319","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T19:00:27Z","timestamp":1750186827000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3531072.3535319"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,12]]},"references-count":17,"alternative-id":["10.1145\/3531072.3535319","10.1145\/3531072"],"URL":"https:\/\/doi.org\/10.1145\/3531072.3535319","relation":{},"subject":[],"published":{"date-parts":[[2022,6,12]]},"assertion":[{"value":"2022-06-12","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}