G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984. Home/Search Document Not in Database Summary Related Articles Check |
This paper is cited in the following contexts:
Online Feedback for Nested Aggregate Queries with.. - Kian-Lee Tan Cheng (1999) (9 citations) (Correct)
....if these answers suffice for their decision making. However, the work is restricted to simple non nested queries. Nesting of query blocks is a very interesting and powerful feature of SQL. In fact, it has been noted that the nested form is often easier for users to formulate and to understand [12]. Existing research (on nested queries) has sought methods of reducing the evaluation costs, typically by transforming a nested query into a logically equivalent form that can be evaluated more efficiently [2, 3, 10] However, the class of nested queries with aggregates is especially interesting. ....
G.M. Lohman, D. Daniels, L.M. Haas, R. Kistler, and P.G. Selinger. Optimization of nested queries in a distributed relational database. In VLDB'84, pages 403--415, Singapore, June 1984.
Nested Queries in Object Bases - Cluet (31 citations) (Correct)
....efficiently. However, there exist some major differences between nested queries and joins that are, as stated in [12] the creation of duplicates and the way empty tables are handled. Indeed, these differences are at the bottom of most of the bugs subsequently detected in the original algorithms [10, 17, 6, 8, 11, 12]. To solve them and among other techniques, 8, 11] introduced outer joins. While these algebraic operators are a nice solution to some of the above problems, they raise new issues. If a sequence of join operations can easily be reordered, joins and outer joins do not commute that easily and one ....
G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984.
Classification and Optimization of Nested Queries in Object.. - Cluet, Moerkotte (1994) (5 citations) (Correct)
....is even more powerful and is used to more elegantly unnest queries where an outerjoin followed by a unary grouping is needed. The binary grouping operator generalizes the nest join operator of [29] The optimization of relational nested queries has been studied thoroughly in the last decade [20, 19, 13, 10, 14, 24, 26, 25]. Naturally, our research has been influenced by this body of work. The classification of relational nested queries introduced in [20] proved to be useful for relational unnesting. Based on this observation, we extended this classification to the oo context. This extension is necessary due to the ....
G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984.
Optimization Techniques For Queries with Expensive Methods - Hellerstein (1998) (26 citations) (Correct)
....in SQL; these are essentially named, correlated subqueries. The cost estimates presented here for query language methods form a simple model and raise some issues in setting costs for subqueries. The cost of a subquery predicate may be lowered by transforming it to another subquery predicate [Lohman et al. 1984], and by early stop techniques, which stop materializing or scanning a subquery as soon as the predicate can be resolved [Dayal 1987] Incorporating such schemes is beyond the scope of this paper, but including them into the framework of the later sections merely requires more careful estimates ....
Lohman, G. M., Daniels, D., Haas, L. M., Kistler, R., and Selinger, P. G. 1984. Optimization of Nested Queries in a Distributed Relational Database. In Proc. 10th International Conference on Very Large Data Bases (Singapore, Aug. 1984), pp. 403--415.
Nested Queries in Object Bases - Cluet, Moerkotte (1995) (31 citations) (Correct)
No context found.
G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984.
Nested Queries in Object Bases - Cluet, Moerkotte (1995) (31 citations) (Correct)
No context found.
G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984.
Predicate Migration: Optimizing Queries with Expensive.. - Hellerstein, Stonebraker (1993) (80 citations) (Correct)
No context found.
Guy M. Lohman, Dean Daniels, Laura M. Haas, Ruth Kistler, and Patricia G. Selinger. Optimization of Nested Queries in a Distributed Relational Database. In Proc. VLDB 87 [Pro87].
Predicate Migration: Optimizing Queries with Expensive Predicates - Hellerstein (1992) (80 citations) (Correct)
No context found.
Guy M. Lohman, Dean Daniels, Laura M. Haas, Ruth Kistler, and Patricia G. Selinger. Optimization of Nested Queries in a Distributed Relational Database. In Proc. VLDB 87 [Pro87].
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