On the Prevalence, Impact, and Evolution of SQL code smells in Data-Intensive Systems
| العنوان: | On the Prevalence, Impact, and Evolution of SQL code smells in Data-Intensive Systems |
|---|---|
| المؤلفون: | Biruk Asmare Muse, Csaba Nagy, Giuliano Antoniol, Foutse Khomh, Anthony Cleve, Mohammad Masudur Rahman |
| المصدر: | 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.3387467Test MSR |
| بيانات النشر: | ACM Press, 2020. |
| سنة النشر: | 2020 |
| مصطلحات موضوعية: | FOS: Computer and information sciences, SQL, database access, Computer science, 02 engineering and technology, computer.software_genre, GeneralLiterature_MISCELLANEOUS, Computer Science - Software Engineering, Software_SOFTWAREENGINEERING, 020204 information systems, 0202 electrical engineering, electronic engineering, information engineering, Code (cryptography), Software system, computer.programming_language, business.industry, Code smell, data-intensive systems, 020207 software engineering, SQL code smells, Database access, Software quality, Software Engineering (cs.SE), Code refactoring, Software design, InformationSystems_MISCELLANEOUS, Software engineering, business, computer, Code smells |
| الوصف: | 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. |
| وصف الملف: | application/pdf |
| اللغة: | English |
| الوصول الحر: | https://explore.openaire.eu/search/publication?articleId=doi_dedup___::9af3bb95b76f8e1c428b160993818efaTest https://researchportal.unamur.be/en/publications/05f63182-7493-4e55-9bc5-15cfb19d5be8Test |
| حقوق: | OPEN |
| رقم الانضمام: | edsair.doi.dedup.....9af3bb95b76f8e1c428b160993818efa |
| قاعدة البيانات: | OpenAIRE |
| الوصف غير متاح. |