{"id":"https://openalex.org/W4383223779","doi":"https://doi.org/10.1145/3607180","title":"Framework for SQL Error Message Design: A Data-Driven Approach","display_name":"Framework for SQL Error Message Design: A Data-Driven Approach","publication_year":2023,"publication_date":"2023-07-05","ids":{"openalex":"https://openalex.org/W4383223779","doi":"https://doi.org/10.1145/3607180"},"language":"en","primary_location":{"id":"doi:10.1145/3607180","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3607180","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3607180","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Software Engineering and Methodology","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3607180","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"]}],"countries":["FI"],"is_corresponding":true,"raw_author_name":"Toni Taipalus","raw_affiliation_strings":["University of Jyv\u00e4skyl\u00e4, Finland"],"affiliations":[{"raw_affiliation_string":"University of Jyv\u00e4skyl\u00e4, Finland","institution_ids":["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, Finland"],"affiliations":[{"raw_affiliation_string":"University of 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/I94722563"],"apc_list":null,"apc_paid":null,"fwci":4.5889,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.95102912,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"33","issue":"1","first_page":"1","last_page":"50"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9962000250816345,"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"}},"topics":[{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9962000250816345,"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"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9958999752998352,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9919000267982483,"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.8922913670539856},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7802076935768127},{"id":"https://openalex.org/keywords/syntax-error","display_name":"Syntax error","score":0.5578147172927856},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.513638436794281},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.48127907514572144},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4737732410430908},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.43116357922554016},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.4161854684352875},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.39876309037208557},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37608322501182556},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.27101367712020874},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.18489250540733337},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.12855717539787292},{"id":"https://openalex.org/keywords/abstract-syntax-tree","display_name":"Abstract syntax tree","score":0.10961627960205078},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.08885219693183899},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07755112648010254}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8922913670539856},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7802076935768127},{"id":"https://openalex.org/C11742125","wikidata":"https://www.wikidata.org/wiki/Q1195374","display_name":"Syntax error","level":4,"score":0.5578147172927856},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.513638436794281},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.48127907514572144},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4737732410430908},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.43116357922554016},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.4161854684352875},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.39876309037208557},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37608322501182556},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.27101367712020874},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.18489250540733337},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.12855717539787292},{"id":"https://openalex.org/C58646249","wikidata":"https://www.wikidata.org/wiki/Q127380","display_name":"Abstract syntax tree","level":3,"score":0.10961627960205078},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08885219693183899},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07755112648010254},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3607180","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3607180","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3607180","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Software Engineering and Methodology","raw_type":"journal-article"},{"id":"pmh:oai:jyx.jyu.fi:123456789/92626","is_oa":true,"landing_page_url":"http://urn.fi/URN:NBN:fi:jyu-202401101127","pdf_url":null,"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":"A1"}],"best_oa_location":{"id":"doi:10.1145/3607180","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3607180","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3607180","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Software Engineering and Methodology","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.8899999856948853,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4383223779.pdf","grobid_xml":"https://content.openalex.org/works/W4383223779.grobid-xml"},"referenced_works_count":62,"referenced_works":["https://openalex.org/W197224857","https://openalex.org/W1964523235","https://openalex.org/W1973318909","https://openalex.org/W1974047325","https://openalex.org/W1974752288","https://openalex.org/W1986001389","https://openalex.org/W1987975131","https://openalex.org/W1992007857","https://openalex.org/W2003229342","https://openalex.org/W2006631720","https://openalex.org/W2023745308","https://openalex.org/W2027909523","https://openalex.org/W2047048300","https://openalex.org/W2050390685","https://openalex.org/W2064356545","https://openalex.org/W2072031888","https://openalex.org/W2090253867","https://openalex.org/W2096431252","https://openalex.org/W2099424113","https://openalex.org/W2132516581","https://openalex.org/W2133755076","https://openalex.org/W2139086035","https://openalex.org/W2142225512","https://openalex.org/W2158237121","https://openalex.org/W2162598207","https://openalex.org/W2165081250","https://openalex.org/W2168603957","https://openalex.org/W2216374816","https://openalex.org/W2286501037","https://openalex.org/W2296095100","https://openalex.org/W2473995384","https://openalex.org/W2523566863","https://openalex.org/W2524947710","https://openalex.org/W2604953184","https://openalex.org/W2617813225","https://openalex.org/W2622958941","https://openalex.org/W2747427841","https://openalex.org/W2761740351","https://openalex.org/W2791265653","https://openalex.org/W2885090162","https://openalex.org/W2916040897","https://openalex.org/W2962230923","https://openalex.org/W2999466110","https://openalex.org/W3000240292","https://openalex.org/W3001796748","https://openalex.org/W3010914864","https://openalex.org/W3020721369","https://openalex.org/W3031205039","https://openalex.org/W3041823931","https://openalex.org/W3100811706","https://openalex.org/W3112836607","https://openalex.org/W3123623444","https://openalex.org/W3163358064","https://openalex.org/W3168999116","https://openalex.org/W3177923307","https://openalex.org/W3193751197","https://openalex.org/W4236130975","https://openalex.org/W4287981156","https://openalex.org/W4291784877","https://openalex.org/W4312382508","https://openalex.org/W4312913262","https://openalex.org/W4366597884"],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W2348171219","https://openalex.org/W2614112517","https://openalex.org/W650213220","https://openalex.org/W1984237344","https://openalex.org/W2361335440","https://openalex.org/W2042813897","https://openalex.org/W4366683866","https://openalex.org/W2038123353","https://openalex.org/W4318225407"],"abstract_inverted_index":{"Software":[0],"developers":[1],"use":[2],"a":[3,65,109,129],"significant":[4],"amount":[5],"of":[6,46,67,132,158,185],"time":[7],"reading":[8],"and":[9,77,93,123,162,183],"interpreting":[10],"error":[11,14,40,51,69,96,102,121,137,145,174,179,209],"messages.":[12,41],"However,":[13],"messages":[15,52,70],"have":[16,53],"often":[17],"been":[18],"based":[19,124],"on":[20,113,116,125],"either":[21],"anecdotal":[22],"evidence":[23],"or":[24],"expert":[25],"opinion,":[26],"disregarding":[27],"novices,":[28],"who":[29,34],"arguably":[30],"are":[31,193],"the":[32,36,43,126,156],"ones":[33],"benefit":[35],"most":[37],"from":[38,71,80],"effective":[39],"Furthermore,":[42],"usability":[44],"aspects":[45],"Structured":[47],"Query":[48],"Language":[49],"(SQL)":[50],"not":[54,149],"received":[55],"much":[56],"scientific":[57],"attention.":[58],"In":[59],"this":[60,191],"mixed-methods":[61],"study,":[62],"we":[63,107],"coded":[64],"total":[66],"128":[68],"eight":[72],"database":[73],"management":[74],"systems":[75,168],"(DBMS),":[76],"using":[78,86],"data":[79],"311":[81],"participants,":[82],"analysed":[83],"4,796":[84],"queries":[85],"regression":[87],"analysis":[88,112],"to":[89,118,170],"find":[90],"out":[91],"if":[92],"how":[94,117],"acknowledged":[95],"message":[97,138,146,175,180,210],"qualities":[98,147],"explain":[99,151],"SQL":[100,120,136,159],"syntax":[101,160],"fixing":[103,153],"success":[104,154],"rates.":[105],"Additionally,":[106],"performed":[108],"conventional":[110],"content":[111],"1,505":[114],"suggestions":[115],"improve":[119],"messages,":[122],"analysis,":[127],"formulated":[128],"framework":[130,182],"consisting":[131],"nine":[133],"guidelines":[134],"for":[135,172],"design.":[139,211],"The":[140,178],"results":[141],"indicate":[142],"that":[143,163],"general":[144],"do":[148],"necessarily":[150],"query":[152],"in":[155,190,195,204,208],"context":[157],"errors":[161],"even":[164],"some":[165],"novel":[166],"NewSQL":[167],"fail":[169],"account":[171],"basic":[173],"design":[176,181],"guidelines.":[177],"examples":[184],"its":[186],"practical":[187],"applications":[188],"shown":[189],"study":[192],"applicable":[194],"educational":[196],"contexts":[197],"as":[198,200],"well":[199],"by":[201],"DBMS":[202],"vendors":[203],"understanding":[205],"novice":[206],"perspectives":[207]},"counts_by_year":[{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}