Lazy maintenance of materialized views

33rd International Conference on Very Large Data Bases, VLDB 2007 - Conference Proceedings

Volumn , Issue , 2007, Pages 231-242

  Zhou, Jingren ^a   Larson, Per Ake ^a   Elmongui, Hicham G ^b  

^a MICROSOFT RESEARCH   (United States)

^b PURDUE UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COSTS; QUERY PROCESSING; WINDOWS OPERATING SYSTEM;

BASE TABLE; MAINTENANCE COST; MAINTENANCE OPERATIONS; MATERIALIZED VIEW; MICROSOFT SQL SERVER; PROTOTYPE IMPLEMENTATIONS; SYSTEM LOADS; VIEW MAINTENANCE;

MAINTENANCE;

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

References (19)

1. D. Agrawal, A. E. Abbadi, A. Singh, and T. Yurek. Efficient view maintenance at data warehouses. In Proceedings of SIGMOD Conference, 1997.
2. R. G. Bello, K. Dias, A. Downing, J. J. F. Jr., J. L. Finnerty, W. D. Norcott, H. Sun, A. Witkowski, and M. Ziauddin. Materialized views in oracle. In Proceedings of VLDB Conference, 1998.
3. H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. A critique of ansi sql isolation levels. In Proceedings of SIGMOD Conference, 1995.
4. J. A. Blakeley, P.-Å. Larson, and F. W. Tompa. Efficiently updating materialized views. In Proceedings of SIGMOD Conference, 1986.
5. S. Chen and E. A. Rundensteiner. Gpivot: Efficient incremental maintenance of complex rolap views. In Proceedings of ICDE Conference, 2005.
6. L. S. Colby, T. Griffin, L. Libkin, I. S. Mumick, and H. Trickey. Algorithms for deferred view maintenance. In Proceedings of SIGMOD Conference, 1996.
7. C. A. Galindo-Legaria, S. Stefani, and F. Waas. Query processing for sql updates. In Proceedings of SIGMOD Conference, 2004.
8. J. Goldstein and P.-Å. Larson. Optimizing queries using materialized views: A practical, scalable solution. In Proceedings of SIGMOD Conference, 2001.
9. T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In Proceedins of SIGMOD Conference, 1995.
10. A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proceedings of SIGMOD Conference, 1993.
11. P.-Å. Larson and J. Zhou. Efficient maintenance of materialized outer-join views. In Proceedings of ICDE Conference, 2007.
12. W. Lehner, R. Sidle, H. Pirahesh, and R. Cochrane. Maintenance of automatic summary tables. In Proceedings of SIGMOD Conference, 2000.
13. I. S. Mumick, D. Quass, and B. S. Mumick. Maintenance of data cubes and summary tables in a warehouse. In Proceedings of SIGMOD Conference, 1997.
14. D. Quass and J. Widom. On-line warehouse view maintenance. In Proc. of SIGMOD Conference, 1997.
15. K. Salem, K. Beyer, B. Lindsay, and R. Cochrane. How to roll a join: Asynchronous incremental view maintenance. In Proc. of SIGMOD Conference, 2000.
16. M. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, and M. Urata. Answering complex sql queries using automatic summary tables. In Proceedings of SIGMOD Conference, 2000.
17. J. Zhou, P.-Å. Larson, J.-C. Freytag, and W. Lehner. Efficient exploitation of similar subexpressions for query processing. In Proceedings of SIGMOD Conference, 2007.
18. Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In Proc. of SIGMOD Conference, 1995.
19. Y. Zhuge, H. Garcia-Molina, and J. L. Wiener. The strobe algorithms for multi-source warehouse consistency. In Proceedings of Conference on Parallel and Distributed Information Systems, 1996.