WCSE 2017
ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.213

Detection of Stored Procedure Bad Smells

Sutthikan Naowarat, Pornsiri Muenchaisri

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.