Query Optimization: Finding the Optimal Execution Strategy
Journal Title: International Journal of Advanced Research in Computer Engineering & Technology(IJARCET) - Year 2013, Vol 2, Issue 2
Abstract
The query optimizer is the component of a database management system that attempts to determine the most efficient way to execute a query. The optimizer considers the possible query plans for a given input query, and attempts to determine which of those plans will be the most efficient. Cost-based query optimizers assign an estimated "cost" to each possible query plan, and choose the plan with the smallest cost. The distributed query optimization is one of the hardest problems in the database area. The great commercial success of database systems is partly due to the development of sophisticated query optimization technology where users pose queries in a declarative way using SQL or OQL and the optimizer of the database system finds a good way (i. e. plan) to execute these queries. t. There has been much research into this field. In this paper, we study the problem of distributed query optimization; we focus on the basic components of the distributed query optimizer, i. e. search space and search strategy. A survey of the available work into this field is given
Authors and Affiliations
Vinod S. Gangwan , Prof. P. L. Ramteke
Keywords
Related Articles
- EP ID EP115241
- DOI -
- Views 68
- Downloads 0
Review of methods for secret sharing in cloud computing
Cloud computing provides various IT services. Many companies especially those who are in their initial stages found this cloud IT service economically beneficial. This IT service paradigm still requires overcoming so...
Design of Reconfigure Virtual Channel Regulator for BiNoC Router
Network-on-Chip (NOC) has been proposed as an attractive alternative to traditional dedicated wire to achieve high performance and modularity. Power and Area efficiency is the most important concern in NOC design....
Packet Load Generator for Telecom Networks
In this is an era of drastic evolution Telecommunications, packet data communication has gained paramount attention due to increased internet multimedia usage. One of the challenges faced by telecom companies is to provi...
THERMAL ANALYSIS OF PRINTED CIRCUIT BOARD (PCB) OF AVIONICS EQUIPMENT
As the power requirements of advanced aircrafts steadily move towards higher density and higher heat loads, Requirements of thermal analysis for advanced avionics are becoming more severe and critical to avionics des...
“A Survey on Different Fingerprint Recognition Systems”
In this paper we are comparing various fingerprint recognition system which are based on minutiae and ridge feature extraction. Here we are comparing various methods using minutiae features only or ridge features o...