Publication

Abstract : Success of any organization is based on the quality of the information system which undergoes many alterations during its life cycle. Hence, it can be quoted as an example for a live entity. Database is a core component in any information system and it gets affected due to change in business logic. A popularly used data model in any organization is the relational model. Changes that are made in relational schema also modify the queries that access the relations. It is really difficult to identify the set of queries that access the same relation in the case of large information system. Similarity measures concept is one of the techniques that are applied in object oriented programming for refactoring is used in this proposed system for restructuring procedures into packages by taking PL/SQL code as input. The proposed system groups those queries or procedures that access the same relations into a single package. The objective of this research is to determine whether the proposed methodology can be used as a mechanism to improve the maintainability of PL/SQL code. This process of packaging is done by applying game theory so as to increase understandability and maintainability of the system.