PL/SQL programları için otomatik prosedür gruplama

Large software systems have to be decomposed into separate, modular units for providing appropriate abstractions and improving maintainability. There exist clustering techniques that are applied to provide such abstractions by automatically grouping system modules based on dependencies among them. Hereby, dependency is usually measured as the extent to which a module refers to elements of another module. This approach cannot be directly applied for all types of programs. Some programs involve modules that are indirectly coupled. For instance, PL/SQL programs include procedures that are in most cases coupled due to their database operations although they do not make calls to each other. In this thesis, we provide an approach and a tool that supports automated modularization of software systems by considering this type of dependencies We also extend this approach for multiple, different types of dependencies. We construct several dependency matrices each of which captures a different type of dependency among the system modules. First, we perform clustering according to each of these matrices separately. Then, we perform cluster aggregation (meta clustering) on the obtained clustering results to propose a packaging structure to the designer. We performed two industrial case studies on real PL/SQL programs from the telecommunications domain. Many unexisted packages were proposed by our tool and the accuracy of the results were confirmed by domain experts.