{"id":"https://openalex.org/W1576906273","doi":"https://doi.org/10.1109/icde.2015.7113403","title":"The XDa-TA system for automated grading of SQL query assignments","display_name":"The XDa-TA system for automated grading of SQL query assignments","publication_year":2015,"publication_date":"2015-04-01","ids":{"openalex":"https://openalex.org/W1576906273","doi":"https://doi.org/10.1109/icde.2015.7113403","mag":"1576906273"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2015.7113403","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113403","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","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/A5037327726","display_name":"Amol Bhangdiya","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Amol Bhangdiya","raw_affiliation_strings":["SAP Labs, India"],"affiliations":[{"raw_affiliation_string":"SAP Labs, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022413715","display_name":"Bikash Chandra","orcid":"https://orcid.org/0000-0001-6855-2985"},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Bikash Chandra","raw_affiliation_strings":["IIT Bombay"],"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051499886","display_name":"Biplab Kar","orcid":null},"institutions":[{"id":"https://openalex.org/I4210165642","display_name":"Oracle (India)","ror":"https://ror.org/05dd0pt55","country_code":"IN","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210165642"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Biplab Kar","raw_affiliation_strings":["Oracle India Pvt. Ltd"],"affiliations":[{"raw_affiliation_string":"Oracle India Pvt. Ltd","institution_ids":["https://openalex.org/I4210165642"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008940539","display_name":"Bharath Radhakrishnan","orcid":null},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Bharath Radhakrishnan","raw_affiliation_strings":["IIT Bombay"],"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113498032","display_name":"K. Vishal Reddy","orcid":null},"institutions":[{"id":"https://openalex.org/I1317621060","display_name":"Indian Institute of Technology Guwahati","ror":"https://ror.org/0022nd079","country_code":"IN","type":"education","lineage":["https://openalex.org/I1317621060"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"K. V. Maheshwara Reddy","raw_affiliation_strings":["Indian Institute of Technology Guwahati, Guwahati, Assam, IN"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Guwahati, Guwahati, Assam, IN","institution_ids":["https://openalex.org/I1317621060"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102162085","display_name":"Shetal Shah","orcid":null},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shetal Shah","raw_affiliation_strings":["IIT Bombay"],"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081847962","display_name":"S. Sudarshan","orcid":"https://orcid.org/0000-0002-6230-2288"},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"S. Sudarshan","raw_affiliation_strings":["IIT Bombay"],"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5037327726"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.7653,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.89470295,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1468","last_page":"1471"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.9879000186920166,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10126","display_name":"Logic, programming, and type systems","score":0.9657999873161316,"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/computer-science","display_name":"Computer science","score":0.865530252456665},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.808988630771637},{"id":"https://openalex.org/keywords/grading","display_name":"Grading (engineering)","score":0.7049970626831055},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5839630365371704},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5442294478416443},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4455717206001282},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3839194178581238},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3763558268547058},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3604890704154968},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.32592710852622986},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2546347677707672},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12885373830795288}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.865530252456665},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.808988630771637},{"id":"https://openalex.org/C2777286243","wikidata":"https://www.wikidata.org/wiki/Q5591926","display_name":"Grading (engineering)","level":2,"score":0.7049970626831055},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5839630365371704},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5442294478416443},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4455717206001282},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3839194178581238},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3763558268547058},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3604890704154968},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.32592710852622986},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2546347677707672},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12885373830795288},{"id":"https://openalex.org/C147176958","wikidata":"https://www.wikidata.org/wiki/Q77590","display_name":"Civil engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2015.7113403","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113403","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.8299999833106995}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1512840853","https://openalex.org/W1967798658","https://openalex.org/W2131231258","https://openalex.org/W2295144739","https://openalex.org/W4253178675","https://openalex.org/W6697193939"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2031915568","https://openalex.org/W2955368753","https://openalex.org/W2356335648","https://openalex.org/W2362460270","https://openalex.org/W2371740287","https://openalex.org/W2554271401","https://openalex.org/W2406556739","https://openalex.org/W2970853428","https://openalex.org/W4379390531"],"abstract_inverted_index":{"Grading":[0],"of":[1,100,105,151,159],"student":[2,28,101],"SQL":[3,59,71],"queries":[4,68,102,108],"is":[5,93],"usually":[6],"done":[7,95],"by":[8,24,53,96,131],"executing":[9],"the":[10,31,46,73,76,98,106],"query":[11,29,33,60],"on":[12],"sample":[13],"datasets":[14,82,118],"(which":[15,34],"may":[16],"be":[17,36,51,125,150],"unable":[18],"to":[19,79,87,154,157],"catch":[20,88],"many":[21],"errors)":[22],"and/or":[23],"manually":[25],"comparing/checking":[26],"a":[27,128],"with":[30,103,139],"correct":[32,67,107],"can":[35,50,114,123,135],"tedious":[37],"and":[38,55],"error":[39],"prone).":[40],"In":[41],"this":[42],"demonstration":[43],"we":[44],"present":[45],"XDa-TA":[47],"system":[48,78],"which":[49],"used":[52,126],"instructors":[54,113,155,158],"TAs":[56],"for":[57,69,119,144],"grading":[58,92],"assignments":[61],"automatically.":[62],"Given":[63],"one":[64],"or":[65],"more":[66],"an":[70],"assignment,":[72],"tool":[74,122,148],"uses":[75],"XData":[77],"automatically":[80],"generate":[81],"that":[83],"are":[84],"designed":[85],"specifically":[86],"common":[89],"errors.":[90],"The":[91,121],"then":[94],"comparing":[97],"results":[99],"those":[104],"against":[109],"these":[110],"generated":[111],"datasets;":[112],"optionally":[115],"provide":[116,136],"additional":[117],"testing.":[120],"also":[124],"in":[127],"learning":[129],"mode":[130],"students,":[132],"where":[133],"it":[134],"immediate":[137],"feedback":[138],"hints":[140],"explaining":[141],"possible":[142],"reasons":[143],"erroneous":[145],"output.":[146],"This":[147],"could":[149],"great":[152],"value":[153],"particularly,":[156],"MOOCs.":[160]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
