Abstract

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

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.