Author
Ersoy, E., Altınışık, M., Sözer, Hasan
Publication Date
2017
Publication Place
-
CEUR-WS
Subject
Software architecture, Impact analysis, Software maintenance, PL/SQL, Software architecture, Impact analysis, Software maintenance
Type
Document
Language
Turkish
Digital
Yes
Manuscript
No
Library
Özyeğin University
Library Asset ID
1613-0073
Record ID
63131c2d-ae12-469b-816f-57a1e7aded05
Library Location
Computer Science
Date
2017
Sample Text
Programs written in PL/SQL language are developed as procedure and function objects on the database, and as package objects containing a set of these objects. These objects extensively use database objects such as tables and views. With existing analysis tools, it is possible to see which other objects each object is dependent on. However, this information is provided at the package level, and information on which database elements are used for each procedure and function within the packages cannot be accessed. Especially in programs that have been maintained for many years, packages contain a large number of procedures and functions, and breaking these packages apart at certain times is beneficial in terms of maintainability. For this purpose, an analysis tool has been developed to support the restructuring of programs and impact analysis of changes. This tool can detect common database tables used by the procedures and functions within the packages and thus supports design decisions with change impact analysis. The analysis tool we developed has been applied to a customer relationship management system in a technology company. PL/SQL programs are composed of procedure and function objects deployed on a database. These objects can be grouped into a set of package objects and they extensively use database objects such as tables and views. Existing analysis tools can detect which objects are dependent on which other objects. However, this information is available only at the package level. It is not possible to detect database dependencies of procedures and functions that are encapsulated in packages. Existing packages might include many procedures and functions and they might have to be refactored to improve software maintainability, especially in the case of legacy systems that are maintained for years. In this work, we developed a dependency analysis tool to support software refactoring and impact analysis. This tool detects database dependencies of procedures and functions taking place in packages. It supports change impact analysis and design decisions by detecting database tables commonly accessed by various objects. We applied our tool on a customer relations management system maintained by a technology firm.
Editör
Turhan, Ç., Coşkunçay, A., Yazıcı, A., Oğuztüzün, H.
Cilt
1980
