ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.213
Detection of Stored Procedure Bad Smells
Abstract— Stored procedures are commonly used in accessing and manipulating data in large-scale system
development to optimize the query database, reduce the application workloads and reduce the traffic
problems between the database and the application. If source code of stored procedures have bad smells, it
will have impact in modification, and eventually have a negative impact on their quality and maintainability.
This research proposes Tree Diagram and Context Analysis approach in detecting six different bad smells of
stored procedures. The tree diagram approach is the comparison tree diagram of bad smells and source code
which is written in PL/SQL. The context analysis approach is the creation of rules and qualifications of bad
smells for increasing the accuracy in detection. In addition, this research explains the overview process, the
algorithm process, and has uses example source code. The evaluation uses MI (Maintainability Index) to
present the approach which are practical and effective.
Index Terms— stored procedures, detection bad smells, tree diagram, context analysis, maintainability index
Sutthikan Naowarat, Pornsiri Muenchaisri
Department of Computer Engineering, Chulalongkorn University, THAILAND
ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.17Xsrc="http://www.wcse.org/uploadfile/2019/0823/20190823055609629.png" style="width: 120px; height: 68px;" />[Download]
Cite: Sutthikan Naowarat, Pornsiri Muenchaisri, "Detection of Stored Procedure Bad Smells," Proceedings of 2017 the 7th International Workshop on Computer Science and Engineering, pp. 1224-1229, Beijing, 25-27 June, 2017.