The week's pick
Random Articles
Reseach Article
Executing Joins Dynamically in Distributed Database System Query Optimizer
| 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
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
- 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)
- Pawandeep Kaur, Jaspreet Kaur Sahiwal "join query optimization in distributed databases" Published in the preceding of International journal of scientific and research publication 2013
- 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)
- M. Tamer Ozsu, Patrick Valduriez, "Principles of Distributed Database Systems", Third Edition, Springer, 2011
- Ms. Preeti tiwari et al "query optimization stratergies in distributed databases" in the proceedings of 2nd international conference on ICETEM 2013
- S. Pramanik, et al. "Optimizting join queries in Distributed Databases"IEEE 2002.
- Sunita M. Mahan, Vaishali P. jadhav "tri-variate optimization strategies of semi join technique o distributed databases" International journal of computer applications (2013)
- Xiaofeng Li et al " Study of query of distributed database based on relation semi join" International Conference on Computer Design and Applications 2010 .
- Lin Zhou,Yan Chen et. al "The semi join query optimization distributed database system The National Conference on Information Technology and Computer Science 2012.
- "Database Concepts" seventh edition by Navathe.
- Kumar, Saurabh, et al. "Cost-Based Query Optimization with Heuristics. " International Journal of Scientific & Engineering Research vol 2. 9 2011
Index Terms
Keywords