Implementing mobile agent to improve structured query language (sql)‎ performance

Abstract EN

Putting any application in production phase can reveal a lot of factors and problems of how transactions and queries use the database.

Because any database application performance totally depends on impeded SQL commands written inside it.

To enhance the performance, the application source should be modified and the SQL command should be rewritten again. This paper presents a mobile agent as a middle layer between application interface front end and database back end.

The responsibilities of the mobile agent are catching the SQL commands sent by application before reaching the database then examining these commands, correct them if they have errors, and rewrite them in a tuned format if the SQL commands are not tuned.

The mobile agent will focus on rewriting the SQL commands without application modification.