{"id":"https://openalex.org/W3193751197","doi":"https://doi.org/10.1145/3446871.3469759","title":"Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study","display_name":"Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study","publication_year":2021,"publication_date":"2021-08-16","ids":{"openalex":"https://openalex.org/W3193751197","doi":"https://doi.org/10.1145/3446871.3469759","mag":"3193751197"},"language":"en","primary_location":{"id":"doi:10.1145/3446871.3469759","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3446871.3469759","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3446871.3469759","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 17th ACM Conference on International Computing 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/3446871.3469759","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059138768","display_name":"Daphne Miedema","orcid":"https://orcid.org/0000-0003-3507-677X"},"institutions":[{"id":"https://openalex.org/I83019370","display_name":"Eindhoven University of Technology","ror":"https://ror.org/02c2kyt77","country_code":"NL","type":"education","lineage":["https://openalex.org/I83019370"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Daphne Miedema","raw_affiliation_strings":["Artificial Intelligence and Data Engineering (AIDE) Lab and Eindhoven University of Technology, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Artificial Intelligence and Data Engineering (AIDE) Lab and Eindhoven University of Technology, The Netherlands","institution_ids":["https://openalex.org/I83019370"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047667810","display_name":"Efthimia Aivaloglou","orcid":"https://orcid.org/0000-0002-6531-2166"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Efthimia Aivaloglou","raw_affiliation_strings":["Leiden Institute of Advanced Computer Science and Open Universiteit, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Leiden Institute of Advanced Computer Science and Open Universiteit, The Netherlands","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019818981","display_name":"George Fletcher","orcid":null},"institutions":[{"id":"https://openalex.org/I83019370","display_name":"Eindhoven University of Technology","ror":"https://ror.org/02c2kyt77","country_code":"NL","type":"education","lineage":["https://openalex.org/I83019370"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"George Fletcher","raw_affiliation_strings":["Artificial Intelligence and Data Engineering (AIDE) Lab and Eindhoven University of Technology, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Artificial Intelligence and Data Engineering (AIDE) Lab and Eindhoven University of Technology, The Netherlands","institution_ids":["https://openalex.org/I83019370"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5059138768"],"corresponding_institution_ids":["https://openalex.org/I83019370"],"apc_list":null,"apc_paid":null,"fwci":6.5692,"has_fulltext":true,"cited_by_count":33,"citation_normalized_percentile":{"value":0.96720884,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"355","last_page":"367"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.987500011920929,"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"}},"topics":[{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.987500011920929,"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"}},{"id":"https://openalex.org/T12887","display_name":"Educational Strategies and Epistemologies","score":0.9811999797821045,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9800000190734863,"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/computer-science","display_name":"Computer science","score":0.8262161016464233},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7470483183860779},{"id":"https://openalex.org/keywords/think-aloud-protocol","display_name":"Think aloud protocol","score":0.6469027400016785},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6027724146842957},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5001354217529297},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.467072069644928},{"id":"https://openalex.org/keywords/generalization","display_name":"Generalization","score":0.4629076421260834},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.36024177074432373},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34449857473373413},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.21216347813606262},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18259140849113464},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.17606231570243835},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.17127752304077148},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.13920095562934875},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07458299398422241},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.06770175695419312}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8262161016464233},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7470483183860779},{"id":"https://openalex.org/C78821406","wikidata":"https://www.wikidata.org/wiki/Q391810","display_name":"Think aloud protocol","level":3,"score":0.6469027400016785},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6027724146842957},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5001354217529297},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.467072069644928},{"id":"https://openalex.org/C177148314","wikidata":"https://www.wikidata.org/wiki/Q170084","display_name":"Generalization","level":2,"score":0.4629076421260834},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.36024177074432373},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34449857473373413},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.21216347813606262},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18259140849113464},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.17606231570243835},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.17127752304077148},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.13920095562934875},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07458299398422241},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.06770175695419312},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1145/3446871.3469759","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3446871.3469759","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3446871.3469759","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 17th ACM Conference on International Computing Education Research","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.tue.nl:openaire_cris_publications/cf833bc6-b3d3-488b-bb66-a007597319b4","is_oa":true,"landing_page_url":"https://research.tue.nl/en/publications/cf833bc6-b3d3-488b-bb66-a007597319b4","pdf_url":"https://pure.tue.nl/ws/files/362307007/3446871.3469759.pdf","source":{"id":"https://openalex.org/S4406922641","display_name":"TU/e Research Portal","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Miedema, D E, Aivaloglou, E & Fletcher, G H L 2021, Identifying SQL Misconceptions of Novices : Findings from a Think-Aloud Study. in A J Ko, J Vahrenhold, R McCauley & M Hauswirth (eds), ICER 2021 : Proceedings of the 17th ACM Conference on International Computing Education Research. Association for Computing Machinery, Inc., New York, pp. 355-367, 17th ACM Conference on International Computing Education Research, United States, 16/08/21. https://doi.org/10.1145/3446871.3469759","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:scholarlypublications.universiteitleiden.nl:item_3250272","is_oa":true,"landing_page_url":"https://hdl.handle.net/1887/3250272","pdf_url":null,"source":{"id":"https://openalex.org/S4306400850","display_name":"Leiden Repository (Leiden University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I121797337","host_organization_name":"Leiden University","host_organization_lineage":["https://openalex.org/I121797337"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the 17th ACM Conference on International Computing Education Research","raw_type":"Article in monograph or in proceedings"},{"id":"pmh:ou:oai:research.ou.nl:publications/6da444f9-1141-4def-aac1-0bdaf8ced2d6","is_oa":true,"landing_page_url":"https://research.ou.nl/en/publications/6da444f9-1141-4def-aac1-0bdaf8ced2d6","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the 17th ACM Conference on International Computing Education Research","raw_type":"info:eu-repo/semantics/conferencepaper"},{"id":"pmh:ul:oai:scholarlypublications.universiteitleiden.nl:item_3250272","is_oa":true,"landing_page_url":"http://hdl.handle.net/1887/3250272","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the 17th ACM Conference on International Computing Education Research, 355\u2013367. New York, U.S.A.: Association for Computing Machinery","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1145/3446871.3469759","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3446871.3469759","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3446871.3469759","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 17th ACM Conference on International Computing Education Research","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8899999856948853,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3193751197.pdf","grobid_xml":"https://content.openalex.org/works/W3193751197.grobid-xml"},"referenced_works_count":39,"referenced_works":["https://openalex.org/W1964523235","https://openalex.org/W1975487129","https://openalex.org/W1977085035","https://openalex.org/W1978148216","https://openalex.org/W1980871615","https://openalex.org/W1987311676","https://openalex.org/W1987975131","https://openalex.org/W1995969371","https://openalex.org/W2005770594","https://openalex.org/W2023745308","https://openalex.org/W2037085022","https://openalex.org/W2039883913","https://openalex.org/W2042124586","https://openalex.org/W2065276745","https://openalex.org/W2099421759","https://openalex.org/W2106713455","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2168795140","https://openalex.org/W2286501037","https://openalex.org/W2473995384","https://openalex.org/W2489758317","https://openalex.org/W2490595962","https://openalex.org/W2727220479","https://openalex.org/W2766624855","https://openalex.org/W2771382620","https://openalex.org/W2885048964","https://openalex.org/W2885090162","https://openalex.org/W2886421510","https://openalex.org/W2903110104","https://openalex.org/W2912099493","https://openalex.org/W2916040897","https://openalex.org/W2919589844","https://openalex.org/W3031205039","https://openalex.org/W3041823931","https://openalex.org/W3112836607","https://openalex.org/W3163403742","https://openalex.org/W4233145949","https://openalex.org/W7034118277"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W1548279772","https://openalex.org/W319014924","https://openalex.org/W2897196530","https://openalex.org/W1488984669","https://openalex.org/W3210031882","https://openalex.org/W4388053677","https://openalex.org/W3114457612","https://openalex.org/W2031915568","https://openalex.org/W4285818047"],"abstract_inverted_index":{"SQL":[0,20,71,124,170],"is":[1],"the":[2,14,23,33,62,67,89,101,107,111,122],"most":[3],"commonly":[4],"taught":[5],"database":[6],"query":[7,21,50,97],"language.":[8],"While":[9],"previous":[10,134],"research":[11],"has":[12],"investigated":[13],"errors":[15,28,43,72,112],"made":[16,113],"by":[17,37,114],"novices":[18,38,74],"during":[19],"formulation,":[22],"underlying":[24,108],"causes":[25,68,109],"for":[26,110],"these":[27,42],"have":[29],"remained":[30],"unexplored.":[31],"Understanding":[32],"basic":[34],"misconceptions":[35,63,125,131,142,155],"held":[36],"which":[39],"lead":[40],"to":[41,52,60,85,144,164,168],"would":[44],"help":[45],"improve":[46,169],"how":[47],"we":[48,58,79,105,120,166],"teach":[49],"languages":[51],"our":[53,115],"students.":[54],"In":[55,117],"this":[56,77,118],"paper":[57,119],"aim":[59,167],"identify":[61],"that":[64,73],"might":[65],"be":[66],"of":[69,92,154],"documented":[70],"make.":[75],"To":[76],"end,":[78],"conducted":[80],"a":[81],"qualitative":[82],"think-aloud":[83],"study":[84],"gather":[86],"information":[87],"on":[88],"thinking":[90],"process":[91],"university":[93],"students":[94],"while":[95],"solving":[96],"formulation":[98],"problems.":[99],"With":[100],"queries":[102],"in":[103,133,159],"hand,":[104],"analyzed":[106],"participants.":[116],"present":[121],"identified":[123],"organized":[126],"into":[127],"four":[128],"top-level":[129],"categories:":[130],"based":[132],"course":[135],"knowledge,":[136],"generalization-based":[137],"misconceptions,":[138,140],"language-based":[139],"and":[141],"due":[143],"an":[145],"incomplete":[146],"or":[147],"incorrect":[148],"mental":[149],"model.":[150],"A":[151],"deep":[152],"exploration":[153],"can":[156],"uncover":[157],"gaps":[158],"instruction.":[160],"By":[161],"drawing":[162],"attention":[163],"these,":[165],"education.":[171]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":17},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":1}],"updated_date":"2026-03-22T08:09:32.410652","created_date":"2025-10-10T00:00:00"}