See this document in CiteSeerX!

Optimizing Nested Queries with Parameter Sort Orders (2005)  (Make Corrections)  
Ravindra Guravannavar Ramanujam H.S. S Sudarshan Bombay



  Home/Search   Context   Related

 
View or download:
vldb2005.org/progr...1guravannavar.pdf
Cached:  PS.gz  PS  PDF   Image  Update  Help

From:  vldb2005.org/pr...ull_program.php (more)
(Enter author homepages)

Rate this article: (best)
  Comment on this article  
(Enter summary)

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