Ravindra Guravannavar Ramanujam H.S. S Sudarshan Bombay  Home/Search
Context
Related
| vldb2005.org/progr...1guravannavar.pdf Cached: PS.gz PS PDF This document uses CoBlitz to cache paper downloads. If your firewall is blocking outgoing connections to port 3125, you can use these links to download local copies.
Image Update HelpPS.gz PS PDF From: vldb2005.org/pr...ull_program.php (more) (Enter author homepages) |
Rate this article:      (best)Comment on this article |
Abstract: Nested iteration is an important technique for query evaluation. It is the default way of executing nested subqueries in SQL. Although decorrelation often results in cheaper non-nested plans, decorrelation is not always applicable for nested subqueries. Nested iteration, if implemented properly, can also win over decorrelation for several classes of queries. Decorrelation is also hard to apply to nested iteration in user-defined SQL procedures and functions. Recent research has... (Update)
Active bibliography (related documents): More All
0.5: On Relational Support for XML Publishing: Beyond.. - Chaudhuri, Kaushik.. (2003) (Correct)
0.5: Main Memory Implementations for Binary Grouping - May, Moerkotte (2005) (Correct)
0.3: Analyzing Plan Diagrams of Database Query Optimizers - Naveen Reddy Jayant (Correct)
Similar documents based on text:
0.0: Unknown - (Correct)
BibTeX entry: (Update)
@misc{ ramanujam-optimizing,
author = "Ravindra Guravannavar Ramanujam",
title = "Optimizing Nested Queries with Parameter Sort Orders",
url = "citeseer.ist.psu.edu/737686.html" }
Citations (may not include all citations):104 The Volcano Optimizer Generator: Extensibility and Efficient.. - Graefe, McKenna - 1993
74 On Optimizing an SQL-like Nested Query (context) - Kim - 1982
59 Of Nests and Trees: A Unified approach to Processing Queries.. (context) - Dayal - 1987
53 Efficiently Publishing Relational Data as XML Documents - Shanmugasundaram - 2000
47 Optimization of Nested SQL Queries Revisited (context) - Ganski, Wong - 1987
32 Optimization of Queries with User-defined Predicates - Chaudhuri, Shim - 1996
32 Practical Predicate Placement - Hellerstein - 1994
26 Complex Query Decorrelation (context) - Seshadri, Pirahesh et al. - 1996
25 The Cascades Framework for Query Optimization (context) - Graefe - 1995
3 AniPQO: Almost nonintrusive parametric query optimization fo.. - Hulgeri, Sudarshan - 2003
2 Executing Nested Queries - Graefe - 2003
2 Orthogonal Optimization of Subqueries and Aggregation (context) - Galindo-Legaria, Joshi - 2001
1 Optimization and Dataflow Algorithms for Nested Queries (context) - Muralikrishna - 1989
1 Access Path Sselection in a Relational Database Management S.. (context) - Selinger, Astrahan et al. - 1979
1 Personal Communication (context) - Galindo-Legaria, Fraser - 2004
1 Advancement SQLXML (context) - Melton, SQL et al. - 2004
Documents on the same site (http://www.vldb2005.org/program/full_program.php): More
Getting Priorities Straight: Improving Linux Support for.. - Hall, Bonnet (2005) (Correct)
Improving Database Performance on Simultaneous.. - Zhou, Cieslewicz.. (2005) (Correct)
Tree-Pattern Queries on a Lightweight XML Processor - Moro, Vagena, Tsotras (2005) (Correct)
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC