Presenting a New Method for Optimizing Join Queries Processing in Heterogeneous Distributed Databases

Different methods have been presented to optimize the need to query processing optimization in databases. Reasons of these need increase the amount of data and the queries sent to the Database Management System. This article presents a multi agent system for heterogeneous distributed database by compiling two technologies of query processing optimization in database. This system is compatible of ordering adaptation and it is also flexible in adapting necessary changes as it progresses. In this system a new Algorithm based on modeling of users´ long term requirements is used. In this system an Agent gathers data related to manner of users´ usage from join in queries. Results of performances show that suggested Algorithm have high adaption ability with comparison to classic Algorithm.