{"id":"https://openalex.org/W4405210411","doi":"https://doi.org/10.1007/s10639-024-13228-3","title":"Enhancing SQL programming education: addressing cheating challenges in online judge systems","display_name":"Enhancing SQL programming education: addressing cheating challenges in online judge systems","publication_year":2024,"publication_date":"2024-12-10","ids":{"openalex":"https://openalex.org/W4405210411","doi":"https://doi.org/10.1007/s10639-024-13228-3"},"language":"en","primary_location":{"id":"doi:10.1007/s10639-024-13228-3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10639-024-13228-3","pdf_url":null,"source":{"id":"https://openalex.org/S166722454","display_name":"Education and Information Technologies","issn_l":"1360-2357","issn":["1360-2357","1573-7608"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Education and Information Technologies","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/A5048022532","display_name":"Jinshui Wang","orcid":"https://orcid.org/0000-0003-1733-8481"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Jinshui Wang","raw_affiliation_strings":["Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China"],"raw_orcid":"https://orcid.org/0000-0003-1733-8481","affiliations":[{"raw_affiliation_string":"Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102972029","display_name":"Shuguang Chen","orcid":"https://orcid.org/0009-0007-9745-471X"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shuguang Chen","raw_affiliation_strings":["Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China"],"raw_orcid":"https://orcid.org/0009-0007-9745-471X","affiliations":[{"raw_affiliation_string":"Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040733657","display_name":"Zhengyi Tang","orcid":"https://orcid.org/0000-0002-9306-6038"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhengyi Tang","raw_affiliation_strings":["Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China"],"raw_orcid":"https://orcid.org/0000-0002-9306-6038","affiliations":[{"raw_affiliation_string":"Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059602840","display_name":"P.L. Lin","orcid":"https://orcid.org/0000-0002-1212-1630"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Pengchen Lin","raw_affiliation_strings":["Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China"],"raw_orcid":"https://orcid.org/0000-0002-1212-1630","affiliations":[{"raw_affiliation_string":"Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014722122","display_name":"Yupeng Wang","orcid":"https://orcid.org/0009-0006-3835-6805"},"institutions":[{"id":"https://openalex.org/I83791580","display_name":"Fujian University of Technology","ror":"https://ror.org/03c8fdb16","country_code":"CN","type":"education","lineage":["https://openalex.org/I83791580"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yupeng Wang","raw_affiliation_strings":["Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China"],"raw_orcid":"https://orcid.org/0009-0006-3835-6805","affiliations":[{"raw_affiliation_string":"Fujian Provincial Key Laboratory of Big Data Mining and Applications, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]},{"raw_affiliation_string":"School of Computer Science and Mathematics, Fujian University of Technology, Fuzhou, 350118, China","institution_ids":["https://openalex.org/I83791580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5048022532"],"corresponding_institution_ids":["https://openalex.org/I83791580"],"apc_list":{"value":3190,"currency":"USD","value_usd":3190},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.205081,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"30","issue":"1","first_page":"715","last_page":"745"},"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.9848999977111816,"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.9848999977111816,"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/T12535","display_name":"Machine Learning and Data Classification","score":0.9848999977111816,"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/T10533","display_name":"Teaching and Learning Programming","score":0.9830999970436096,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/cheating","display_name":"Cheating","score":0.869382381439209},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6917786598205566},{"id":"https://openalex.org/keywords/educational-technology","display_name":"Educational technology","score":0.550259530544281},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.45762667059898376},{"id":"https://openalex.org/keywords/computer-assisted-instruction","display_name":"Computer-Assisted Instruction","score":0.4228053092956543},{"id":"https://openalex.org/keywords/multimedia","display_name":"Multimedia","score":0.3095090091228485},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.2089318335056305}],"concepts":[{"id":"https://openalex.org/C2778024590","wikidata":"https://www.wikidata.org/wiki/Q2357432","display_name":"Cheating","level":2,"score":0.869382381439209},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6917786598205566},{"id":"https://openalex.org/C16443162","wikidata":"https://www.wikidata.org/wiki/Q1068473","display_name":"Educational technology","level":2,"score":0.550259530544281},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.45762667059898376},{"id":"https://openalex.org/C2909807104","wikidata":"https://www.wikidata.org/wiki/Q1068473","display_name":"Computer-Assisted Instruction","level":2,"score":0.4228053092956543},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.3095090091228485},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.2089318335056305},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s10639-024-13228-3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10639-024-13228-3","pdf_url":null,"source":{"id":"https://openalex.org/S166722454","display_name":"Education and Information Technologies","issn_l":"1360-2357","issn":["1360-2357","1573-7608"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Education and Information Technologies","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4672353818","display_name":null,"funder_award_id":"FJ2021BF050","funder_id":"https://openalex.org/F4320331100","funder_display_name":"Fujian Provincial Federation of Social Sciences"},{"id":"https://openalex.org/G6032771889","display_name":"\u7f16\u7a0b\u9898\u81ea\u52a8\u8bc4\u5206\u65b9\u6cd5\u7684\u5173\u952e\u6280\u672f\u53ca\u5e94\u7528\u7814\u7a76","funder_award_id":"2022J01933","funder_id":"https://openalex.org/F4320321878","funder_display_name":"Natural Science Foundation of Fujian Province"}],"funders":[{"id":"https://openalex.org/F4320321878","display_name":"Natural Science Foundation of Fujian Province","ror":null},{"id":"https://openalex.org/F4320331100","display_name":"Fujian Provincial Federation of Social Sciences","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W15859922","https://openalex.org/W197224857","https://openalex.org/W1587387484","https://openalex.org/W2001525166","https://openalex.org/W2023745308","https://openalex.org/W2034204026","https://openalex.org/W2064206210","https://openalex.org/W2095813426","https://openalex.org/W2099135712","https://openalex.org/W2131231258","https://openalex.org/W2132516581","https://openalex.org/W2135841285","https://openalex.org/W2142225512","https://openalex.org/W2286501037","https://openalex.org/W2295144739","https://openalex.org/W2403331052","https://openalex.org/W2404958529","https://openalex.org/W2473995384","https://openalex.org/W2558192860","https://openalex.org/W2766624855","https://openalex.org/W2767123881","https://openalex.org/W2792805964","https://openalex.org/W2803865198","https://openalex.org/W2809284492","https://openalex.org/W2885090162","https://openalex.org/W2926052689","https://openalex.org/W2942893277","https://openalex.org/W2965110092","https://openalex.org/W3010914864","https://openalex.org/W3041823931","https://openalex.org/W3094685058","https://openalex.org/W3112836607","https://openalex.org/W3122268185","https://openalex.org/W3122283993","https://openalex.org/W3178694065","https://openalex.org/W4212995739","https://openalex.org/W4281560022","https://openalex.org/W4287981156","https://openalex.org/W4296078699","https://openalex.org/W4312913262","https://openalex.org/W4321015767","https://openalex.org/W4394874838"],"related_works":["https://openalex.org/W2012288173","https://openalex.org/W1968538666","https://openalex.org/W2097662580","https://openalex.org/W3199302685","https://openalex.org/W2344072770","https://openalex.org/W2389163612","https://openalex.org/W2065650938","https://openalex.org/W2365256465","https://openalex.org/W2363831685","https://openalex.org/W4403793072"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}