See this document in CiteSeerX!

On the Content of Materialized Aggregate Views (2000)  (Make Corrections)  (9 citations)
Stephane Grumbach, Leonardo Tininini
Proceedings of the Nineteenth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2000



  Home/Search   Context   Related

 
View or download:
inria.fr/INRIA/Pro...soReport178.ps.gz
Cached:  PS.gz  PS  PDF   Image  Update  Help

From:  cosmos.inria.fr...=byyear&query=0 (more)
(Enter author homepages)

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