%0 Journal Article
%T General Framework for Optimization of Distributed Queries
%A Sunita M. Mahajan
%A Vaishali P. Jadhav
%J International Journal of Database Management Systems
%D 2012
%I Academy & Industry Research Collaboration Center (AIRCC)
%X The paper suggests the heuristic approach for selecting the optimal evaluation plan and Semi-join approach for reducing the communication cost. Calculating the cost of each evaluation plan of a query takes lots of computational efforts as well as time. Initially the heuristic approach is used to find best evaluation plan among various plans of a single query. By considering only joins, queries are divided into two: tree and cyclic. Semi-join is a useful tool to reduce the cost of joins. The communication cost in distributed database is mainly depending upon the amount of data transferred from one site to another site. Semi-join approach is sufficient to fully reduce the tree queries while semi-joins are not the full reducers for cyclic queries. Cyclic queries are therefore converted into tree queries using different approaches such as addition of vertices, elimination of vertices, decomposition of vertices and elimination of edges. After conversion of cyclic to tree query, semi-join approach can be used.
%K Heuristics
%K Query Optimization
%K Cost-Based Optimization
%K Tree query
%K Cyclic query
%U http://airccse.org/journal/ijdms/papers/4312ijdms03.pdf