A structural approach towards the maintenance of database applications

Author

Gardikiotis, S.K. ; Malevris, N. ; Konstantinou, T.

Author_Institution

Dept. of Informatics, Athens Univ. of Econ. & Bus., Greece

fYear

2004

fDate

7-9 July 2004

Firstpage

277

Lastpage

282

Abstract

The evolving nature of a database imposes continuous changes in both its structure and data that may respectively affect any dependent application. Within such a dynamic environment, there is a growing demand for methodologies focused on testing and maintaining database applications. Towards this direction a new approach is introduced that initially applies reverse engineering on the application in order to move the embedded SQL statements from the application code into the database. Subsequently, database schema modifications are classified according to their criticality to database related code. Critical changes are isolated and their impact is analyzed by using data flow information specifically tailored for the data manipulation language.

Keywords

SQL; data flow computing; database languages; database management systems; reverse engineering; data flow information; data manipulation language; database application maintenance; database application testing; database schema modifications; embedded SQL statements; reverse engineering; Application software; Computer languages; Data analysis; Databases; Environmental economics; Informatics; Information analysis; Reverse engineering; Testing; Utility programs;

fLanguage

English

Publisher

ieee

Conference_Titel

Database Engineering and Applications Symposium, 2004. IDEAS '04. Proceedings. International

ISSN

1098-8068

Print_ISBN

0-7695-2168-1

Type

conf

DOI

10.1109/IDEAS.2004.1319801

Filename

1319801