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 134
- Downloads 0
ENERGY EFFICIENT DATA GATHERING SCHEME USING CROSS LAYER CLUSTER APPROACH FOR WIRELESS SENSOR NETWORKS
Recent advances in wireless communication technology and research in ad hoc wireless networks have made smart sensing a reality. A Wireless Sensor Networks (WSNs) is composed of a number of wireless sensor nodes which fo...
A QOS AWARE QUANTITATIVE WEB SERVICE SELECTION MODEL
Web service is a core technology for sharing information resources and integrating processes in companies or organizations. As the number of applications connected by Web service is increased, the importance of Web servi...
Search Engine Optimization through Spanning Forest Generation Algorithm
Search engine technology has had to scale dramatically to keep up with the growth of the web. With the tremendous growth of information available to end users through the Web, search engines come to play ever a more crit...
Overview Of Various Overlapping Community Detection Approaches
With the advancement in technology, we are surrounded with huge amount of data, which need to be processed in some manner for further processing. For this purpose, we may combine the Data Mining Techniques with the conce...
PREPROCESSING OF WEB LOGS
Today’s real world databases are highly susceptible to noisy, missing and inconsistent data due to their typically huge size data and their origin from multiple, heterogeneous sources. Hence, pre-processing of data is ne...