(Enter summary)
Abstract: We consider the problem of answering queries using only materialized views. We first show that if the views subsume the query from the point of view of the information content, then the query can be answered using only the views, but the resulting query might be extremely inefficient. We then focus on aggregate views and queries over a single relation, which are fundamental in many applications such as data warehousing. We show that in this case, it is possible to guarantee that as soon as the... (Update)
Context of citations to this paper: More
.... for answering the query if no other data are available, and negatively, for ensuring that the user does not derive sensitive information [14]. Also, the question is important at design time, in particular for the view selection problem [9] where we have to measure the quality...
.... the containment property of a materialized view with respect to its base data: a few of the many references in this area include [25, 6, 16, 2, 13]. However, the temporal aspects of content evolution have not been systematically addressed in this work. Refresh policies for...
Cited by: More
View-based Query Processing: - On The Relationship
(Correct)
Containment of Aggregate Queries - Sara Cohen Werner
(Correct)
Lossless Regular Views - Diego Calvanese Giuseppe (2002)
(Correct)
Active bibliography (related documents): More All
0.5: Optimal Bi-Level Augmentation for Selectively Enhancing Graph.. - Hsu, Kao (1996)
(Correct)
0.4: Automatic Aggregation using Explicit Metadata - Grumbach, Tininini (2000)
(Correct)
0.4: Querying Aggregate Data - Grumbach, Rafanelli, Tininini (1999)
(Correct)
Similar documents based on text: More All
0.1: New Techniques for Studying Set Languages, Bag Languages and.. - Libkin, Wong (1994)
(Correct)
0.1: In Search of the Lost Schema - Mecca (1999)
(Correct)
0.1: Spatio-Temporal Data Handling with Constraints - Grumbach, Rigaux, Segoufin (1998)
(Correct)
Related documents from co-citation: More All
9: Answering Queries Using Views
- Levy, Mendelzon et al. - 1995
9: Complexity of answering queries using materialized views
- Abiteboul, Duschka - 1998
7: Answering Recursive Queries Using Views
- Duschka, Genesereth - 1997
BibTeX entry: (Update)
Stephane Grumbach and Leonardo Tininini. On the content of materialized aggregate views. In Proc. of ACM Symposium on Principles of Database Systems (PODS), pages 47-57, 2000. http://citeseer.ist.psu.edu/grumbach00content.html More
@inproceedings{ grumbacht00pods,
author = {S. Grumbach and
L. Tininini},
title = {On the Content of Materialized Aggregate Views},
booktitle = {Proceedings of the Nineteenth ACM SIGMOD-SIGACT-SIGART Symposium
on Principles of Database Systems, PODS 2000},
publisher = {ACM},
year = {2000},
pages = {47-57},
url = {citeseer.ist.psu.edu/grumbach00content.html} }
Citations (may not include all citations):
775
Foundations of Databases (context) - Abiteboul, Hull et al. - 1995
393
Data cube: A relational aggregation operator generalizing gr..
- Gray, Bosworth et al. - 1996
296
Answering queries using views
- Levy, Mendelzon et al. - 1995
248
Implementing data cube efficiently
- Harinarayan, Rajaraman et al. - 1996
185
the computation of multidimensional aggregates
- Agarwal, Agrawal et al. - 1996
165
Research problems in data warehousing
- Widom - 1995
146
Optimizing queries with materialized views
- Chaudhuri, Krishnamurthy et al. - 1995
135
Complexity of Answering Queries Using Materialized Views
- Abiteboul, Duschka - 1998
107
Index selection for olap
- Gupta, Harinarayan et al. - 1997
102
Selection of views to materialize in a data warehouse
- Gupta - 1997
87
Modeling multidimensional databases
- Agrawal, Gupta et al. - 1997
77
Bottom-up computation of sparse and iceberg cubes
- Beyer, Ramakrishnan - 1999
64
Answering queries with aggregation using views
- Sristava, Dar et al. - 1996
52
Selection of views to materialize under a maintenance cost c..
- Gupta, Mumick - 1999
52
Computing iceberg queries efficiently
- Fang, Shivakumar et al. - 1998
50
Extending relational algebra and relational calculus with se.. (context) - Ozsoyoglu, Ozsoyoglu et al. - 1987
48
Rewriting aggregate queries using views
- Cohen, Nutt et al. - 1999
45
Maintenance of data cubes and summary tables in a warehouse
- Mumick, Quass et al. - 1997
36
Maintenance expressions for views with aggregation
- Quass - 1996
35
Olap and statistical databases: Similarities and differences
- Shoshani - 1997
27
Answering Queries Using Materialized Views with Disjunctions
- Afrati, Gergatsoulis et al. - 1999
26
Querying aggregate data
- Grumbach, Rafanelli et al. - 1999
25
Sleepers and workaholics: Caching strategies in mobile envir.. (context) - Barbar'a, Imielinski - 1995
9
View maintenance in mobile computing
- Wolfson, Sistla et al. - 1995
7
A universal-scheme approach to statistical databases contain.. (context) - Malvestuto - 1993
6
Computational issues connected with the protection of sensit.. (context) - Malvestuto, Moscarini - 1998
3
The aggregate data problem: a system for their definition an.. (context) - Rafanelli, Bezenchek et al. - 1996
2
Suppressing marginal cells to protect sensitive information .. (context) - Malvestuto, Moscarini et al. - 1991
1
Genesereth Answering Recursive Queries Using Views (context) - Duschka - 1997
The graph only includes citing articles where the year of publication is known.
Documents on the same site (http://cosmos.inria.fr:8080/cgi-bin/publisverso?what=byyear&query=0): More
Design and Implementation of Object-Oriented Views - Santos (1995)
(Correct)
Valmont: a Language for Workflow Programming - Chan, Leung (1998)
(Correct)
Relational Transducers for Electronic Commerce - Abiteboul, Vianu, Fordham, Yesha (1998)
(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