Improved SDD-1 query optimization algorithm

Yutong Fan; Yanming Zhang

doi:10.1117/12.3026345

27 March 2024 Improved SDD-1 query optimization algorithm

Yutong Fan, Yanming Zhang

Proceedings Volume 13105, International Conference on Computer Graphics, Artificial Intelligence, and Data Processing (ICCAID 2023); 1310547 (2024) https://doi.org/10.1117/12.3026345
Event: 3rd International Conference on Computer Graphics, Artificial Intelligence, and Data Processing (ICCAID 2023), 2023, Qingdao, China

Abstract

When a distributed database performs connection queries, the more objects involved in connection operations, the more likely it is to incur the problem of higher communication costs and longer execution plan generation time. In order to solve these problems, an O-SDD-1 algorithm based on SDD-1 algorithm is proposed, which uses the semi join technology in SDD-1 algorithm, the parallel retrieval ability in genetic algorithm, and the characteristics of positive feedback optimization in ant colony algorithm to design an O-SDD-1 algorithm with appropriate genetic operators, fitness functions, and algorithm convergence conditions. The experimental results show that the O-SDD-1 algorithm can reduce the communication cost generated by queries and shorten the time spent on generating execution plans, which can further improve query efficiency.

(2024) Published by SPIE. Downloading of the abstract is permitted for personal use only.

Citation Download Citation

Yutong Fan and Yanming Zhang "Improved SDD-1 query optimization algorithm", Proc. SPIE 13105, International Conference on Computer Graphics, Artificial Intelligence, and Data Processing (ICCAID 2023), 1310547 (27 March 2024); https://doi.org/10.1117/12.3026345

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available