Tuning SQL statements by implementing mobile agent transparent interface layer

Other Title(s)

تنغيم أوامر لغة الاستفسار المهيكلة باستحداث طبقة وسطية شفافة للوكيل المتنقل

Dissertant

Salih, Imad Hasan

Thesis advisor

al-Hamami, Ala Husayn

Comitee Members

al-Jabir, Ahmad Awdah
al-Shalabi, Riyad Farhan

University

Amman Arab University

Faculty

Collage of Computer Sciences and Informatics

Department

Department of Computer Science

University Country

Jordan

Degree

Master

Degree Date

2009

English Abstract

-Database applications performance depends on embedded SQL commands written inside the application.

So application developers have to write optimized SQL commands to gain performance.

Unfortunately some of application developers are novice programmers and the others do not care about performance.

To gain performance, application source code should be opened by programmers and SQL commands should be written again.

This research presents an agent as a middle layer between application interface front end and database back end.

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

This thesis will focus on rewriting the SQL commands without application modification.

This research presents the design and implementation of the agent as a proposed solution for SQL command tuning.

It includes the basic building blocks of the agent, and how these blocks communicate with each other to achieve the requirements.

In this thesis, the researcher describes the solution for each reason that makes the SQL command slow, designs an agent to receive poor commands and translates them to efficient commands, implements the agent in real word environment, and tests the results by comparing the old commands with new translated commands.

All of this work is done without opening the application source code and modifying it, the agent will do all of the work transparently without affecting the running application.

In this research, there is also a representation of performance analysis for the agent, comparing the SQL command with no agent environment by SQL command after implementing the agent through considering performance measurements metrics and statistics, such as real time, physical reads, logical reads and others.

The performance measurements benchmark test results of the proposed agent were highly and positively correlated with acceptance levels, and amazing achievement to score more than 99% of performance enhancement compared with no agent environment.

Mobile agent solution eliminates any development changes on the existing system, and uses existing features of the database, so the agent reduces the financial cost of application tuning.

Main Subjects

Mathematics

Topics

• Databases
• Relational databases

No. of Pages

107

Table of Contents

• APA
• MLA
• AMA

Language

English

Data Type

Arab Theses

Record ID

BIM-529167