{"id":"https://openalex.org/W3090668201","doi":"https://doi.org/10.1145/3379597.3387467","title":"On the Prevalence, Impact, and Evolution of SQL Code Smells in Data-Intensive Systems","display_name":"On the Prevalence, Impact, and Evolution of SQL Code Smells in Data-Intensive Systems","publication_year":2020,"publication_date":"2020-06-29","ids":{"openalex":"https://openalex.org/W3090668201","doi":"https://doi.org/10.1145/3379597.3387467","mag":"3090668201"},"language":"en","primary_location":{"id":"doi:10.1145/3379597.3387467","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3379597.3387467","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Conference on Mining Software Repositories","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://pure.unamur.be/ws/files/51694829/2020_NagyCleve_article.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009290843","display_name":"Biruk Asmare Muse","orcid":"https://orcid.org/0000-0001-8861-9526"},"institutions":[{"id":"https://openalex.org/I45683168","display_name":"Polytechnique Montr\u00e9al","ror":"https://ror.org/05f8d4e86","country_code":"CA","type":"education","lineage":["https://openalex.org/I45683168"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Biruk Asmare Muse","raw_affiliation_strings":["Polytechnique Montr\u00e9al"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Polytechnique Montr\u00e9al","institution_ids":["https://openalex.org/I45683168"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030616863","display_name":"Mohammad Masudur Rahman","orcid":"https://orcid.org/0000-0003-3821-5990"},"institutions":[{"id":"https://openalex.org/I45683168","display_name":"Polytechnique Montr\u00e9al","ror":"https://ror.org/05f8d4e86","country_code":"CA","type":"education","lineage":["https://openalex.org/I45683168"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mohammad Masudur Rahman","raw_affiliation_strings":["Polytechnique Montr\u00e9al"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Polytechnique Montr\u00e9al","institution_ids":["https://openalex.org/I45683168"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085570175","display_name":"Csaba Nagy","orcid":"https://orcid.org/0000-0001-8109-3293"},"institutions":[{"id":"https://openalex.org/I57201433","display_name":"Universit\u00e0 della Svizzera italiana","ror":"https://ror.org/03c4atk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I57201433"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Csaba Nagy","raw_affiliation_strings":["Software Institute, Universit\u00e0 della Svizzera italiana"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Institute, Universit\u00e0 della Svizzera italiana","institution_ids":["https://openalex.org/I57201433"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070165042","display_name":"Anthony Cleve","orcid":null},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Anthony Cleve","raw_affiliation_strings":["Namur Digital Institute, University of Namur"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Namur Digital Institute, University of Namur","institution_ids":["https://openalex.org/I149768937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071052367","display_name":"Foutse Khomh","orcid":"https://orcid.org/0000-0002-5704-4173"},"institutions":[{"id":"https://openalex.org/I45683168","display_name":"Polytechnique Montr\u00e9al","ror":"https://ror.org/05f8d4e86","country_code":"CA","type":"education","lineage":["https://openalex.org/I45683168"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Foutse Khomh","raw_affiliation_strings":["Polytechnique Montr\u00e9al"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Polytechnique Montr\u00e9al","institution_ids":["https://openalex.org/I45683168"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018821149","display_name":"Giuliano Antoniol","orcid":"https://orcid.org/0000-0002-7892-9202"},"institutions":[{"id":"https://openalex.org/I45683168","display_name":"Polytechnique Montr\u00e9al","ror":"https://ror.org/05f8d4e86","country_code":"CA","type":"education","lineage":["https://openalex.org/I45683168"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Giuliano Antoniol","raw_affiliation_strings":["Polytechnique Montr\u00e9al"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Polytechnique Montr\u00e9al","institution_ids":["https://openalex.org/I45683168"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.2406,"has_fulltext":false,"cited_by_count":43,"citation_normalized_percentile":{"value":0.97193998,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"327","last_page":"338"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9998000264167786,"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.9998000264167786,"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/T11241","display_name":"Advanced Malware Detection Techniques","score":0.9847999811172485,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.9790999889373779,"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/code-smell","display_name":"Code smell","score":0.8970806002616882},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7277149558067322},{"id":"https://openalex.org/keywords/code-refactoring","display_name":"Code refactoring","score":0.6646374464035034},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.63310706615448},{"id":"https://openalex.org/keywords/software-quality","display_name":"Software quality","score":0.4459211230278015},{"id":"https://openalex.org/keywords/code-review","display_name":"Code review","score":0.44138234853744507},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.43816906213760376},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.38281673192977905},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.38170358538627625},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.34736305475234985},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.34361159801483154},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.3330298364162445}],"concepts":[{"id":"https://openalex.org/C133237599","wikidata":"https://www.wikidata.org/wiki/Q2295111","display_name":"Code smell","level":5,"score":0.8970806002616882},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7277149558067322},{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.6646374464035034},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.63310706615448},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.4459211230278015},{"id":"https://openalex.org/C150292731","wikidata":"https://www.wikidata.org/wiki/Q1342704","display_name":"Code review","level":5,"score":0.44138234853744507},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.43816906213760376},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.38281673192977905},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.38170358538627625},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34736305475234985},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.34361159801483154},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.3330298364162445},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3379597.3387467","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3379597.3387467","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Conference on Mining Software Repositories","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.unamur.be:openaire/05f63182-7493-4e55-9bc5-15cfb19d5be8","is_oa":true,"landing_page_url":"https://researchportal.unamur.be/en/publications/05f63182-7493-4e55-9bc5-15cfb19d5be8","pdf_url":"https://pure.unamur.be/ws/files/51694829/2020_NagyCleve_article.pdf","source":{"id":"https://openalex.org/S4406922457","display_name":"Repository of the University of Namur","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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Asmare Muse, B, Rahman, M, Nagy, C, Cleve, A, Khomh, F & Antoniol, G 2020, On the Prevalence, Impact, and Evolution of SQL code smells in Data-Intensive Systems. in Proceedings - 2020 IEEE/ACM 17th International Conference on Mining Software Repositories, MSR 2020. Proceedings - 2020 IEEE/ACM 17th International Conference on Mining Software Repositories, MSR 2020, ACM Press, pp. 327-338. https://doi.org/10.1145/3379597.3387467","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:publications.polymtl.ca:46005","is_oa":false,"landing_page_url":"https://publications.polymtl.ca/46005/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401013","display_name":"PolyPublie (\u00c9cole Polytechnique de Montr\u00e9al)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I45683168","host_organization_name":"Polytechnique Montr\u00e9al","host_organization_lineage":["https://openalex.org/I45683168"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Communication de conf\u00e9rence"},{"id":"pmh:oai:publications.polymtl.ca:9344","is_oa":false,"landing_page_url":"https://publications.polymtl.ca/9344/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401013","display_name":"PolyPublie (\u00c9cole Polytechnique de Montr\u00e9al)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I45683168","host_organization_name":"Polytechnique Montr\u00e9al","host_organization_lineage":["https://openalex.org/I45683168"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Communication de conf\u00e9rence"}],"best_oa_location":{"id":"pmh:oai:pure.unamur.be:openaire/05f63182-7493-4e55-9bc5-15cfb19d5be8","is_oa":true,"landing_page_url":"https://researchportal.unamur.be/en/publications/05f63182-7493-4e55-9bc5-15cfb19d5be8","pdf_url":"https://pure.unamur.be/ws/files/51694829/2020_NagyCleve_article.pdf","source":{"id":"https://openalex.org/S4406922457","display_name":"Repository of the University of Namur","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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Asmare Muse, B, Rahman, M, Nagy, C, Cleve, A, Khomh, F & Antoniol, G 2020, On the Prevalence, Impact, and Evolution of SQL code smells in Data-Intensive Systems. in Proceedings - 2020 IEEE/ACM 17th International Conference on Mining Software Repositories, MSR 2020. Proceedings - 2020 IEEE/ACM 17th International Conference on Mining Software Repositories, MSR 2020, ACM Press, pp. 327-338. https://doi.org/10.1145/3379597.3387467","raw_type":"contributionToPeriodical"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.44999998807907104}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W3090668201.pdf"},"referenced_works_count":59,"referenced_works":["https://openalex.org/W1484413656","https://openalex.org/W1511637839","https://openalex.org/W1968074466","https://openalex.org/W1974655094","https://openalex.org/W1979300931","https://openalex.org/W1982871693","https://openalex.org/W1986136726","https://openalex.org/W2014418158","https://openalex.org/W2017709030","https://openalex.org/W2031808517","https://openalex.org/W2034400602","https://openalex.org/W2036570657","https://openalex.org/W2037965136","https://openalex.org/W2044556410","https://openalex.org/W2064873664","https://openalex.org/W2068321882","https://openalex.org/W2132516581","https://openalex.org/W2139851189","https://openalex.org/W2140504739","https://openalex.org/W2146335723","https://openalex.org/W2147386665","https://openalex.org/W2148143831","https://openalex.org/W2150874999","https://openalex.org/W2155427153","https://openalex.org/W2160506632","https://openalex.org/W2164519300","https://openalex.org/W2166559705","https://openalex.org/W2187668060","https://openalex.org/W2233582420","https://openalex.org/W2277619875","https://openalex.org/W2294550615","https://openalex.org/W2346524137","https://openalex.org/W2472868278","https://openalex.org/W2735562533","https://openalex.org/W2742512005","https://openalex.org/W2751366560","https://openalex.org/W2754176165","https://openalex.org/W2765714642","https://openalex.org/W2767336637","https://openalex.org/W2787379525","https://openalex.org/W2792987835","https://openalex.org/W2807540194","https://openalex.org/W2808642230","https://openalex.org/W2809221603","https://openalex.org/W2883645417","https://openalex.org/W2888977970","https://openalex.org/W2899407111","https://openalex.org/W2902819787","https://openalex.org/W2924144435","https://openalex.org/W2953617193","https://openalex.org/W2968524983","https://openalex.org/W2991727166","https://openalex.org/W4247554349","https://openalex.org/W4248662185","https://openalex.org/W4253336088","https://openalex.org/W4255783720","https://openalex.org/W4255973387","https://openalex.org/W4293241248","https://openalex.org/W6628750762"],"related_works":["https://openalex.org/W2088986462","https://openalex.org/W2780981476","https://openalex.org/W2955607951","https://openalex.org/W3166181464","https://openalex.org/W2187939805","https://openalex.org/W125071098","https://openalex.org/W2517910349","https://openalex.org/W2946499381","https://openalex.org/W3153400467","https://openalex.org/W4229981338"],"abstract_inverted_index":{"Code":[0],"smells":[1,21,64,80,93,104,116,132,169,187,195,199],"indicate":[2],"software":[3,8,99,179],"design":[4],"problems":[5],"that":[6,12,124,166],"harm":[7],"quality.":[9],"Data-intensive":[10],"systems":[11],"frequently":[13],"access":[14],"databases":[15],"often":[16],"suffer":[17],"from":[18],"SQL":[19,44,62,78,91,102,114,130,167,193],"code":[20,34,45,63,79,92,103,111,115,127,131,153,160,168,194,198],"besides":[22],"the":[23,57,140,143,152,176],"traditional":[24,33,76,110,126,159,197],"smells.":[25,46,112,128,161],"While":[26],"there":[27,37],"have":[28,105,117],"been":[29,39],"extensive":[30],"studies":[31],"on":[32],"smells,":[35],"recently,":[36],"has":[38],"a":[40,106,118,155],"growing":[41],"interest":[42],"in":[43,65,81,97,151,175],"In":[47],"this":[48],"paper,":[49],"we":[50],"conduct":[51],"an":[52],"empirical":[53],"study":[54],"to":[55,136,148,158],"investigate":[56],"prevalence":[58],"and":[59,73,77,146,173,188,191,196],"evolution":[60],"of":[61,125,142,185],"open-source,":[66],"data-intensive":[67,98,178],"systems.":[68,100,180],"We":[69],"collected":[70],"150":[71],"projects":[72],"examined":[74],"both":[75],"these":[82,186],"projects.":[83],"Our":[84],"investigation":[85],"delivers":[86],"several":[87],"important":[88],"findings.":[89],"First,":[90],"are":[94,133,170],"indeed":[95,171],"prevalent":[96,172],"Second,":[101],"weak":[107],"co-occurrence":[108],"with":[109,121],"Third,":[113],"weaker":[119],"association":[120],"bugs":[122],"than":[123],"Fourth,":[129],"more":[134],"likely":[135,147],"be":[137,149,183],"introduced":[138],"at":[139],"beginning":[141],"project":[144],"lifetime":[145],"left":[150],"without":[154],"fix,":[156],"compared":[157],"Overall,":[162],"our":[163],"results":[164],"show":[165],"persistent":[174],"studied":[177],"Developers":[181],"should":[182],"aware":[184],"consider":[189],"detecting":[190],"refactoring":[192],"separately,":[200],"using":[201],"dedicated":[202],"tools.":[203]},"counts_by_year":[{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":10},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}