{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,20]],"date-time":"2026-03-20T15:53:15Z","timestamp":1774021995703,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":63,"publisher":"ACM","license":[{"start":{"date-parts":[[2020,6,29]],"date-time":"2020-06-29T00:00:00Z","timestamp":1593388800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2020,6,29]]},"DOI":"10.1145\/3379597.3387467","type":"proceedings-article","created":{"date-parts":[[2020,9,19]],"date-time":"2020-09-19T02:12:49Z","timestamp":1600481569000},"page":"327-338","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":37,"title":["On the Prevalence, Impact, and Evolution of SQL Code Smells in Data-Intensive Systems"],"prefix":"10.1145","author":[{"given":"Biruk Asmare","family":"Muse","sequence":"first","affiliation":[{"name":"Polytechnique Montr\u00e9al"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mohammad Masudur","family":"Rahman","sequence":"additional","affiliation":[{"name":"Polytechnique Montr\u00e9al"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Csaba","family":"Nagy","sequence":"additional","affiliation":[{"name":"Software Institute, Universit\u00e0 della Svizzera italiana"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Anthony","family":"Cleve","sequence":"additional","affiliation":[{"name":"Namur Digital Institute, University of Namur"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Foutse","family":"Khomh","sequence":"additional","affiliation":[{"name":"Polytechnique Montr\u00e9al"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Giuliano","family":"Antoniol","sequence":"additional","affiliation":[{"name":"Polytechnique Montr\u00e9al"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2020,9,18]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.5267\/j.ijdns.2017.1.003"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/170035.170072"},{"key":"e_1_3_2_1_3_1","volume-title":"Proc. 20th Int. Conf. Very Large Data Bases, VLDB","volume":"1215","author":"Agrawal Rakesh","year":"1994","unstructured":"Rakesh Agrawal , Ramakrishnan Srikant , 1994 . Fast algorithms for mining association rules . In Proc. 20th Int. Conf. Very Large Data Bases, VLDB , Vol. 1215 . 487--499. Rakesh Agrawal, Ramakrishnan Srikant, et al. 1994. Fast algorithms for mining association rules. In Proc. 20th Int. Conf. Very Large Data Bases, VLDB, Vol. 1215. 487--499."},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/SNAMS.2018.8554909"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-017-9540-2"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1463788.1463819"},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2017.2772252"},{"key":"e_1_3_2_1_8_1","volume-title":"Fourth International Conference on Quality Software, 2004. QSIC 2004. Proceedings. 250--257","author":"Brass S.","unstructured":"S. Brass and C. Goldberg . 2004. Semantic errors in SQL queries: a quite complete list . In Fourth International Conference on Quality Software, 2004. QSIC 2004. Proceedings. 250--257 . S. Brass and C. Goldberg. 2004. Semantic errors in SQL queries: a quite complete list. In Fourth International Conference on Quality Software, 2004. QSIC 2004. Proceedings. 250--257."},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/253262.253325"},{"key":"e_1_3_2_1_10_1","volume-title":"Beyond Databases, Architectures and Structures. Facing the Challenges of Data Proliferation and Growing Variety, Stanis\u0142aw Kozielski, Dariusz Mrozek, Pawe\u0142 Kasprowski, Bo\u017cena Ma\u0142ysiak-Mrozek","author":"Burza\u0144ska Marta","unstructured":"Marta Burza\u0144ska and Piotr Wi\u015bniewski . 2018. How Poor Is the \"Poor Man's Search Engine\"? . In Beyond Databases, Architectures and Structures. Facing the Challenges of Data Proliferation and Growing Variety, Stanis\u0142aw Kozielski, Dariusz Mrozek, Pawe\u0142 Kasprowski, Bo\u017cena Ma\u0142ysiak-Mrozek , and Daniel Kostrzewa (Eds.). Springer International Publishing , Cham , 294--305. Marta Burza\u0144ska and Piotr Wi\u015bniewski. 2018. How Poor Is the \"Poor Man's Search Engine\"?. In Beyond Databases, Architectures and Structures. Facing the Challenges of Data Proliferation and Growing Variety, Stanis\u0142aw Kozielski, Dariusz Mrozek, Pawe\u0142 Kasprowski, Bo\u017cena Ma\u0142ysiak-Mrozek, and Daniel Kostrzewa (Eds.). Springer International Publishing, Cham, 294--305."},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1613\/jair.953"},{"key":"e_1_3_2_1_12_1","volume-title":"Mathematical methods of statistics","author":"Cramer Harald","year":"1946","unstructured":"Harald Cramer . 1946. Mathematical methods of statistics . Princeton U. Press , Princeton ( 1946 ), 500. Harald Cramer. 1946. Mathematical methods of statistics. Princeton U. Press, Princeton (1946), 500."},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICPC.2019.00025"},{"key":"e_1_3_2_1_14_1","volume-title":"2013 IEEE International Conference on Software Maintenance. 260--269","author":"Fontana F. A.","unstructured":"F. A. Fontana , V. Ferme , A. Marino , B. Walter , and P. Martenka . 2013. Investigating the Impact of Code Smells on System's Quality: An Empirical Study on Systems of Different Application Domains . In 2013 IEEE International Conference on Software Maintenance. 260--269 . F. A. Fontana, V. Ferme, A. Marino, B. Walter, and P. Martenka. 2013. Investigating the Impact of Code Smells on System's Quality: An Empirical Study on Systems of Different Application Domains. In 2013 IEEE International Conference on Software Maintenance. 260--269."},{"key":"e_1_3_2_1_15_1","volume-title":"Refactoring: Improving the Design of Existing Code","author":"Fowler Martin","year":"1999","unstructured":"Martin Fowler , Kent Beck , John Brant , William Opdyke , Don Roberts , and Erich Gamma . 1999 . Refactoring: Improving the Design of Existing Code . Addison-Wesley Longman Publishing Co., Inc. , USA. Martin Fowler, Kent Beck, John Brant, William Opdyke, Don Roberts, and Erich Gamma. 1999. Refactoring: Improving the Design of Existing Code. Addison-Wesley Longman Publishing Co., Inc., USA."},{"key":"e_1_3_2_1_16_1","volume-title":"About Semantic Errors in Database Queries. In In 7th Workshop on Teaching, Learning and Assessment in Databases. 13--19","author":"Goldberg Christian","year":"2009","unstructured":"Christian Goldberg . 2009 . Do You Know SQL? About Semantic Errors in Database Queries. In In 7th Workshop on Teaching, Learning and Assessment in Databases. 13--19 . Christian Goldberg. 2009. Do You Know SQL? About Semantic Errors in Database Queries. In In 7th Workshop on Teaching, Learning and Assessment in Databases. 13--19."},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2007.4362684"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/s11219-016-9318-6"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/QUATIC.2010.61"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/2897073.2897100"},{"key":"e_1_3_2_1_21_1","volume-title":"Retrieved","author":"GitHub Inc.","year":"2019","unstructured":"GitHub Inc. 2019 . Search . Retrieved December 28, 2019 from https:\/\/developer.github.com\/v3\/search\/ GitHub Inc. 2019. Search. Retrieved December 28, 2019 from https:\/\/developer.github.com\/v3\/search\/"},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/3341620.3341632"},{"key":"e_1_3_2_1_23_1","volume-title":"A large-scale empirical study of code smells in JavaScript projects. Software Quality Journal","author":"Johannes David","year":"2019","unstructured":"David Johannes , Foutse Khomh , and Giuliano Antoniol . 2019. A large-scale empirical study of code smells in JavaScript projects. Software Quality Journal ( 2019 ), 1--44. David Johannes, Foutse Khomh, and Giuliano Antoniol. 2019. A large-scale empirical study of code smells in JavaScript projects. Software Quality Journal (2019), 1--44."},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2012.70"},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1080\/01621459.1958.10501452"},{"key":"e_1_3_2_1_26_1","unstructured":"Bill Karwin. 2010. SQL Antipatterns: Avoiding the pitfalls of database programming. Pragmatic Bookshelf.  Bill Karwin. 2010. SQL Antipatterns: Avoiding the pitfalls of database programming. Pragmatic Bookshelf."},{"key":"e_1_3_2_1_27_1","volume-title":"Market Basket Analysis: Identify the changing trends of market data using association rule mining. Procedia computer science 85","author":"Kaur Manpreet","year":"2016","unstructured":"Manpreet Kaur and Shivani Kang . 2016. Market Basket Analysis: Identify the changing trends of market data using association rule mining. Procedia computer science 85 ( 2016 ), 78--85. Manpreet Kaur and Shivani Kang. 2016. Market Basket Analysis: Identify the changing trends of market data using association rule mining. Procedia computer science 85 (2016), 78--85."},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1109\/MOBILESoft.2017.29"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1109\/WCRE.2009.28"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2010.11.921"},{"key":"e_1_3_2_1_31_1","volume-title":"2017 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD). 199--205","author":"Khumnin P.","unstructured":"P. Khumnin and T. Senivongse . 2017. SQL antipatterns detection and database refactoring process . In 2017 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD). 199--205 . P. Khumnin and T. Senivongse. 2017. SQL antipatterns detection and database refactoring process. In 2017 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD). 199--205."},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2007.70773"},{"key":"e_1_3_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2006.10.018"},{"key":"e_1_3_2_1_34_1","unstructured":"Red Gate Software Ltd. 2014. 119 SQL Code Smells.  Red Gate Software Ltd. 2014. 119 SQL Code Smells."},{"key":"e_1_3_2_1_35_1","volume-title":"Quantifying the Performance Impact of SQL Antipatterns on Mobile Applications. In 2019 IEEE International Conference on Software Maintenance and Evolution (ICSME). 53--64","author":"Lyu Y.","year":"2019","unstructured":"Y. Lyu , A. Alotaibi , and W. G. J. Halfond . 2019 . Quantifying the Performance Impact of SQL Antipatterns on Mobile Applications. In 2019 IEEE International Conference on Software Maintenance and Evolution (ICSME). 53--64 . Y. Lyu, A. Alotaibi, and W. G. J. Halfond. 2019. Quantifying the Performance Impact of SQL Antipatterns on Mobile Applications. In 2019 IEEE International Conference on Software Maintenance and Evolution (ICSME). 53--64."},{"key":"e_1_3_2_1_36_1","volume-title":"On the Relevance of Code Anomalies for Identifying Architecture Degradation Symptoms. In 2012 16th European Conference on Software Maintenance and Reengineering. 277--286","author":"Macia I.","year":"2012","unstructured":"I. Macia , R. Arcoverde , A. Garcia , C. Chavez , and A. von Staa . 2012 . On the Relevance of Code Anomalies for Identifying Architecture Degradation Symptoms. In 2012 16th European Conference on Software Maintenance and Reengineering. 277--286 . I. Macia, R. Arcoverde, A. Garcia, C. Chavez, and A. von Staa. 2012. On the Relevance of Code Anomalies for Identifying Architecture Degradation Symptoms. In 2012 16th European Conference on Software Maintenance and Reengineering. 277--286."},{"key":"e_1_3_2_1_37_1","volume-title":"M\u00e4ntyl\u00e4 and Casper Lassenius","author":"Mika","year":"2006","unstructured":"Mika V. M\u00e4ntyl\u00e4 and Casper Lassenius . 2006 . Subjective evaluation of software evolvability using code smells: An empirical study. Empirical Software Engineering 11, 3 (01 Sep 2006), 395--431. Mika V. M\u00e4ntyl\u00e4 and Casper Lassenius. 2006. Subjective evaluation of software evolvability using code smells: An empirical study. Empirical Software Engineering 11, 3 (01 Sep 2006), 395--431."},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-39696-5_30"},{"key":"e_1_3_2_1_39_1","volume-title":"Survival analysis","author":"Miller Rupert G","unstructured":"Rupert G Miller Jr . 2011. Survival analysis . Vol. 66 . John Wiley & Sons . Rupert G Miller Jr. 2011. Survival analysis. Vol. 66. John Wiley & Sons."},{"key":"e_1_3_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2000.883028"},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00165-009-0115-x"},{"key":"e_1_3_2_1_42_1","unstructured":"Biruk Asmare Muse. 2020. Replication package. https:\/\/github.com\/Biruk-Asmare\/MSR_2020_SQLSmells_Prevalence  Biruk Asmare Muse. 2020. Replication package. https:\/\/github.com\/Biruk-Asmare\/MSR_2020_SQLSmells_Prevalence"},{"key":"e_1_3_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1109\/SCAM.2017.19"},{"key":"e_1_3_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183440.3183496"},{"key":"e_1_3_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1109\/ESEM.2009.5314231"},{"key":"e_1_3_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2010.5609564"},{"key":"e_1_3_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.5555\/2819009.2819162"},{"key":"e_1_3_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-017-9535-z"},{"key":"e_1_3_2_1_49_1","volume-title":"2014 IEEE International Conference on Software Maintenance and Evolution. 101--110","author":"Palomba F.","unstructured":"F. Palomba , G. Bavota , M. D. Penta , R. Oliveto , and A. D. Lucia . 2014. Do They Really Smell Bad? A Study on Developers' Perception of Bad Code Smells . In 2014 IEEE International Conference on Software Maintenance and Evolution. 101--110 . F. Palomba, G. Bavota, M. D. Penta, R. Oliveto, and A. D. Lucia. 2014. Do They Really Smell Bad? A Study on Developers' Perception of Bad Code Smells. In 2014 IEEE International Conference on Software Maintenance and Evolution. 101--110."},{"key":"e_1_3_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/CSMR.2012.79"},{"key":"e_1_3_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.2307\/2344317"},{"key":"e_1_3_2_1_52_1","volume-title":"Discovery, analysis, and presentation of strong rules. Knowledge discovery in databases","author":"Piatetsky-Shapiro Gregory","year":"1991","unstructured":"Gregory Piatetsky-Shapiro . 1991. Discovery, analysis, and presentation of strong rules. Knowledge discovery in databases ( 1991 ), 229--238. Gregory Piatetsky-Shapiro. 1991. Discovery, analysis, and presentation of strong rules. Knowledge discovery in databases (1991), 229--238."},{"key":"e_1_3_2_1_53_1","volume-title":"Object-Oriented Design Heuristics","author":"Riel Arthur J.","unstructured":"Arthur J. Riel . 1996. Object-Oriented Design Heuristics ( 1 st ed.). Addison-Wesley Longman Publishing Co., Inc. , USA. Arthur J. Riel. 1996. Object-Oriented Design Heuristics (1st ed.). Addison-Wesley Longman Publishing Co., Inc., USA.","edition":"1"},{"key":"e_1_3_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2018.03.009"},{"key":"e_1_3_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2018.07.035"},{"key":"e_1_3_2_1_56_1","doi-asserted-by":"crossref","unstructured":"T. Sharma M. Fragkoulis S. Rizou M. Bruntink and D. Spinellis. 2018. Smelly Relations: Measuring and Understanding Database Schema Quality. In 2018 IEEE\/ACM 40th International Conference on Software Engineering: Software Engineering in Practice Track (ICSE-SEIP). 55--64.  T. Sharma M. Fragkoulis S. Rizou M. Bruntink and D. Spinellis. 2018. Smelly Relations: Measuring and Understanding Database Schema Quality. In 2018 IEEE\/ACM 40th International Conference on Software Engineering: Software Engineering in Practice Track (ICSE-SEIP). 55--64.","DOI":"10.1145\/3183519.3183529"},{"key":"e_1_3_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1109\/ITNG.2006.31"},{"key":"e_1_3_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2012.89"},{"key":"e_1_3_2_1_59_1","volume-title":"ACM sigsoft software engineering notes","author":"\u015aliwerski Jacek","unstructured":"Jacek \u015aliwerski , Thomas Zimmermann , and Andreas Zeller . 2005. When do changes induce fixes? . In ACM sigsoft software engineering notes , Vol. 30 . ACM , 1--5. Jacek \u015aliwerski, Thomas Zimmermann, and Andreas Zeller. 2005. When do changes induce fixes?. In ACM sigsoft software engineering notes, Vol. 30. ACM, 1--5."},{"key":"e_1_3_2_1_60_1","doi-asserted-by":"publisher","DOI":"10.1145\/3236024.3264598"},{"key":"e_1_3_2_1_61_1","volume-title":"Evaluation and improvement of software architecture: Identification of design problems in object-oriented systems and resolution through refactorings. Diss. Ph. D. dissertation","author":"Tsantalis Nikolaos","year":"2010","unstructured":"Nikolaos Tsantalis . 2010. Evaluation and improvement of software architecture: Identification of design problems in object-oriented systems and resolution through refactorings. Diss. Ph. D. dissertation , Univ. of Macedonia ( 2010 ). Nikolaos Tsantalis. 2010. Evaluation and improvement of software architecture: Identification of design problems in object-oriented systems and resolution through refactorings. Diss. Ph. D. dissertation, Univ. of Macedonia (2010)."},{"key":"e_1_3_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.5555\/2486788.2486878"},{"key":"e_1_3_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.1145\/1985362.1985366"}],"event":{"name":"MSR '20: 17th International Conference on Mining Software Repositories","location":"Seoul Republic of Korea","acronym":"MSR '20","sponsor":["SIGSOFT ACM Special Interest Group on Software Engineering","IEEE CS","SIGAI ACM Special Interest Group on Artificial Intelligence","SIGKDD ACM Special Interest Group on Knowledge Discovery in Data"]},"container-title":["Proceedings of the 17th International Conference on Mining Software Repositories"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3379597.3387467","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3379597.3387467","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T22:41:20Z","timestamp":1750200080000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3379597.3387467"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,6,29]]},"references-count":63,"alternative-id":["10.1145\/3379597.3387467","10.1145\/3379597"],"URL":"https:\/\/doi.org\/10.1145\/3379597.3387467","relation":{},"subject":[],"published":{"date-parts":[[2020,6,29]]},"assertion":[{"value":"2020-09-18","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}