{"id":"https://openalex.org/W2546758670","doi":"https://doi.org/10.14778/3007263.3007304","title":"Partial marking for automated grading of SQL queries","display_name":"Partial marking for automated grading of SQL queries","publication_year":2016,"publication_date":"2016-09-01","ids":{"openalex":"https://openalex.org/W2546758670","doi":"https://doi.org/10.14778/3007263.3007304","mag":"2546758670"},"language":"en","primary_location":{"id":"doi:10.14778/3007263.3007304","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3007263.3007304","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051371338","display_name":"Mathew Joseph","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":"Mathew Joseph","raw_affiliation_strings":["IIT Bombay"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021661943","display_name":"Shreevidhya Acharya","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":"Shreevidhya Acharya","raw_affiliation_strings":["IIT Bombay"],"raw_orcid":null,"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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IIT Bombay","institution_ids":["https://openalex.org/I162827531"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I162827531"],"apc_list":null,"apc_paid":null,"fwci":1.6417,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.8539626,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"9","issue":"13","first_page":"1541","last_page":"1544"},"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.996399998664856,"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.996399998664856,"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.9807000160217285,"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.9390000104904175,"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.8490901589393616},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7309974431991577},{"id":"https://openalex.org/keywords/grading","display_name":"Grading (engineering)","score":0.6986696720123291},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6372342705726624},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5384765267372131},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5116060376167297},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.48484551906585693},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.46032610535621643},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.45811834931373596},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4352087080478668},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.361491322517395},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.30970653891563416},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12838485836982727}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8490901589393616},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7309974431991577},{"id":"https://openalex.org/C2777286243","wikidata":"https://www.wikidata.org/wiki/Q5591926","display_name":"Grading (engineering)","level":2,"score":0.6986696720123291},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6372342705726624},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5384765267372131},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5116060376167297},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.48484551906585693},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.46032610535621643},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.45811834931373596},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4352087080478668},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.361491322517395},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.30970653891563416},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12838485836982727},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C147176958","wikidata":"https://www.wikidata.org/wiki/Q77590","display_name":"Civil engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3007263.3007304","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3007263.3007304","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.7799999713897705,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1512840853","https://openalex.org/W1576906273","https://openalex.org/W2131231258","https://openalex.org/W2158050820","https://openalex.org/W2211823484","https://openalex.org/W2295144739","https://openalex.org/W6678110065","https://openalex.org/W7027717352"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W319014924","https://openalex.org/W1003283331","https://openalex.org/W2406556739","https://openalex.org/W2970853428","https://openalex.org/W2353434938","https://openalex.org/W2128834514","https://openalex.org/W2186703450","https://openalex.org/W2148814251","https://openalex.org/W227397245"],"abstract_inverted_index":{"The":[0],"XData":[1,30,105],"system,":[2],"currently":[3],"being":[4,97],"developed":[5],"at":[6],"IIT":[7],"Bombay,":[8],"provides":[9],"an":[10],"automated":[11],"and":[12,155],"interactive":[13],"platform":[14],"for":[15,23],"grading":[16,61,143,147],"student":[17,54,62,118,133],"SQL":[18,149],"queries,":[19],"as":[20,22,163],"well":[21],"learning":[24],"SQL.":[25],"Prior":[26],"work":[27],"on":[28,33,90],"the":[29,53,78,93,104,146],"system":[31,106,121,144],"focused":[32],"generating":[34],"query":[35,74,79,94,134],"specific":[36],"test":[37,46],"cases":[38,47],"to":[39,50,69,86,96,116,124,151,157],"catch":[40],"common":[41],"errors":[42],"in":[43],"queries.":[44,119],"These":[45,139],"are":[48,56],"used":[49],"check":[51,71],"whether":[52],"queries":[55,150],"correct":[57,137],"or":[58],"not.":[59],"For":[60],"assignments,":[63],"it":[64],"is":[65,75,80,95,122],"usually":[66],"not":[67],"sufficient":[68],"just":[70],"if":[72,77],"a":[73,132,136],"correct:":[76],"incorrect,":[81],"partial":[82,114],"marks":[83,115],"may":[84],"need":[85],"be":[87,152],"given,":[88],"depending":[89],"how":[91],"close":[92],"correct.":[98],"In":[99],"this":[100],"paper,":[101],"we":[102],"extend":[103],"by":[107],"adding":[108],"features":[109,129,140],"that":[110],"enable":[111],"awarding":[112],"of":[113,141,148,165],"incorrect":[117],"Our":[120],"able":[123],"go":[125],"beyond":[126],"numerous":[127],"syntactic":[128],"when":[130],"comparing":[131],"with":[135],"query.":[138],"our":[142],"allow":[145],"fully":[153],"automated,":[154],"scalable":[156],"even":[158],"large":[159],"class":[160],"sizes":[161],"such":[162],"those":[164],"MOOCs.":[166]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}