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

See this document in CiteSeerX!

Optimizing Queries with Aggregate Views (1996)  (Make Corrections)  (16 citations)
Surajit Chaudhuri, Kyuseok Shim
Extending Database Technology



  Home/Search   Context   Related

 
View or download:
belllabs.com/user/shim/edbt96.ps.gz
dblab.kaist.ac.kr/~shim/edbt96.ps.gz
cs.kaist.ac.kr/~shim/edbt96.ps
Cached:  PS.gz  PS  PDF   Image  Update  Help

From:  belllabs.com/user/shim/ (more)
From:  dblab.kaist.ac.kr/~shim/
(Enter author homepages)

Rate this article: (best)
  Comment on this article  
(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)

Related documents from co-citation:   More   All
8:   On optimizing an sql-like nested query (context) - Kim - 1982
8:   Complex query decorrelation (context) - Seshadri, Pirahesh et al. - 1996
8:   Of nests and trees: A unified approach to processing queries that contain nested.. (context) - Dayal - 1987

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