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 71
- Downloads 0
Comparison of Optimization Techniques for Mutual Information based Real Time Image Registration
Image registration is the process of aligning two or more images of the same scene. A direct image registration approach uses Mutual Information (MI) as an image alignment. Mutual Information is a measure of the si...
A Novel Watermarking Technique Based on Visual Cryptography
Digital Watermark processing technology has developed very rapidly during the recent years and widely applied to protect the copyright of digital image. In today’s scenario protection of digital data is utmost ne...
Hippocratic Database- Persisting privacy in e- banking
Preserving the private information in the era of web is one of the most challenging issue. Web services (e-health, ecommerce, e-banking) collect data from users and use them for other purposes. Sometimes data is shar...
A review of vertical handoff algorithms based on Multi Attribute Decision Method
Abstract - Next Generation Wireless Networks (NGWN) consists of heterogeneous networks with the support for vertical handoff. Hence vertical handoff algorithms (VHA) are the key components of NGWN. The vertical handoff...
My College Finder – An Android based application
In any field after higher secondary education there is an entrance examination for getting admission to graduation/post-graduation college. It may be engineering, diploma, M.Tech, MBA, MBBS or any other technical...