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

Displayed 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 Garcia PUC-Rio

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

12:00
10m
Live Q&A
Detecting Video Game-Specific Bad Smells in Unity ProjectsMSR - Technical Paper
Technical Papers
Pre-print Media Attached
12:10
10m
Live Q&A
Investigating Severity Thresholds for Test SmellsMSR - Technical Paper
Technical Papers
Davide Spadini Delft University of Technology, Netherlands, Martin Schvarcbacher , Ana Oprescu University of Amsterdam, Magiel Bruntink Software Improvement Group, Alberto Bacchelli University of Zurich
DOI Pre-print Media Attached
12:20
10m
Live Q&A
On the Prevalence, Impact, and Evolution of SQL code smells in Data-Intensive SystemsMSR - Technical Paper
Technical Papers
Biruk Asmare Muse , Masud Rahman Dalhousie University, Csaba Nagy Software Institute - USI, Lugano, Anthony Cleve University of Namur, Foutse Khomh Polytechnique Montréal, Giuliano Antoniol Polytechnique Montréal
Pre-print Media Attached
12:30
10m
Live Q&A
Multi-language Design Smells: A Backstage PerspectiveMSR - Registered Reports
Registered Reports
A: Mouna Abidi , A: Moses Openja , A: Foutse Khomh Polytechnique Montréal
Pre-print Media Attached
12:40
10m
Live Q&A
The Scent of Deep Learning Code: An Empirical StudyMSR - Technical Paper
Technical Papers
Hadhemi Jebnoun , Masud Rahman Dalhousie University, Foutse Khomh Polytechnique Montréal, Houssem Ben Braiek
Pre-print Media Attached
12:50
10m
Live Q&A
Developer-Driven Code Smell PrioritizationMSR - Technical Paper
Technical Papers
Fabiano Pecorelli University of Salerno, Fabio Palomba University of Salerno, Foutse Khomh Polytechnique Montréal, Andrea De Lucia University of Salerno
Pre-print Media Attached