{"id":"https://openalex.org/W4392861661","doi":"https://doi.org/10.1145/3626253.3635408","title":"SQL Query Evaluation with Large Language Model and Abstract Syntax Trees","display_name":"SQL Query Evaluation with Large Language Model and Abstract Syntax Trees","publication_year":2024,"publication_date":"2024-03-14","ids":{"openalex":"https://openalex.org/W4392861661","doi":"https://doi.org/10.1145/3626253.3635408"},"language":"en","primary_location":{"id":"doi:10.1145/3626253.3635408","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626253.3635408","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 2","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/A5005596029","display_name":"Lili Xiang","orcid":"https://orcid.org/0009-0008-4831-6959"},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Lili Xiang","raw_affiliation_strings":["Khoury College of Computer Science, Northeastern University, San Jose, CA, USA"],"affiliations":[{"raw_affiliation_string":"Khoury College of Computer Science, Northeastern University, San Jose, CA, USA","institution_ids":["https://openalex.org/I12912129"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5005596029"],"corresponding_institution_ids":["https://openalex.org/I12912129"],"apc_list":null,"apc_paid":null,"fwci":1.4653,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.81547638,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1890","last_page":"1890"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9685999751091003,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9685999751091003,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9240999817848206,"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/T11719","display_name":"Data Quality and Management","score":0.9212999939918518,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8565714955329895},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.7282050251960754},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6574037671089172},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.650599479675293},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.5838342308998108},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5754363536834717},{"id":"https://openalex.org/keywords/object-query-language","display_name":"Object Query Language","score":0.5528054237365723},{"id":"https://openalex.org/keywords/data-control-language","display_name":"Data control language","score":0.5506283640861511},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5499054789543152},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.5100472569465637},{"id":"https://openalex.org/keywords/abstract-syntax-tree","display_name":"Abstract syntax tree","score":0.47881680727005005},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4652365744113922},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4538303017616272},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4444296061992645},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4276770353317261},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.425322949886322},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.351699560880661},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3447057902812958},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23200145363807678},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.15472817420959473},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.13501861691474915},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.06985783576965332}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8565714955329895},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7282050251960754},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6574037671089172},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.650599479675293},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.5838342308998108},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5754363536834717},{"id":"https://openalex.org/C117667704","wikidata":"https://www.wikidata.org/wiki/Q2011708","display_name":"Object Query Language","level":5,"score":0.5528054237365723},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.5506283640861511},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5499054789543152},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5100472569465637},{"id":"https://openalex.org/C58646249","wikidata":"https://www.wikidata.org/wiki/Q127380","display_name":"Abstract syntax tree","level":3,"score":0.47881680727005005},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4652365744113922},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4538303017616272},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4444296061992645},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4276770353317261},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.425322949886322},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.351699560880661},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3447057902812958},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23200145363807678},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.15472817420959473},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.13501861691474915},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.06985783576965332}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3626253.3635408","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626253.3635408","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 2","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.8299999833106995,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4388053677","https://openalex.org/W2007397391","https://openalex.org/W3025111826","https://openalex.org/W1964555030","https://openalex.org/W3209496184","https://openalex.org/W2506414302","https://openalex.org/W218121808","https://openalex.org/W2158543254","https://openalex.org/W4390215231","https://openalex.org/W2382121680"],"abstract_inverted_index":{"SQL":[0,22,39,76,138,182,204],"stands":[1],"as":[2],"the":[3,16,34,47,58,72,75,127,164,173,180,209],"foundational":[4],"language":[5,95],"for":[6,25,57,70,125],"data":[7],"analysis":[8,87],"and":[9,46,88,108,140,171,212],"manipulation,":[10],"playing":[11],"a":[12,120,137,146],"pivotal":[13],"role":[14],"in":[15,21,30],"database":[17],"learning":[18,210],"process.":[19,214],"Proficiency":[20],"is":[23,65],"essential":[24],"students":[26],"seeking":[27],"to":[28,37,66,112,154,178,191],"excel":[29],"data-related":[31],"fields.":[32],"However,":[33],"conventional":[35],"approaches":[36,170,199],"assessing":[38],"queries":[40,102],"rely":[41],"heavily":[42],"on":[43,136],"manual":[44],"grading,":[45],"automated":[48,203],"assessment":[49,206],"tools":[50],"are":[51,134],"usually":[52],"producing":[53],"only":[54],"binary":[55],"decisions":[56],"submitted":[59],"queries.":[60,77],"Our":[61],"primary":[62],"research":[63,189],"objective":[64],"develop":[67],"effective":[68],"methods":[69],"evaluating":[71],"quality":[73,128],"of":[74,129,175],"To":[78],"meet":[79],"this":[80,188],"objective,":[81],"we":[82,161],"introduce":[83],"two":[84],"approaches:":[85],"structure-based":[86],"evaluation":[89,213],"by":[90,167,196],"an":[91],"instruction":[92],"tuned":[93],"large":[94],"model":[96],"(LLM).":[97],"The":[98,116,156],"first":[99],"approach":[100,118],"deconstructs":[101],"into":[103,200],"Abstract":[104],"Syntax":[105],"Trees":[106],"(AST)":[107],"employs":[109],"cosine":[110],"similarity":[111],"assess":[113],"student":[114,130],"submissions.":[115,131],"second":[117],"utilizes":[119],"pre-trained":[121],"LLM:":[122],"FLAN-T5,":[123],"fine-tuned":[124],"predicting":[126],"These":[132],"methodologies":[133],"tested":[135],"dataset,":[139],"our":[141,201],"experimental":[142,157],"findings":[143],"evaluate":[144],"against":[145],"grading":[147,165],"rubric":[148],"with":[149],"categories":[150],"ranging":[151],"from":[152],"\"good\"":[153],"\"unacceptable\".":[155],"results":[158],"demonstrate":[159],"that":[160],"can":[162],"enhance":[163],"efficiency":[166],"applying":[168],"these":[169,198],"illustrate":[172],"ability":[174],"utilizing":[176],"LLM":[177],"classify":[179],"assessed":[181],"statements":[183],"more":[184],"accurately.":[185],"In":[186],"addition,":[187],"contributes":[190],"Computer":[192],"Science":[193],"(CS)":[194],"education":[195],"integrating":[197],"team's":[202],"statement":[205],"tool,":[207],"improving":[208],"experience":[211]},"counts_by_year":[{"year":2025,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}