On the prevalence, impact, and evolution of sql code smells in data-intensive systems
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 …
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
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 …
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
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 …
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 …
Detection tools were actively developed for general code smell related to coupling and …
SQLInspect: A static analyzer to inspect database usage in Java applications
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 …
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
Local databases have become an important component within mobile applications.
Developers use local databases to provide mobile users with a responsive and secure …
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 …
(ORM) frameworks for database accesses. ORM frameworks provide an abstraction of the …
Supporting schema evolution in schema-less NoSQL data stores
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 …
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 …
developers. The multitude of programming languages, libraries and available resources …
[HTML][HTML] Best practices of testing database manipulation code
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 …
while it evolves. The database manipulation code requires special attention in this context …