MSR 2020
Mon 29 - Tue 30 June 2020
co-located with ICSE 2020
Mon 29 Jun 2020 12:20 - 12:30 at MSR:Zoom - Code Smells Chair(s): Alessandro Garcia

Code smells indicate software design problems that harm software quality. Data-intensive systems that frequently access databases often suffer from SQL code smells besides the traditional smells. While there have been extensive studies on traditional code smells, recently, there has been a growing interest in SQL code smells. In this paper, we conduct an empirical study to investigate the prevalence and evolution of SQL code smells in open source, data-intensive systems. We collected 150 projects and examined both traditional and SQL code smells in these projects. Our investigation delivers several important findings. First, SQL code smells are indeed prevalent in data-intensive software systems. Second, SQL code smells have a weak co-occurrence with traditional code smells. Third, SQL code smells have a weaker association with bugs than that of traditional code smells. Fourth, SQL code smells are more likely to be introduced at the beginning of the project lifetime and likely to be left in the code without a fix, compared to traditional code smells. Overall, our results show that SQL code smells are indeed prevalent and persistent in the studied data-intensive software systems. Developers should be aware of these smells and consider detecting and refactoring SQL code smells and traditional code smells separately, using dedicated tools.

Mon 29 Jun
Times are displayed in time zone: (UTC) Coordinated Universal Time change

msr-2020-papers
12:00 - 13:00: Technical Papers - Code Smells at MSR:Zoom
Chair(s): Alessandro GarciaPUC-Rio

Q/A & Discussion of Session Papers over Zoom (Joining info available on Slack)

msr-2020-papers12:00 - 12:10
Live Q&A
Pre-print Media Attached
msr-2020-papers12:10 - 12:20
Live Q&A
Davide SpadiniDelft University of Technology, Netherlands, Martin Schvarcbacher, Ana Maria Oprescu, Magiel BruntinkSoftware Improvement Group, Alberto BacchelliUniversity of Zurich
DOI Pre-print Media Attached
msr-2020-papers12:20 - 12:30
Live Q&A
Biruk Asmare Muse, Masud RahmanDalhousie University, Csaba NagySoftware Institute - USI, Lugano, Anthony CleveUniversity of Namur, Foutse KhomhPolytechnique Montréal, Giuliano AntoniolPolytechnique Montréal
Pre-print Media Attached
msr-2020-Registered-Reports12:30 - 12:40
Live Q&A
Mouna Abidi, Moses Openja, Foutse KhomhPolytechnique Montréal
Pre-print Media Attached
msr-2020-papers12:40 - 12:50
Live Q&A
Hadhemi Jebnoun, Masud RahmanDalhousie University, Foutse KhomhPolytechnique Montréal, Houssem Ben Braiek
Pre-print Media Attached
msr-2020-papers12:50 - 13:00
Live Q&A
Fabiano PecorelliUniversity of Salerno, Fabio PalombaUniversity of Salerno, Foutse KhomhPolytechnique Montréal, Andrea De LuciaUniversity of Salerno
Pre-print Media Attached