A Multi-copy Join Optimization of Information Integration Systems Based on a Genetic Algorithm

Fang, Liying; Wang, Pu; Yan, Jianzhuo

doi:10.1109/iccgi.2008.20

Cited by 4 publications

(1 citation statement)

References 7 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Fang et al [19] suggested a novel multi-copy join optimization technique grounded on genetic algorithm to achieve comprehensive query redrafting using replications into consideration. The recommended join optimization technique contemplates together selecting redundant duplicates of a universal vision and probing for a comparative low-cost join order using its encrypting structures and distinct genetic functions.…”

Section: Literature Surveymentioning

confidence: 99%

Query optimization using clustering and Genetic Algorithm for Distributed Databases

Lakshmi

Kumari

2016

2016 International Conference on Computer Communication and Informatics (ICCCI)

View full text Add to dashboard Cite

Query Optimization is principally a multifaceted exploration job that searches for best plan amongst the semantically equal plans that are obtained from any given query. The execution of any processing datasets essentially depends on the capability of query optimization procedure to acquire competent query processing approaches. A Distributed Database System (DDS) is a group of autonomous cooperating integrated procedure. Query at a specified place may necessitate information from distant places in a Distributed Environment. In query optimization, the cost is accompanied by every query execution plan. Cost is the summation of native cost that is I/O cost, CPU cost at every location and cost of transmitting information amongst locations. The key issue of a Query Optimization in a Distributed Database System is to obtain an effective query strategy with an efficient accuracy and minimum response time or cost to execute the given query. In this paper a novel methodology is suggested that selected the best query plan as to execute the given query employing Genetic Algorithm Strategy for Distributed Databases and a Clustering Approach within the databases so as to execute the query plan. Genetic Algorithms are extensively employed and acceptable methods for very challenging optimization problems. This proposed technique gives efficient performance in different environment. The Experimental analysis of the proposed methodology is carried out on 100 different queries distributed over 20 different sites having 8 relations in each query. This is compared with the DB2 distributed optimizers and achieved an increased reliability and high performance with respect to the optimization cost and accuracy for the queries in the distributed databases

show abstract

Section: Literature Surveymentioning

confidence: 99%