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

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).