OPTIMIZING TECHNIQUES USING JOINS AND SEMI-JOINS

There has been extensive work in query optimization since the early 70’s. It is very tough for making a short summary in this resaech paper so , here we are only making concentration on the study of implementation of the join and its techniques for getting optimize result in minimum time.Semi-join is a technique for optimizing two or more database. Query optimization is a step for query processing ,now the study is going to be extended for distributed database, where the query optimizing is a important concern for making efficient result as it is difficult task for the distributed environment.

[1]  Haiming Wang,et al.  Principle and Performance of Semi-Persistent Scheduling for VoIP in LTE System , 2007, 2007 International Conference on Wireless Communications, Networking and Mobile Computing.

[2]  Dennis McLeod,et al.  An Adaptive Probe-Based Technique to Optimize Join Queries in Distributed Internet Databases , 2001, J. Database Manag..

[3]  Pedro Merino,et al.  Field measurements of mobile services with Android smartphones , 2012, 2012 IEEE Consumer Communications and Networking Conference (CCNC).

[4]  Surajit Chaudhuri,et al.  An overview of query optimization in relational systems , 1998, PODS.

[5]  Jani Puttonen,et al.  Voice-Over-IP Performance in UTRA Long Term Evolution Downlink , 2008, VTC Spring 2008 - IEEE Vehicular Technology Conference.

[6]  Henning Schulzrinne,et al.  RTP: A Transport Protocol for Real-Time Applications , 1996, RFC.

[7]  Chandra S. Bontu,et al.  DRX mechanism for power saving in LTE , 2009, IEEE Communications Magazine.

[8]  Antti Toskala,et al.  LTE for UMTS: Evolution to LTE-Advanced , 2011 .

[9]  Fan Yuanyuan,et al.  Distributed database system query optimization algorithm research , 2010, 2010 3rd International Conference on Computer Science and Information Technology.

[10]  Oliver M. Heckmann,et al.  The competitive Internet service provider : network architecture, interconnection, traffic engineering and network design , 2006 .

[11]  Tao Chen,et al.  Dynamic Packet Bundling for VoIP Transmission Over Rel'7 HSUPA with 10ms TTI Length , 2007, 2007 4th International Symposium on Wireless Communication Systems.

[12]  Michael Meyer,et al.  LTE Coverage Improvement by TTI Bundling , 2009, VTC Spring 2009 - IEEE 69th Vehicular Technology Conference.

[13]  Pedro Merino,et al.  Test environment for QoS testing of VoIP over LTE , 2012, 2012 IEEE Network Operations and Management Symposium.

[14]  Danièle Gardy,et al.  On the effect of join operations on relation sizes , 1989, TODS.

[15]  Ahmet Cosar,et al.  An evolutionary genetic algorithm for optimization of distributed database queries , 2009, 2009 24th International Symposium on Computer and Information Sciences.

[16]  Pedro Merino,et al.  Mobile Application Profiling for Connected Mobile Devices , 2010, IEEE Pervasive Computing.

[17]  Sakti Pramanik,et al.  Optimizing Join Queries in Distributed Databases , 1988, IEEE Trans. Software Eng..

[18]  Xi Jian.  Distributed Database System based on CSCW , 2000 .

[19]  Yonatan Levy,et al.  Admission control for VoIP calls with heterogeneous codecs , 2009, 2009 18th Annual Wireless and Optical Communications Conference.