A novel way of accessing Pl/Sql functions and providing dynamic adaptability using aspect oriented programming

The need for dynamic adaptability in software is growing, driven in part by the emergence of autonomic computing. In many cases, it is desirable to enhance existing programs with adaptive behaviour, enabling them to execute effectively in dynamic environments. Aspect Oriented Programming (AOP), a relatively new programming paradigm, earned the scientific community's attention. AOP complements Object-Oriented Programming (OOP) by providing another way of thinking about program structure. AOP defines a new program construct, called an aspect, which is used to capture cross-cutting aspects of a software system in separate program entities. Although persistence has been considered as an aspect of a system aspects in the persistence domain in general and in databases in particular have been largely ignored. Persistent objects in an object database need to be adapted, either by physical conversion or wrapping. In this paper we are using Aspect Oriented Programming (AOP) to enable dynamic adaptation while accessing PL/SQL (Procedural Language/Structured Query Language) functions. An aspect-oriented extension of an Object Oriented Data Base (OODB) is discussed and various open issues pointed out. We propose an approach to implement dynamic adaptability, reusability especially for PL/SQL functions. We have used AspectJ; Object Oriented Programming based language to create aspects in Eclipse supported framework.