Optimized Query Plan Algorithm for the Nested Query
Journal Title: International Journal on Computer Science and Engineering - Year 2010, Vol 2, Issue 3
Abstract
The SQL language allows users to express the queries that have nested sub-queries in them. Optimization of nested queries has received considerable attention over the last few years. Most of the previous optimization work has assumed that at most one block is nested within any given block. The two main contributions of this report are: 1. Optimization strategies for queries that have an arbitrary number of blocks nested within any given block, and 2. a new algorithm for the execution of nested queries, involving one or more other joins, in a multi-processor environment. The new algorithm cuts down the processing costs over conventional algorithms.
Authors and Affiliations
Chittaranjan Pradhan , Sushree Sangita Jena , Prasanta kumar Mahapatra
Keywords
Related Articles
- EP ID EP108044
- DOI -
- Views 112
- Downloads 0
An Application of time stamped proxy blind signature in e-voting
Voting is a way for a voter to make a decision or express an opinion or to choose a candidate. E-voting (Electronic Voting) refers to both the electronic means of casting a vote and the electronic means of counting and p...
An Extensive Study on the Future of Modeling in Software Development
In recent years, software modeling realized much attention in the field of software research and development due to demonstrating the capability of decreases time and cost of software development and also improves overal...
FCE: A QUALITY METRIC FOR COTS BASED SOFTWARE DESIGN
The software that is based on component is aimed at veloping large software systems thorough combining the xisting software components. Before integrate different omponents, first one need to identify whether functio...
Adaptation of Optimal Methods In Resource Utilization, Job Scheduling In Grids
A Optimal Grid should have Three characterstics : It should not allow resource providers to increase prices continuously, No provider should reject to provide resources to certain type of jobs due to risk associated in e...
A Survey on the Applications of Bee Colony Optimization Techniques
In this paper an overview of the areas where the Bee Colony Optimization (BCO) and its variants are applied have been given. Bee System was identified by Sato and Hagiwara in 1997 and the Bee Colony Optimization (BCO) wa...