Stacked indexed views in microsoft SQL server

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2005, Pages 179-190

  DeHaan, David ^a   Larson, Per Ake ^b   Zhou, Jingren ^b  

^a UNIVERSITY OF WATERLOO   (Canada)

^b MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

MICROSOFT SQL SERVER; QUERY EXECUTION; SOURCE TABLES;

COMPUTER PROGRAMMING LANGUAGES; DATABASE SYSTEMS; PROJECT MANAGEMENT; QUERY LANGUAGES;

SERVERS;

EID: 29944443947     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1066157.1066179     Document Type: Conference Paper

References (21)

1. F. Afrati and R. Chirkova. Selecting and using views to compute aggregate queries. In Proc. ICDT, number 3363 in LNCS, pages 383-397, 2005.
2. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in sq1 databases. In Proc. VLDB, pages 496-505, 2000.
3. 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. VLDB, pages 659-664, 1998.
4. J. A. Blakeley, P.-Å. Larson, and F. W. Tompa. Efficiently updating materialized views. In Proc. SIGMOD, pages 61-71, 1986.
5. S. Chaudhuri, R. Krishnamurthy, S. Potamianos, and K. Shim. Optimizing queries with materialized views. In Proc. ICDE, pages 190-200, 1995.
6. C.-M. Chen and N. Roussopoulos. The implementation and performance evaluation of the ADMS query optimizer: Integrating query result caching and matching. In Proc. EDBT, volume 779 of LNCS, pages 323-336, 1994.
7. L. S. Colby, T. Griffin, L. Libkin, I. S. Mumick, and H. Trickey. Algorithms for deferred view maintenance. In Proc. SIGMOD, pages 469-480, 1996.
8. J. Goldstein and P.-A. Larson. Optimizing queries using materialized views: A practical, scalable solution. In Proc. SIGMOD, pages 331-342, 2001.
9. G. Graefe. The Cascades framework for query optimization. IEEE Data Eng. Bull., 18(3):19-29, 1995.
10. G. Graefe and W. J. McKenna. The Volcano optimizer generator: Extensibility and efficient search. In Proc. ICDE, pages 209-218, 1993.
11. A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proc. SIGMOD, pages 157-166, 1993.
12. V. Harinarayan, A. Rajaraman, and J. D. Ullman. Implementing data cubes efficiently. In Proc. SIGMOD, pages 205-216, 1996.
13. N. Kabra and D. J. DeWitt. OPT++: An object-oriented implementation for extensible database query optimization. VLDB J., 8(1):55-78, 1999.
14. P.-A. Larson and H. Z. Yang. Computing queries from derived relations. In Proc. VLDB, pages 259-269, 1985.
15. I. S. Mumick, D. Quass, and B. S. Mumick. Maintenance of data cubes and summary tables in a warehouse. In Proc. SIGMOD, pages 100-111, 1997.
16. A. Pellenkoft, C. Galindo-Legaria, and M. Kersten. The complexity of transformation-based join enumeration. In Proc. VLDB, pages 306-315, 1997.
17. K. Salem, K. Beyer, B. Lindsay, and R. Cochrane. How to roll a join: Asynchronous incremental view maintenance. In Proc. SIGMOD, pages 129-140, 2000.
18. O. G. Tsatalos, M. H. Solomon, and Y. E. loannidis. The GMAP: A versatile tool for physical data independence. VLDB J., 5(2):101-118, 1996.
19. W. P. Yan and P.-Å. Larson. Performing group-by before join. In Proc. ICDE, pages 89-100, 1994.
20. W. P. Yan and P.-Å. Larson. Eager aggregation and lazy aggregation. In Proc. VLDB, pages 345-357, 1995.
21. M. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, and M. Urata. Answering complex SQL queries using automatic summary tables. In Proc. SIGMOD, pages 105-116, 2000.