{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,18]],"date-time":"2025-10-18T10:43:16Z","timestamp":1760784196964},"reference-count":7,"publisher":"Association for Computing Machinery (ACM)","issue":"13","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2016,9]]},"abstract":"<jats:p>The XData system, currently being developed at IIT Bombay, provides an automated and interactive platform for grading student SQL queries, as well as for learning SQL. Prior work on the XData system focused on generating query specific test cases to catch common errors in queries. These test cases are used to check whether the student queries are correct or not. For grading student assignments, it is usually not sufficient to just check if a query is correct: if the query is incorrect, partial marks may need to be given, depending on how close the query is to being correct. In this paper, we extend the XData system by adding features that enable awarding of partial marks to incorrect student queries. Our system is able to go beyond numerous syntactic features when comparing a student query with a correct query. These features of our grading system allow the grading of SQL queries to be fully automated, and scalable to even large class sizes such as those of MOOCs.<\/jats:p>","DOI":"10.14778\/3007263.3007304","type":"journal-article","created":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T13:47:47Z","timestamp":1478008067000},"page":"1541-1544","source":"Crossref","is-referenced-by-count":11,"title":["Partial marking for automated grading of SQL queries"],"prefix":"10.14778","volume":"9","author":[{"given":"Bikash","family":"Chandra","sequence":"first","affiliation":[{"name":"IIT Bombay"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mathew","family":"Joseph","sequence":"additional","affiliation":[{"name":"IIT Bombay"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bharath","family":"Radhakrishnan","sequence":"additional","affiliation":[{"name":"IIT Bombay"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shreevidhya","family":"Acharya","sequence":"additional","affiliation":[{"name":"IIT Bombay"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"S.","family":"Sudarshan","sequence":"additional","affiliation":[{"name":"IIT Bombay"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113403"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-015-0395-0"},{"key":"e_1_2_1_3_1","unstructured":"Gradience: The gradiance service for database systems. http:\/\/www.gradiance.com\/db.html.  Gradience: The gradiance service for database systems. http:\/\/www.gradiance.com\/db.html."},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.5555\/1316689.1316772"},{"key":"e_1_2_1_5_1","first-page":"804","volume-title":"CASCON","author":"Paulley G. N.","year":"1993","unstructured":"G. N. Paulley and P.-A. Larson . Exploiting uniqueness in query optimization . In CASCON , pages 804 -- 822 , 1993 . G. N. Paulley and P.-A. Larson. Exploiting uniqueness in query optimization. In CASCON, pages 804--822, 1993."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767876"},{"key":"e_1_2_1_7_1","volume-title":"Database System Concepts","author":"Silberschatz A.","year":"2010","unstructured":"A. Silberschatz , H. F. Korth , and S. Sudarshan . Database System Concepts . McGraw Hill , 6 th edition, 2010 . A. Silberschatz, H. F. Korth, and S. Sudarshan. Database System Concepts. McGraw Hill, 6th edition, 2010.","edition":"6"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3007263.3007304","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:40:29Z","timestamp":1672220429000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3007263.3007304"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,9]]},"references-count":7,"journal-issue":{"issue":"13","published-print":{"date-parts":[[2016,9]]}},"alternative-id":["10.14778\/3007263.3007304"],"URL":"https:\/\/doi.org\/10.14778\/3007263.3007304","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2016,9]]}}}