Optimizing refresh of a set of materialized views

VLDB 2005 - Proceedings of 31st International Conference on Very Large Data Bases

Volumn 3, Issue , 2005, Pages 1043-1054

  Folkert, Nathan ^a   Gupta, Abhinav ^a   Witkowski, Andrew ^a   Subramanian, Sankar ^a   Bellamkonda, Srikanth ^a   Shankar, Shrikanth ^a   Bozkaya, Tolga ^a   Sheng, Lei ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

BASE TABLES; FUNCTIONAL DEPENDENCIES; MATERIALIZED VIEWS (MV); OLAP;

DATA WAREHOUSES; OPTIMIZATION; SERVERS;

DATABASE SYSTEMS;

EID: 33745630709     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (21)

1. APB Benchmark Specifications. http://www.olapcouncil.org/research/ APB1R2_spec.pdf
2. S. Agarwal, R. Agrawal, P.M. Deshpande, A. Gupta, J.F. Naughton, R. Ramakrishnan, and S. Sarawagi, "On the computation of multidimensional aggregates", Proceedings of 22nd Conference on VLDB, Mumbai (Bombay), India.
3. R. G. Bello, et al., "Materialized Views In Oracle", Proceedings of 24th Conference on VLDB, New York, USA.
4. J. A. Blakeley, P. Larson, and F. W. Tompa, "Efficiently Updating Materialized Views", Proceedings of ACM SIGMOD 1986, Washington D.C., USA, 1986.
5. D.Chatziantoniou and K.Ross, "Querying Multiple features of Groups in Relational Databases", Proceedings of 22nd VLDB Conference, Mumbai, India.
6. S. Chaudhuri, R. Krishnamurthy, S. Potomianos, and K. Shim, "Optimizing queries with materialized views", Proceedings of 11th Conference on Data Engineeing, Taipei, Taiwan, 1995.
7. S. Cohen, W. Nutt, and A. Serebrenik, "Rewriting aggregate queries using views", Proceedings of 18th ACM PODS Symposium, Philadelphia, USA, 1999.
8. A. Gupta, I.S. Mumick, and V. S. Subrahmanian, "Maintaining views incrementally", Proceedings of the ACM SIGMOD Conference 1993, Washington D.C., USA, 1993.
9. Jim Gray, Adam Bosworth, Andrew Layman, Hamid Pirahesh, "Data Cube: A Relational aggregation operator generalizing group-by, crosstab, and sub-total", Proceedings of 12th Conference on Data Engineering, New Orleans, Louisiana, USA.
10. T. Griffin and L. Libkin, "Incremental maintenance of views with duplicates", Proceedings of ACM SIGMOD 1995, San Jose, USA, 1995.
11. W. J. Labio, J. Yang, Y. Cui, H. Garcia-Molina, and J. Widom, "Performance issues in incremental warehouse Maintenance", Proceedings of 26th Conference on VLDB, Cairo, Egypt, 2000.
12. A. Levy, A. Rajaraman, and J. J. Ordille, "Answering queries using views", Proceedings of 14th ACM PODS Symposium, San Jose, USA, 1995.
13. I. S. Mumick, D. Quass, and B. S. Mumick, "Maintenance of data cubes and summary tables in a warehouse", Proceedings of ACM SIGMOD 1997, Tucson, USA, 1997.
14. Oracle 9i Datawarehouse manual. Multi-Table Insert
15. R. Pottinger, A. Levy, "A scalable algorithm for answering queries using views", Proceedings of 26th Conference on VLDB, Cairo, Egypt, 2000.
16. D. Srivastava, S. Rar, H. V. Jagadish and A. Levy, "Answering SQL queries using materialized views", Proceedings of the 26th Conference on VLDB, Mumbai, India, 1996.
17. R. Tarjan, "Dept-first search and linear graph algorithms," SIAM J. Computing, 1997.
18. A.Witkowski, et al., "Spreadsheets in RDBMS for OLAP", Proceedings of ACM SIGMOD 2003, San Diego, USA, 2003.
19. M. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, and M. Urata, "Answering complex SQL queries using automatic summary tables", Proceedings of ACMSIGMOD 2000, Dallas, USA, 2000.
20. F. Zemke "Rank, Moving and reporting functions for OLAP" 99/01/22 proposal for ANSI-NCTS.
21. Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom, "View maintenance in a warehouse environment", Proceedings of ACM SIGMOD 1995, San Jose, USA, 1995.