TY  - JOUR
T1  - Applying Game Theory to Restructure PL/SQL Code
AU - Nehemiah, H. Khanna AU - Vimala, S. AU - Bhuvaneswaran, R.S. AU - Saranya, G. AU - Kannan, A. 
JO  - International Journal of Soft Computing
VL  - 7
IS  - 6
SP  - 264
EP  - 270
PY  - 2012
DA  - 2001/08/19
SN  - 1816-9503
DO  - ijscomp.2012.264.270
UR  - https://makhillpublications.co/view-article.php?doi=ijscomp.2012.264.270
KW  - Refactoring
KW  -restructuring
KW  -game theory
KW  -packaging
KW  -pay-off matrix
KW  -Nash equilibrium
KW  -PL/SQL
KW  -structural similarity
AB  - 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.
ER  -