Automated transformation of database queries to Enterprise JavaBeans client code

With the emerging Enterprise JavaBeans (hereafter EJB) technology, many legacy systems need to be reengineered into an EJB-based architecture. Those legacy systems are typically database applications that use SQL statements to access a relational database directly. One of the research challenges in this reengineering effort is to find an algorithm to automatically translate database queries into EJB finder function calls.; A companion MSc. thesis [CHE03] implemented a query rewriting algorithm. Once an SQL query has been rewritten, query planning is used to determine if the results are executable and the order of query execution. Then, the output of the query rewriting algorithm needs to be transformed to Enterprise JavaBeans finder function calls. This thesis describes our implementation of an Enterprise JavaBeans client code generation system that uses binding theory in query planning and Eclipse technology.