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:

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

[1]	TANG Xiao-qing. A Semi-supervised Linear Subspace Learning Approach via Sparse Coding[J]. 电脑与电信, 2021, 1(8): 44-48.
[2]	CHEN Shuang-quan. Design of Real-time Database for Automatic Measurement and Control System [J]. 电脑与电信, 2021, 1(8): 49-51.
[3]	ZHANG Shu-rong. Practice of the Cloud Teaching Mode in the Course of Database Programming[J]. 电脑与电信, 2020, 1(8): 71-74.
[4]	YANG Qing-hu. Research on High-quality Teaching Design of Database Foundation Course in Private Vocational Colleges[J]. 电脑与电信, 2020, 1(8): 86-.
[5]	ZHOU Hong-cheng FENG Kai-zheng XIAO Feng . Intelligent Forestry System Design Based on Big Data[J]. 电脑与电信, 2020, 1(4): 56-59.
[6]	DENG Hong-yuan. Research on Identification of Radar Signal Features Based on Support Vector Machine Parameter Optimization[J]. 电脑与电信, 2020, 1(3): 44-46.
[7]	GUO Xiao-lei SHI Hong-ye. Design and Development of Wechat Program for Doctors' Follow-up[J]. 电脑与电信, 2020, 1(12): 40-.
[8]	CHENG Min. Study on the“Four-stepAdvance Mode”of Teaching in Database Building and Management Course[J]. 电脑与电信, 2020, 1(10): 22-.
[9]	Li Yuzhong. Research on Large Array Multi-group Scanning Ultrasonic Phased Array System[J]. 电脑与电信, 2019, 1(7): 1-6.
[10]	SUN Pei-yan. Design and Implementation of Class OASystem Based on SQL SERVER[J]. 电脑与电信, 2019, 1(7): 46-48.
[11]	SI Xiao-yun SHEN Zheng LI Wei SUN Wei-hong GUO Hai-jun ZHENG Hong-mei DENG Na. Design and Development of Patient Information Management System Based on SQL Server and C#[J]. 电脑与电信, 2019, 1(6): 20-24.
[12]	LIU Xiao-qiang. Design and Implementation of Vehicle Search Engine in Insurance System Based on ElasticSearch[J]. 电脑与电信, 2019, 1(5): 51-55.
[13]	HU Xue-you HE Ming-chang ZHANG Yuan CAI Jia-hui LEI Xiao-long. Design and Implementation of Online Technical Support APP Based on ISM Model[J]. 电脑与电信, 2019, 1(4): 20-24.
[14]	CHENG Yuan-yuan CAO Yan DONG Hui MA Jian. Reform and Practice of the Teaching Model of Database Technology in Higher Vocational Colleges Based on WebQuest[J]. 电脑与电信, 2019, 1(4): 25-27.
[15]	PENG Yan-fang. Analysis of Causes and Countermeasures of Database Monopoly[J]. 电脑与电信, 2019, 1(3): 48-50.

Viewed

Full text

Abstract

Cited

Shared

Discussed