Mobile Agent Cooperation Methods in Hybrid Query Optimization

Abstract

The database field has developed very powerful technologies for finding efficient execution plans for declaratively specified queries. Moreover, database queries have increasingly complex in the age of the distributed DBMS (DDBMS). In order to optimize queries accurately, sufficient information must be available to determine which data access techniques are most effective. The role of query optimization is to find a strategy close to optimal. To optimize the query efficiently, it is important to choose the site to execute. For site selection, the statistical information of underlining relations is essential. In this paper, we propose the query optimization model based on mobile agents. This model provides a strategy for executing each query over the network in the most cost-effective way. Our proposed system focuses on these modules: Query Decomposition: decomposes the input query into mono-relation query using the detachment techniques, Optimization Plan: computes all possible plans using statistical database information and intermediate relation size by cooperating with mobile agents and chooses the optimized plan and Execution Plan: executes the optimized plan by using mobile agent and send results to client.

XML based Mediated Query Re-writing Framework

“…These limitations arise because the P2P systems lack focus on the areas of semantics, data transformation, and data relationships. Yet, these are some of the core strengths of data management, where queries, views, and integrity constraints can be used to express relationships between existing objects [24,25].…”

“…There are many processes through which the data is processed to take the form of information such as aggregation, consolidation, cleansing, filtering, transformation, and validation. For successful implementation of information integration framework the organization must addresses following capabilities [24,25].…”