| Alternate document: Details Optimizing Queries over Multimedia Repositories (96) Surajit Chaudhuri, Luis Gravano |
| Alternate document: Details Optimizing Queries over Multimedia Repositories (96) Surajit Chaudhuri Hewlett-Packard Laboratories surajitc@microsoft.com Luis |
(Enter summary)
Abstract: . Complex queries, with aggregates, views and nested subqueries
are important in decision-support applications. Such queries are
represented as multi-block queries where a query block may be a view
definition containing aggregates or a correlated nested subquery. Beyond
transformations that propagate predicates across blocks, the problem of
optimizing such queries has not been addressed adequately. In this paper,
we show how such queries can be optimized in a cost-based fashion. The
crux of our ... (Update)
Similar documents based on text: More All
0.7: Serendipity - Life Is Full
(Correct)
0.6: Storage and Retrieval of XML Data using Relational.. - Surajit Chaudhuri.. (2001)
(Correct)
0.4: Remarks to Step by Step Application of Operations - Benecke
(Correct)
BibTeX entry: (Update)
S. Chaudhuri and K. Shim. Optimizing queries with aggregate views. In P. M. G. Apers, M. Bouzeghoub, and G. Gardarin, editors, Advances in Database Technology-- EDBT'96 5th Intl. Conf. on Extending Database Technology, volume 1057 of Lecture Notes in Computer Science, pages 167--182. Springer-Verlag, New York, 1996. http://citeseer.ist.psu.edu/chaudhuri96optimizing.html More
@inproceedings{ chaudhuri96optimizing,
author = "Surajit Chaudhuri and Kyuseok Shim",
title = "Optimizing Queries with Aggregate Views",
booktitle = "Extending Database Technology",
pages = "167-182",
year = "1996",
url = "citeseer.ist.psu.edu/chaudhuri96optimizing.html" }
Citations (may not include all citations):
389
Access path selection in a relational database management sy.. (context) - Selinger, Astrahan et al. - 1979
93
Aggregate-query processing in data warehousing environments
- Gupta, Harinarayan et al. - 1995
74
On optimizing an SQL-Like nested query (context) - Kim - 1982
68
Including group-by in query optimization
- Chaudhuri, Shim - 1994
59
Of nests and trees: A unified approach to processing queries.. (context) - Dayal - 1987
54
Query optimization by predicate move-around
- Levy, Mumick et al. - 1994
47
Optimization of nested SQL queries revisited (context) - Ganski, Wong - 1987
46
Eager aggregation and lazy aggregation
- Yan, Larson - 1995
44
Performing group-by before join
- Yan, Larson - 1994
34
Improved unnesting algorithms for join aggregate SQL queries (context) - Muralikrishna - 1992
18
Magic is relevant (context) - Mumick, Finkelstein et al. - 1990
3
Document ISO/IEC (context) - Language, ISO - 1992
3
rule based query optimization in starburst (context) - Pirahesh, Hellerstein et al. - 1992
2
Complex queries: A unified approach (context) - Chaudhuri, Shim - 1996
The graph only includes citing articles where the year of publication is known.
Documents on the same site (http://www-db.research.bell-labs.com/user/shim/): More
Query Optimization in the Presence of Foreign Functions - Chaudhuri, Shim (1993)
(Correct)
Mining Optimized Association Rules with Categorical and.. - Rastogi, Shim (1998)
(Correct)
Fast Similarity Search in the Presence of Noise, Scaling, and .. - Rakesh Agrawal (1995)
(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