Details

Autor(en) / Beteiligte

• Zager Al Saedi, Ahmed Khalaf
• Ghazali, Rozaida bt
• Bin Mat Deris, Mustafa

Titel

An efficient multi join query optimization for DBMS using swarm intelligent approach

Ist Teil von

• 2014 4th World Congress on Information and Communication Technologies (WICT 2014), 2014, p.113-117

Ort / Verlag

IEEE

Erscheinungsjahr

2014

Quelle

IEEE Electronic Library Online

Beschreibungen/Notizen

• In the era of information technology, various professions are Multi Join Query Optimization (MJQO) in database management system (DBMS) such as Search engine, Data mining, Decision support system, Data warehouse and Banking system, Information retrieval (IR) make very important field to study. The increase in the amount of database and number of tables and blocks in database as well as inadequate technology have caused the multi join query optimization (MJQO) problem to remain unsolved. The problems of MJQO include the large size of queries (measure of numbers in join relation), high processing cost and long query execution time. Using swarm intelligent approaches as method to solve (MJQO) problem is practical and provide benefits for DBMS. This paper gives out a Swarm intelligence (Bees Algorithm) method towards the optimization of DBMS queries, And the propose method find Reasonable solution more efficiency than PSO algorithm, which fastest convergence rate among all known solution for MJQO. It reduces the response time of query processing. Simulation shows proposed algorithm can solve MJQO problem in less amount of time than particle swarm optimization (PSO).