Proceedings of the 2012 National Conference on Information Technology and Computer Science

The Semi-join Query Optimization In Distributed Database System

Authors
Lin Zhou, Yan Chen, Taoying Li, Yingying Yu
Corresponding Author
Lin Zhou
Available Online November 2012.
DOI
10.2991/citcs.2012.232How to use a DOI?
Keywords
distributed database; semi-join operation; query optimization
Abstract

In distributed database system, the distributed deposition and redundancy data brought convenient to fault recovery, but they make distributed query processing more complicated at the same time. Query optimization and processing is one of the key technologies in distributed database system. It generally uses semi-join operation to improve the time response performance of query and reduce communication cost. This paper briefly described the corresponding concepts and characteristics of distributed database system, summarized the goals of distributed database query optimization, and analyzed the query optimization process based on semi-join operation combined with the practical application. In addition, it introduced a classical algorithm which is used for multiple connection and query optimization based on the semi-join query optimization, the SDD-1 algorithm.

Copyright
© 2012, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2012 National Conference on Information Technology and Computer Science
Series
Advances in Intelligent Systems Research
Publication Date
November 2012
ISBN
978-94-91216-39-8
ISSN
1951-6851
DOI
10.2991/citcs.2012.232How to use a DOI?
Copyright
© 2012, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Lin Zhou
AU  - Yan Chen
AU  - Taoying Li
AU  - Yingying Yu
PY  - 2012/11
DA  - 2012/11
TI  - The Semi-join Query Optimization In Distributed Database System
BT  - Proceedings of the 2012 National Conference on Information Technology and Computer Science
PB  - Atlantis Press
SP  - 913
EP  - 916
SN  - 1951-6851
UR  - https://doi.org/10.2991/citcs.2012.232
DO  - 10.2991/citcs.2012.232
ID  - Zhou2012/11
ER  -