Dynamic materialized views

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 526-535

  Zhou, Jingren ^a   Larson, Per Åke ^a   Goldstein, Jonathan ^a   Ding, Luping ^b  

^a MICROSOFT RESEARCH   (United States)

^b WORCESTER POLYTECHNIC INSTITUTE   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER SIMULATION; DATA REDUCTION; QUERY LANGUAGES; SERVERS;

CONTROL TABLES; DYNAMIC MATERIALIZED VIEWS; FEEDBACK LOOP; FLEXIBLE MATERIALIZATION STRATEGY; MICROSOFT SQL SERVER;

BUFFER STORAGE;

EID: 34548793441     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2007.367898     Document Type: Conference Paper

References (24)

1. M. Altinel, C. Bornhovd, S. Krishnamurthy, C. Mohan, H. Pirahesh, and B. Reinwald. Cache tables: Paving the way for an adaptive database cache. In Proc. of VLDB Conference, 2003.
2. R. G. Bello, K. Dias, A. Downing, J. J. Feenan, J. L. Finnerty, W. D. Norcott, H. Sun, A. Witkowski, and M. Ziauddin. Materialized views in Oracle. In Proc. of VLDB Conference, 1998.
3. J. A. Blakeley, P. Larson, and F. W. Tompa. Efficiently updating materialized views. In Proc. of SIGMOD Conference, 1986.
4. S. Chaudhuri, R. Krishnamurthy, S. Potamianos, and K. Shim. Optimizing queries with materialized views. In Proc. of ICDE Conference, 1995.
5. J. Goldstein and P. Larson. Optimizing queries using materialized views: A practical, scalable solution. In Proc. of SIGMOD Conference, 2001.
6. G. Graefe and K. Ward. Dynamic query evaluation plans. In Proc. of SIGMOD Conference, 1989.
7. T. Griffin and L. Libkin. Incremental maintenance of views with duplicates, In Proc. of SIGMOD Conference, 1995.
8. H. Guo, P. Larson, and R. Ramakrishnan. Caching with 'good enough' currency, consistency, and completeness. In Proc. of VLDB Conference, 2005.
9. H. Guo, P. Larson, R. Ramakrishnan, and J. Goldstein. Relaxed currency and consistency: how to say "good enough" in sql. In Proc. of SIGMOD Conference, 2004.
10. A. Gupta, I. S. Mumick, and K. A. Ross. Adapting materialized views after redefinitions. In Proc. of SIGMOD Conference, 1995.
11. A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proc. of SIGMOD, 1993.
12. A. Y. Halevy. Answering queries using views: A survey. The VLDB Journal, 10(4), 2001.
13. IBM. Red Brick Warehouse 6.3, Peformance Guide, 2004.
14. T. Johnson and D. Shasha. 2Q: A low overhead high performance buffer management replacement algorithm. In Proc. of VLDB Conference, 1994.
15. P. Larson, J. Goldstein, H. Guo, and J. Zhou. Mtcache: Mid-tier database caching for sql server. Data Engineering Bulletin, 27(2), 2004.
16. P. Larson, J. Goldstein, and J. Zhou. MTCache: Mid-tier database cache in SQL server. In Proc. of ICDE Conference, 2004.
17. P. Larson and H. Z. Yang. Computing queries from derived relations. In Proc. of VLDB Conference, 1985.
18. I. S. Mumick, D. Quass, and B. S. Mumick. Maintenance of data cubes and summary tables in a warehouse. In Proc. cf SIGMOD Conference, 1997.
19. P. Seshadri and A. Swami. Generalized partial indexes. In Proc. of ICDE Conference, 1995.
20. D. Srivastava, S. Dar, H. V. Jagadish, and A. Y. Levy. Answering queries with aggregation using views. In Proc. of VLDB Conference, 1996.
21. M. Stonebraker. The case for partial indexes. SIGMOD Record, 18(4), 1989.
22. H. Z. Yang and P. Larson. Query transformation for psj-queries. In Proc. of VLDB Conference, 1987.
23. M. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, and M. Urata. Answering complex sql queries using automatic summary tables. In Proc. cf SIGMOD Conference, 2000.
24. J. Zhou, P.-Å. Larson, and J. Goldstein. Partially materialized views. Technical Report MSR-TR-2005-77, Microsoft Research, 2005.