Advanced Join Query Optimization Using Firefly and Reinforcement Learning Techniques on Tpc-H Dataset | [International Journal of Communication Networks and Information Security • 2024]

Author(s):

1. Karthikeyan M P: Department of Computer Science, Sri S.Ramasamy Naidu Memorial College, (Affiliated to Madurai Kamaraj University,Madurai), Sattur, Tamilnadu,India

2. Krishnaveni K: Department of Computer Science, Sri S. Ramasamy Naidu Memorial College, (Affiliated to Madurai Kamaraj University,Madurai), Sattur, Tamilnadu,India

Abstract:

Join query optimization is a critical component of database management systems (DBMS), significantly influencing their performance and efficiency. This study delves into advanced optimization techniques by employing the Firefly Algorithm and its hybrid integrations with Deep Q-Network (DQN) and Double Deep Q-Network (DDQN) methodologies. Utilizing the TPC-H benchmark dataset, we rigorously evaluate the efficacy of these algorithms in optimizing complex join queries. The Firefly Algorithm, inspired by the luminescent communication of fireflies, serves as a powerful metaheuristic optimization technique, adept at navigating vast search spaces. To augment this method, we incorporate reinforcement learning via DQN and DDQN, enhancing the algorithm's capability to balance exploration and exploitation during the optimization process. Our empirical analysis reveals substantial performance gains with the hybrid DQN-Firefly and DDQN-Firefly approaches compared to the standalone Firefly Algorithm. These findings underscore the potential of these hybrid methods for practical implementation in database management systems, promising improved query optimization and overall system performance.

Page(s): 367-385

DOI: DOI not available

Published: Journal: International Journal of Communication Networks and Information Security, Volume: 16, Issue: S1, Year: 2024

Keywords:

Network , DDQN , Dataset Reinforcement Learning Metaheuristic Algorithm Query , QNetwork , Execution Time , Double , Join Query Optimization Firefly Algorithm Deep Q , Deep , DQN , TPCH

References:

[1] MC .2023 .. , 1234567(2) : 22-27.

[2] Challenges ,Jan . .". IEEE Transactions on Cloud Computing, 12(1) : 34-45.

[3] Mar .2023 .. , 1234568 : .

[4] Environments . .". IEEE Transactions on Knowledge and Data Engineering, 35 : .

[5] .2023 .. , 1234569 : 1025-1036.

[6] Databases .2023 .". IEEE Access, 11 : 12345-12356.

[7] .2023 .. , 1234570 : .

[8] Game AI .2023 .". IEEE Transactions on Games, 15(1) : 45-56.

[9] .2023 .. , 3269789 : .

[10] .2023 .. , 34(1) : 78-89.

[11] .2023 .. , 3279901 : .

[12] Doe J.,Smith A. .2023 ."Rule-based Optimization Techniques for Improved. , : .

[13] Johnson E.,Lee C. .2024 ."A Cost-Based Optimization Approach for Dynamic. , : .

[14] . .. Resource Allocation in IoT Networks." IEEE Internet of Things Journal, 9(3) : 321.

[15] Gupta S.,Patel R. .2024 ."Hybrid Genetic Algorithm for Solving the Travelling Salesman Problem in Dynamic Environments.". IEEE Transactions on Evolutionary Computation, 20(2) : 234-247.

[16] Chen L.,Wang Y. .2023 ."Parallel Simulated Annealing for Solving LargeScale Vehicle Routing Problems.". IEEE Transactions on Systems, Man, and Cybernetics: Systems, 50(6) : 2456-2469.

[17] Kim H.,Park S. .2024 ."Improved Ant Colony Optimization for Solving the Task Allocation Problem in Wireless Sensor Networks.". IEEE Transactions on Mobile Computing, 23(1) : 78-89.

[18] Yang W.,Zhang Q. .2023 ."A Novel Particle Swarm Optimization Approach for Solving Multi-Objective Power Dispatch Problems in Smart Grids.". IEEE Transactions on Power Systems, 39(5) : 2789-2802.

[19] Sakai T.,Yoshikawa T.,Matsuo Y. .2023 ."Development of Firefly Algorithm for Multi-Objective Optimization,". IEEE Access, 3259823 : 125-137.

[20] Lee M.,Choi S.,Kim J. .2023 ."Reinforcement Learning-Based Join Query Optimization in Big Data Systems,". IEEE Transactions on Big Data, 3280032(1) : 101-112.

[21] Patel A.,Singh M.,Gupta R. .2023 ."Performance Benchmarking of SQL Queries using TPC-H Dataset on Cloud Platforms," *IEEE Cloud Computing*. , 3290911(1) : 33-42.

[22] r. Karthikeyan M P is a Ph ,JAIN ( .2015 .He has published more than 10 research papers in Various national. International Conferences and Scopus, : .

Citations

Downloads

Views