CFP last date
20 June 2024
Call for Paper
July Edition
IJCA solicits high quality original research papers for the upcoming July edition of the journal. The last date of research paper submission is 20 June 2024

Submit your paper
Know more
Reseach Article

Executing Joins Dynamically in Distributed Database System Query Optimizer

by Sofia Gupta, Rajinder Singh, Tirath Singh
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 97 - Number 2
Year of Publication: 2014
Authors: Sofia Gupta, Rajinder Singh, Tirath Singh
10.5120/16983-7046

Sofia Gupta, Rajinder Singh, Tirath Singh . Executing Joins Dynamically in Distributed Database System Query Optimizer. International Journal of Computer Applications. 97, 2 ( July 2014), 38-41. DOI=10.5120/16983-7046

@article{ 10.5120/16983-7046,
author = { Sofia Gupta, Rajinder Singh, Tirath Singh },
title = { Executing Joins Dynamically in Distributed Database System Query Optimizer },
journal = { International Journal of Computer Applications },
issue_date = { July 2014 },
volume = { 97 },
number = { 2 },
month = { July },
year = { 2014 },
issn = { 0975-8887 },
pages = { 38-41 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume97/number2/16983-7046/ },
doi = { 10.5120/16983-7046 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:23:05.916134+05:30
%A Sofia Gupta
%A Rajinder Singh
%A Tirath Singh
%T Executing Joins Dynamically in Distributed Database System Query Optimizer
%J International Journal of Computer Applications
%@ 0975-8887
%V 97
%N 2
%P 38-41
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In order to join two sub queries involving data from multiple sites data has to be transmitted from one site to other. While transmitting the data within a network, the factors involved in distributed databases is communication cost and amount of data transmitted. To minimize these factors, join operation is used. There are two cases considered in which query processing using join and query processing using semi join are described. The amount of data transfer in case of join is more than in case of semi join. Hence sub operations are executed dynamically to improve the communication cost .

References
  1. Manik Sharma, Dr. Gurvinder singh, Rajinder Virk "Analysis of joins and semi joins in a distributed database query" published in preceding of International journal of computer application (2012)
  2. Pawandeep Kaur, Jaspreet Kaur Sahiwal "join query optimization in distributed databases" Published in the preceding of International journal of scientific and research publication 2013
  3. Ridhi kapoor et al. "selectivity and cost estimates of query optimization in distributed databases" international journal of enhanced research in management and computer applications (2013)
  4. M. Tamer Ozsu, Patrick Valduriez, "Principles of Distributed Database Systems", Third Edition, Springer, 2011
  5. Ms. Preeti tiwari et al "query optimization stratergies in distributed databases" in the proceedings of 2nd international conference on ICETEM 2013
  6. S. Pramanik, et al. "Optimizting join queries in Distributed Databases"IEEE 2002.
  7. Sunita M. Mahan, Vaishali P. jadhav "tri-variate optimization strategies of semi join technique o distributed databases" International journal of computer applications (2013)
  8. Xiaofeng Li et al " Study of query of distributed database based on relation semi join" International Conference on Computer Design and Applications 2010 .
  9. Lin Zhou,Yan Chen et. al "The semi join query optimization distributed database system The National Conference on Information Technology and Computer Science 2012.
  10. "Database Concepts" seventh edition by Navathe.
  11. Kumar, Saurabh, et al. "Cost-Based Query Optimization with Heuristics. " International Journal of Scientific & Engineering Research vol 2. 9 2011
Index Terms

Computer Science
Information Sciences

Keywords

Distributed database query optimization data transfer join semijoin etc.