On the prevalence, impact, and evolution of sql code smells in data-intensive systems

BA Muse, MM Rahman, C Nagy, A Cleve… - Proceedings of the 17th …, 2020 - dl.acm.org
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 …

A static code smell detector for SQL queries embedded in Java code

C Nagy, A Cleve - … Conference on Source Code Analysis and …, 2017 - ieeexplore.ieee.org
A database plays a central role in the architecture of an information system, and the way it
stores the data delimits its main features. However, it is not just the data that matters. The …

Detecting and preventing program inconsistencies under database schema evolution

L Meurice, C Nagy, A Cleve - 2016 IEEE International …, 2016 - ieeexplore.ieee.org
Nowadays, data-intensive applications tend to access their underlying database in an
increasingly dynamic way. The queries that they send to the database server are usually …

Hbsniff: A static analysis tool for java hibernate object-relational map** code smell detection

Z Huang, Z Shao, G Fan, H Yu, K Yang… - Science of Computer …, 2022 - Elsevier
Code smells are symptoms of sub-optimal software design and implementation choices.
Detection tools were actively developed for general code smell related to coupling and …

SQLInspect: A static analyzer to inspect database usage in Java applications

C Nagy, A Cleve - Proceedings of the 40th international conference on …, 2018 - dl.acm.org
We present SQLInspect, a tool intended to assist developers who deal with SQL code
embedded in Java applications. It is integrated into Eclipse as a plug-in that is able to extract …

An empirical study of local database usage in android applications

Y Lyu, J Gui, M Wan… - 2017 IEEE International …, 2017 - ieeexplore.ieee.org
Local databases have become an important component within mobile applications.
Developers use local databases to provide mobile users with a responsive and secure …

SLocator: Localizing the Origin of SQL Queries in Database-Backed Web Applications

W Liu, TH Chen - IEEE Transactions on Software Engineering, 2023 - ieeexplore.ieee.org
In database-backed web applications, developers often leverage Object-Relational Map**
(ORM) frameworks for database accesses. ORM frameworks provide an abstraction of the …

Supporting schema evolution in schema-less NoSQL data stores

L Meurice, A Cleve - 2017 IEEE 24th International Conference …, 2017 - ieeexplore.ieee.org
NoSQL data stores are becoming popular due to their schema-less nature. They offer a high
level of flexibility, since they do not require to declare a global schema. Thus, the data model …

MSR4ML: Reconstructing artifact traceability in machine learning repositories

AT Njomou, AJB Africa, B Adams… - 2021 IEEE International …, 2021 - ieeexplore.ieee.org
The increasing popularity of Machine Learning (ML) is generating challenges also for
developers. The multitude of programming languages, libraries and available resources …

[HTML][HTML] Best practices of testing database manipulation code

M Gobert, C Nagy, H Rocha, S Demeyer, A Cleve - Information systems, 2023 - Elsevier
Software testing enables development teams to maintain the quality of a software system
while it evolves. The database manipulation code requires special attention in this context …