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 135
- Downloads 0
An Overview on Intrusion Detection in Manet
A mobile ad hoc network (MANET) is a self-configuring of mobile devices network connected without wires and hence MANET has become a very popular technology now days. A MANETS are the networks that are building, when som...
Discovery of students’ academic patterns using data mining techniques
Knowledge discovery is an emerging field which combines the techniques from mathematics, statistics, algorithms and Artificial Intelligence to extract the knowledge. Data mining is a main phase of Knowledge Discovery in...
Agents- based Methodology for Wireless Sensor Networks
Nowadays, agents-based systems are widely used to solve many engineering problems. The characteristics of the agents-based approach enable them to be used for the wireless sensor networks (WSNs) successfully. The propose...
A Secure Data Classification Model for achieving Data Confidentiality and Integrity in Cloud Environment
Cloud computing offers numerous benefits including scalability, availability and many services. It needs to address three main security issues: confidentiality, integrity and availability. It is on demand and pay per use...
Control overhead reduction: A Hierarchical Routing Protocol In Mobile Ad hoc Networks
A novel self-organizing hierarchical architecture is proposed for improving the scalability properties of ad-hoc wireless networks. This paper focuses on the design and evaluation of routing protocols applicable to this...