{"id":"https://openalex.org/W4381546096","doi":"https://doi.org/10.1145/3596673.3596976","title":"Student's Learning Challenges with Relational, Document, and Graph Query Languages","display_name":"Student's Learning Challenges with Relational, Document, and Graph Query Languages","publication_year":2023,"publication_date":"2023-06-21","ids":{"openalex":"https://openalex.org/W4381546096","doi":"https://doi.org/10.1145/3596673.3596976"},"language":"en","primary_location":{"id":"doi:10.1145/3596673.3596976","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596976","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596976","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596976","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5079069760","display_name":"Ridha Alkhabaz","orcid":"https://orcid.org/0009-0002-3758-2713"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ridha Alkhabaz","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, United States of America"],"raw_orcid":"https://orcid.org/0009-0002-3758-2713","affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, United States of America","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037065721","display_name":"Z. Li","orcid":"https://orcid.org/0009-0007-1239-2493"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zepei Li","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, USA"],"raw_orcid":"https://orcid.org/0009-0007-1239-2493","affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022587958","display_name":"Sophia Yang","orcid":"https://orcid.org/0000-0003-1274-4851"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sophia Yang","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, United States of America"],"raw_orcid":"https://orcid.org/0000-0003-1274-4851","affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, United States of America","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014235464","display_name":"Abdussalam Alawini","orcid":"https://orcid.org/0000-0003-1106-7190"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Abdussalam Alawini","raw_affiliation_strings":["University of Illinois Urbana-Champaign, Urbana, United States of America"],"raw_orcid":"https://orcid.org/0000-0003-1106-7190","affiliations":[{"raw_affiliation_string":"University of Illinois Urbana-Champaign, Urbana, United States of America","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5079069760"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":5.9318,"has_fulltext":true,"cited_by_count":11,"citation_normalized_percentile":{"value":0.96075863,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"30","last_page":"36"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9861999750137329,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9842000007629395,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.840673565864563},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6884828805923462},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5937385559082031},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5822862386703491},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.5309593081474304},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.523953914642334},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.47326281666755676},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4713701009750366},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.46933072805404663},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41668933629989624},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35361433029174805},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.34708940982818604},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.22986054420471191},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.19029030203819275},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.17089331150054932},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08854725956916809}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.840673565864563},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6884828805923462},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5937385559082031},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5822862386703491},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.5309593081474304},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.523953914642334},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.47326281666755676},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4713701009750366},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.46933072805404663},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41668933629989624},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35361433029174805},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.34708940982818604},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.22986054420471191},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.19029030203819275},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.17089331150054932},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08854725956916809}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3596673.3596976","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596976","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596976","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3596673.3596976","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596976","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596976","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8799999952316284,"display_name":"Quality Education"}],"awards":[{"id":"https://openalex.org/G7066688587","display_name":null,"funder_award_id":"2021499","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4381546096.pdf","grobid_xml":"https://content.openalex.org/works/W4381546096.grobid-xml"},"referenced_works_count":17,"referenced_works":["https://openalex.org/W1964523235","https://openalex.org/W2096431252","https://openalex.org/W2132032354","https://openalex.org/W2248749189","https://openalex.org/W2286501037","https://openalex.org/W2347061999","https://openalex.org/W2473995384","https://openalex.org/W2510119520","https://openalex.org/W2514180210","https://openalex.org/W2793593730","https://openalex.org/W2916040897","https://openalex.org/W3033482208","https://openalex.org/W3041823931","https://openalex.org/W3176219159","https://openalex.org/W3177923307","https://openalex.org/W4232518934","https://openalex.org/W4251419920"],"related_works":["https://openalex.org/W650213220","https://openalex.org/W1592149428","https://openalex.org/W4388053677","https://openalex.org/W2042813897","https://openalex.org/W3114457612","https://openalex.org/W151494989","https://openalex.org/W1980548249","https://openalex.org/W3094396153","https://openalex.org/W2974218799","https://openalex.org/W2031915568"],"abstract_inverted_index":{"As":[0],"the":[1,26,31,62,80],"need":[2],"for":[3,15,116,142],"database":[4,18,43,102,144],"management":[5],"skills":[6],"continues":[7],"to":[8,98,138],"grow,":[9],"there":[10],"is":[11,45],"an":[12],"increasing":[13],"demand":[14],"education":[16,123],"on":[17],"models":[19,141],"and":[20,71,90,110,133],"their":[21],"corresponding":[22],"query":[23,40,73],"languages.":[24,74],"However,":[25],"body":[27],"of":[28],"research":[29,89],"addressing":[30],"difficulties":[32],"encountered":[33],"by":[34,85],"novice":[35],"learners":[36],"when":[37],"working":[38],"with":[39,120],"languages":[41],"in":[42,68],"systems":[44],"still":[46],"limited.":[47],"In":[48],"this":[49],"study,":[50],"we":[51,105,126],"examined":[52],"over":[53],"357215":[54],"submissions":[55],"from":[56],"462":[57],"students'":[58],"homework":[59],"problems":[60],"during":[61],"Fall":[63],"2022":[64],"semester":[65],"covering":[66],"concepts":[67],"SQL,":[69],"MongoDB,":[70],"Neo4j":[72],"Our":[75],"analysis":[76],"through":[77],"breaking":[78],"down":[79],"most":[81],"common":[82],"syntax":[83],"errors":[84],"concept":[86],"confirms":[87],"previous":[88],"demonstrates":[91],"that":[92,107,128,135],"certain":[93],"data":[94],"operations":[95,109,112],"pose":[96],"challenges":[97],"students":[99,137],"across":[100],"different":[101,143],"systems.":[103],"Specifically,":[104],"found":[106],"aggregation":[108],"Join":[111],"were":[113],"particularly":[114],"difficult":[115],"students,":[117],"which":[118],"aligns":[119],"prior":[121],"SQL":[122],"research.":[124],"Therefore,":[125],"suggest":[127],"instructors":[129],"consider":[130],"incorporating":[131],"visuals":[132],"assignments":[134],"enable":[136],"build":[139],"mental":[140],"models.":[145]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}