{"id":"https://openalex.org/W1587387484","doi":"https://doi.org/10.1109/mipro.2015.7160467","title":"Using string similarity metrics for automated grading of SQL statements","display_name":"Using string similarity metrics for automated grading of SQL statements","publication_year":2015,"publication_date":"2015-05-01","ids":{"openalex":"https://openalex.org/W1587387484","doi":"https://doi.org/10.1109/mipro.2015.7160467","mag":"1587387484"},"language":"en","primary_location":{"id":"doi:10.1109/mipro.2015.7160467","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mipro.2015.7160467","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 38th International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO)","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/A5081398821","display_name":"Ivan \u0160tajduhar","orcid":"https://orcid.org/0000-0003-4758-7972"},"institutions":[{"id":"https://openalex.org/I154347574","display_name":"University of Rijeka","ror":"https://ror.org/05r8dqr10","country_code":"HR","type":"education","lineage":["https://openalex.org/I154347574"]}],"countries":["HR"],"is_corresponding":true,"raw_author_name":"I. Stajduhar","raw_affiliation_strings":["Faculty of Engineering, University of Rijeka, Rijeka, Croatia","University of Rijeka, Faculty of Engineering, Department of Computer Engineering, Croatia"],"affiliations":[{"raw_affiliation_string":"Faculty of Engineering, University of Rijeka, Rijeka, Croatia","institution_ids":["https://openalex.org/I154347574"]},{"raw_affiliation_string":"University of Rijeka, Faculty of Engineering, Department of Computer Engineering, Croatia","institution_ids":["https://openalex.org/I154347574"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088320075","display_name":"Goran Mau\u0161a","orcid":"https://orcid.org/0000-0002-0643-4577"},"institutions":[{"id":"https://openalex.org/I154347574","display_name":"University of Rijeka","ror":"https://ror.org/05r8dqr10","country_code":"HR","type":"education","lineage":["https://openalex.org/I154347574"]}],"countries":["HR"],"is_corresponding":false,"raw_author_name":"G. Mausa","raw_affiliation_strings":["Faculty of Engineering, University of Rijeka, Rijeka, Croatia","University of Rijeka, Faculty of Engineering, Department of Computer Engineering, Croatia"],"affiliations":[{"raw_affiliation_string":"Faculty of Engineering, University of Rijeka, Rijeka, Croatia","institution_ids":["https://openalex.org/I154347574"]},{"raw_affiliation_string":"University of Rijeka, Faculty of Engineering, Department of Computer Engineering, Croatia","institution_ids":["https://openalex.org/I154347574"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5081398821"],"corresponding_institution_ids":["https://openalex.org/I154347574"],"apc_list":null,"apc_paid":null,"fwci":1.4595,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.82352941,"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":"1250","last_page":"1255"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.9624000191688538,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.9624000191688538,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T13820","display_name":"SAS software applications and methods","score":0.954200029373169,"subfield":{"id":"https://openalex.org/subfields/2204","display_name":"Biomedical Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.953499972820282,"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/grading","display_name":"Grading (engineering)","score":0.8072342872619629},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7625535726547241},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5709874629974365},{"id":"https://openalex.org/keywords/string-metric","display_name":"String metric","score":0.5040118098258972},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.45908915996551514},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4551449418067932},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.4393918812274933},{"id":"https://openalex.org/keywords/string","display_name":"String (physics)","score":0.4208073914051056},{"id":"https://openalex.org/keywords/similarity","display_name":"Similarity (geometry)","score":0.41740089654922485},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.3423789143562317},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2620908319950104},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11408808827400208},{"id":"https://openalex.org/keywords/string-searching-algorithm","display_name":"String searching algorithm","score":0.07218104600906372}],"concepts":[{"id":"https://openalex.org/C2777286243","wikidata":"https://www.wikidata.org/wiki/Q5591926","display_name":"Grading (engineering)","level":2,"score":0.8072342872619629},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7625535726547241},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5709874629974365},{"id":"https://openalex.org/C22820288","wikidata":"https://www.wikidata.org/wiki/Q9050568","display_name":"String metric","level":4,"score":0.5040118098258972},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.45908915996551514},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4551449418067932},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4393918812274933},{"id":"https://openalex.org/C157486923","wikidata":"https://www.wikidata.org/wiki/Q1376436","display_name":"String (physics)","level":2,"score":0.4208073914051056},{"id":"https://openalex.org/C103278499","wikidata":"https://www.wikidata.org/wiki/Q254465","display_name":"Similarity (geometry)","level":3,"score":0.41740089654922485},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.3423789143562317},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2620908319950104},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11408808827400208},{"id":"https://openalex.org/C7757238","wikidata":"https://www.wikidata.org/wiki/Q374040","display_name":"String searching algorithm","level":3,"score":0.07218104600906372},{"id":"https://openalex.org/C68859911","wikidata":"https://www.wikidata.org/wiki/Q1503724","display_name":"Pattern matching","level":2,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"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/C37914503","wikidata":"https://www.wikidata.org/wiki/Q156495","display_name":"Mathematical physics","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/mipro.2015.7160467","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mipro.2015.7160467","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 38th International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.7099999785423279,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1606424393","https://openalex.org/W2001496424","https://openalex.org/W2028537988","https://openalex.org/W2048431936","https://openalex.org/W2050781086","https://openalex.org/W2099859313","https://openalex.org/W2106393550","https://openalex.org/W2125054539","https://openalex.org/W2133990480","https://openalex.org/W2142635908","https://openalex.org/W2157825442","https://openalex.org/W4235706597","https://openalex.org/W6636366414","https://openalex.org/W6678407692"],"related_works":["https://openalex.org/W4206408938","https://openalex.org/W2399368377","https://openalex.org/W2985011672","https://openalex.org/W2765918440","https://openalex.org/W2347219288","https://openalex.org/W3003367275","https://openalex.org/W3014220280","https://openalex.org/W2060509638","https://openalex.org/W2134637240","https://openalex.org/W2108648114"],"abstract_inverted_index":{"Manual":[0],"grading":[1,47],"of":[2,31,97,100,121,165],"structured":[3],"query":[4],"language":[5],"(SQL)":[6],"statements":[7,66],"after":[8],"an":[9,43],"exam":[10],"can":[11,23,136],"be":[12,25,137],"tedious":[13],"and":[14,56,146],"time":[15],"consuming":[16],"for":[17,46,61,81,131],"the":[18,63,68,77,83,105,117,142],"teaching":[19],"assistant.":[20],"Additionally,":[21],"it":[22],"also":[24],"subjective":[26],"to":[27,36,152,160],"her":[28],"current":[29],"state":[30],"mind":[32],"and,":[33],"thus,":[34],"prone":[35],"errors.":[37],"In":[38],"this":[39],"paper":[40],"we":[41],"propose":[42],"automated":[44],"method":[45,52,90],"individual":[48],"SQL":[49],"statements.":[50,70],"The":[51,88,114,134],"uses":[53],"several":[54],"common":[55],"simple":[57],"string":[58],"similarity":[59],"metrics":[60],"comparing":[62],"student":[64],"devised":[65],"against":[67],"reference":[69],"These":[71],"are":[72],"then":[73],"used,":[74],"along":[75,103],"with":[76,104,141],"manually":[78,162],"assigned":[79,109],"grades,":[80],"building":[82],"predictive":[84],"logistic":[85],"regression":[86],"model.":[87],"proposed":[89],"was":[91],"evaluated":[92],"on":[93,123],"a":[94,124],"dataset":[95],"consisting":[96],"314":[98],"pairs":[99],"student-reference":[101],"statements,":[102],"discretized":[106],"average":[107],"grade":[108],"by":[110],"three":[111],"independent":[112],"evaluators.":[113],"model":[115,135],"achieved":[116],"expected":[118],"classification":[119],"accuracy":[120],"78%":[122],"binary":[125],"class,":[126],"thus":[127],"exhibiting":[128],"its":[129],"potential":[130],"real-life":[132],"application.":[133],"used":[138],"as":[139],"is":[140],"suggested":[143],"calculated":[144],"features":[145],"reported":[147],"learnt":[148],"parameters,":[149],"or":[150],"adapted":[151],"other":[153],"examiners'":[154],"evaluation":[155],"criteria,":[156],"presuming":[157],"their":[158,166],"willingness":[159],"build":[161],"graded":[163],"datasets":[164],"own.":[167]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":1}],"updated_date":"2026-03-25T14:56:36.534964","created_date":"2025-10-10T00:00:00"}