{"id":"https://openalex.org/W4400268399","doi":"https://doi.org/10.1145/3649217.3653552","title":"Building Blocks Towards More Effective SQL Error Messages","display_name":"Building Blocks Towards More Effective SQL Error Messages","publication_year":2024,"publication_date":"2024-07-03","ids":{"openalex":"https://openalex.org/W4400268399","doi":"https://doi.org/10.1145/3649217.3653552"},"language":"en","primary_location":{"id":"doi:10.1145/3649217.3653552","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653552","pdf_url":null,"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 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3649217.3653552","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005256813","display_name":"Toni Taipalus","orcid":"https://orcid.org/0000-0003-4060-3431"},"institutions":[{"id":"https://openalex.org/I94722563","display_name":"University of Jyv\u00e4skyl\u00e4","ror":"https://ror.org/05n3dz165","country_code":"FI","type":"education","lineage":["https://openalex.org/I94722563"]},{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]}],"countries":["FI"],"is_corresponding":true,"raw_author_name":"Toni Taipalus","raw_affiliation_strings":["Tampere University & University of Jyv\u00e4skyl\u00e4, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"Tampere University & University of Jyv\u00e4skyl\u00e4, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I94722563"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048729976","display_name":"Hilkka Grahn","orcid":"https://orcid.org/0000-0001-7567-7807"},"institutions":[{"id":"https://openalex.org/I94722563","display_name":"University of Jyv\u00e4skyl\u00e4","ror":"https://ror.org/05n3dz165","country_code":"FI","type":"education","lineage":["https://openalex.org/I94722563"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Hilkka Grahn","raw_affiliation_strings":["University of Jyv\u00e4skyl\u00e4, Jyv\u00e4skyl\u00e4, Finland"],"affiliations":[{"raw_affiliation_string":"University of Jyv\u00e4skyl\u00e4, Jyv\u00e4skyl\u00e4, Finland","institution_ids":["https://openalex.org/I94722563"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5005256813"],"corresponding_institution_ids":["https://openalex.org/I166825849","https://openalex.org/I94722563"],"apc_list":null,"apc_paid":null,"fwci":1.5097,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.82195883,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"241","last_page":"247"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9983999729156494,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.996999979019165,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8112154006958008},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5757107734680176},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4152994155883789},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40127578377723694}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8112154006958008},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5757107734680176},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4152994155883789},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40127578377723694}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3649217.3653552","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653552","pdf_url":null,"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 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},{"id":"pmh:oai:jyx.jyu.fi:123456789/96531","is_oa":true,"landing_page_url":"http://urn.fi/URN:NBN:fi:jyu-202408075407","pdf_url":"https://jyx.jyu.fi/bitstreams/713f45b9-b3ca-4c86-ad8f-46064a12ff8e/download","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"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":null,"raw_type":"A4"},{"id":"pmh:oai:trepo.tuni.fi:10024/210934","is_oa":true,"landing_page_url":"https://trepo.tuni.fi/handle/10024/210934","pdf_url":null,"source":{"id":"https://openalex.org/S7407055260","display_name":"Trepo - Institutional Repository of Tampere University","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":null,"raw_type":"conference"}],"best_oa_location":{"id":"doi:10.1145/3649217.3653552","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649217.3653552","pdf_url":null,"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 2024 on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W1974047325","https://openalex.org/W1975487129","https://openalex.org/W1992007857","https://openalex.org/W2034184465","https://openalex.org/W2296095100","https://openalex.org/W2604953184","https://openalex.org/W2617813225","https://openalex.org/W2747427841","https://openalex.org/W2791265653","https://openalex.org/W2885090162","https://openalex.org/W2899324569","https://openalex.org/W2981301999","https://openalex.org/W3000240292","https://openalex.org/W3020721369","https://openalex.org/W3177923307","https://openalex.org/W4323033692","https://openalex.org/W4323037584","https://openalex.org/W4366597884","https://openalex.org/W4381550569","https://openalex.org/W4383223779"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W2382290278","https://openalex.org/W4395014643"],"abstract_inverted_index":{"Reading":[0],"and":[1,16],"interpreting":[2],"error":[3,19,26,59,75,104,109,130],"messages":[4,27,105,110,131],"are":[5],"significant":[6],"aspects":[7],"of":[8,18,43,92],"a":[9],"software":[10],"developer's":[11],"work.":[12],"Despite":[13],"the":[14,48,93],"importance":[15],"prevalence":[17],"messages,":[20],"especially":[21],"for":[22,106],"novices,":[23],"SQL":[24,74,84,103,129,133,137],"compiler":[25],"from":[28,47,63],"various":[29],"relational":[30],"database":[31],"management":[32],"systems":[33],"have":[34],"seen":[35],"limited":[36],"development":[37],"since":[38],"their":[39],"inception.":[40],"This":[41],"lack":[42],"progress":[44],"may":[45],"stem":[46],"fact":[49],"that":[50,90,111],"it":[51],"is":[52],"not":[53],"well-understood":[54],"what":[55],"constitutes":[56],"an":[57],"effective":[58,102],"message.":[60],"With":[61],"data":[62],"568":[64],"participants":[65],"across":[66],"three":[67],"student":[68],"cohorts,":[69],"we":[70],"investigate":[71],"whether":[72],"novel":[73],"message":[76],"design":[77],"guidelines":[78,94,115],"can":[79,123],"explain":[80],"success":[81],"in":[82,132],"fixing":[83],"syntax":[85],"errors.":[86],"The":[87],"results":[88],"indicate":[89],"some":[91],"indeed":[95],"serve":[96],"as":[97],"building":[98],"blocks":[99],"toward":[100],"more":[101],"novices.":[107],"However,":[108],"adhered":[112],"to":[113,126],"certain":[114],"showed":[116],"inconclusive":[117],"or":[118,136],"negative":[119],"results.":[120],"These":[121],"findings":[122],"be":[124],"applied":[125],"iterate":[127],"on":[128],"learning":[134],"environments":[135],"compilers.":[138]},"counts_by_year":[{"year":2025,"cited_by_count":3}],"updated_date":"2026-03-14T08:43:22.919905","created_date":"2025-10-10T00:00:00"}