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

12:00 - 13:00: Code SmellsTechnical Papers / Registered Reports / Keynote / MSR Awards / FOSS Award / Education / Data Showcase / Mining Challenge / MSR Challenge Proposals / Ask Me Anything at MSR:Zoom
Chair(s): Alessandro GarciaPUC-Rio

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

12:00 - 12:10
Live Q&A
Technical Papers
Pre-print Media Attached
12:10 - 12:20
Live Q&A
Technical Papers
Davide SpadiniDelft University of Technology, Netherlands, Martin Schvarcbacher, Ana Maria Oprescu, Magiel BruntinkSoftware Improvement Group, Alberto BacchelliUniversity of Zurich
DOI Pre-print Media Attached
12:20 - 12:30
Live Q&A
Technical Papers
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
12:30 - 12:40
Live Q&A
Registered Reports
A: Mouna Abidi, A: Moses Openja, A: Foutse KhomhPolytechnique Montréal
Pre-print Media Attached
12:40 - 12:50
Live Q&A
Technical Papers
Hadhemi Jebnoun, Masud RahmanDalhousie University, Foutse KhomhPolytechnique Montréal, Houssem Ben Braiek
Pre-print Media Attached
12:50 - 13:00
Live Q&A
Technical Papers
Fabiano PecorelliUniversity of Salerno, Fabio PalombaUniversity of Salerno, Foutse KhomhPolytechnique Montréal, Andrea De LuciaUniversity of Salerno
Pre-print Media Attached