Research on Query Optimization Technology of Distributed Database System

Computer & Telecommunication

Current Issue | Archive | Adv Search

China People's Police University(Guangzhou)

Download:

PDF(0KB)
Export: BibTeX | EndNote (RIS)

Abstract The increasing amount of data in the database makes it time-consuming and laborious for users to query using the database system. The traditional query optimization method has been unable to meet the requirements of today's data query, thus improving the efficiency of database system optimization has become a hot spot of research. In this paper, the distributed query processing tech- nology based on the semi join algorithm is proposed to optimize the database system. This paper selects the semi join algorithm to optimize the algorithm design, proposes the semi join operation query optimization algorithm (SDD-1), and verifies it by experiment to calculate the cost of the query algorithm. The results show that the query optimization strategy can significantly reduce the trans- mission cost and improve the overall efficiency of query.

Key words： distributed database query optimization algorithm

Published: 10 March 2020

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	ZHAO Hong-fei

Cite this article:

ZHAO Hong-fei. Research on Query Optimization Technology of Distributed Database System. Computer & Telecommunication, 2020, 1(3): 55-58.

URL:

https://www.computertelecom.com.cn/EN/ OR https://www.computertelecom.com.cn/EN/Y2020/V1/I3/55

[1]	DING Wen-chao YU Shuang-bo XUE Yan-zhu FANG Dong-li. A Trust Service Adaptation Method Based on Security Proxy[J]. 电脑与电信, 2024, 1(6): 31-34.
[2]	WANG Yu-lin　WANG Jin-heng　ZHAO Yu-qi　XIE Xiao-hui. Teaching Innovation and Practice of "Triple Optimization and Innovation" in the Course of Database Principle and Application in Private Universities under the Background of Information Technology Innovation[J]. 电脑与电信, 2024, 1(5): 42-.
[3]	WANG Zi-ming　XIAO Da-wei　LIU Ya-nan. Knowledge Graph Construction for Data Science and Big Data Technology[J]. 电脑与电信, 2024, 1(1): 32-34.
[4]	QI Xin YU Yan MA Ning WU Hao-qian. Whale Optimization Algorithm with Aquila Exploration Method[J]. 电脑与电信, 2023, 1(11): 7-13.
[5]	XUE Zi-yun LI Zhong WANG Zhi ZHANG Li-li SONG Qing-chang. Prediction of Waterlogging Depth in Bridges and Culverts Based on PSO-SVR[J]. 电脑与电信, 2023, 1(11): 29-.
[6]	TANG Xiao-qing. A Semi-supervised Linear Subspace Learning Approach via Sparse Coding[J]. 电脑与电信, 2021, 1(8): 44-48.
[7]	CHEN Shuang-quan. Design of Real-time Database for Automatic Measurement and Control System [J]. 电脑与电信, 2021, 1(8): 49-51.
[8]	YUAN Jing. Research on the Resource Library Model of Database Course Based on Cloud Storage [J]. 电脑与电信, 2021, 1(12): 50-52.
[9]	TONG Wei HUANG Qi-ping. Optimization Strategy of Privacy-oriented BRNN Protection [J]. 电脑与电信, 2021, 1(12): 58-61.
[10]	CHEN Ya-rui YANG Guang. Research and Practice of Blended Teaching Mode Based on OBE under the Background of New Engineering--Take Database Principle Course for Example [J]. 电脑与电信, 2021, 1(12): 66-68.
[11]	ZHANG Shu-rong. Practice of the Cloud Teaching Mode in the Course of Database Programming[J]. 电脑与电信, 2020, 1(8): 71-74.
[12]	YANG Qing-hu. Research on High-quality Teaching Design of Database Foundation Course in Private Vocational Colleges[J]. 电脑与电信, 2020, 1(8): 86-.
[13]	ZHOU Hong-cheng FENG Kai-zheng XIAO Feng . Intelligent Forestry System Design Based on Big Data[J]. 电脑与电信, 2020, 1(4): 56-59.
[14]	DENG Hong-yuan. Research on Identification of Radar Signal Features Based on Support Vector Machine Parameter Optimization[J]. 电脑与电信, 2020, 1(3): 44-46.
[15]	GUO Xiao-lei SHI Hong-ye. Design and Development of Wechat Program for Doctors' Follow-up[J]. 电脑与电信, 2020, 1(12): 40-.

Viewed

Full text

Abstract

Cited

Shared

Discussed