Materialized view selection and maintenance using multi-query optimization

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 30, Issue 2, 2001, Pages 307-318

  Mistry, Hoshi ^a   Roy, Prasan ^a   Sudarshan, S ^a   Ramamritham, Krithi ^a,b  

^a INDIAN INSTITUTE OF TECHNOLOGY BOMBAY   (India)

^b UNIVERSITY OF MASSACHUSETTS   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 0038968640     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/376284.375703     Document Type: Article

References (15)

1. AGRAWAL, S., CHAUDHURI, S., AND NARASAYYA, V. R. Automated selection of materialized views and indexes in SQL databases. In Intl. Conf. Very Large Databases (2000), pp. 496-505.
2. BLAKELEY, J. A., LARSON, P.-Å., AND TOMPA, F. W. Efficiently updating materialized views. In ACM SIGMOD Intl. Conf. on Management of Data (1986).
3. BOBROWSKI, S. Using materialized views to speed up queries. Oracle Magazine (Sept. 1999).
4. COLBY, L., COLE, R. L., HASLAM, E., JAZAYERI, N., JOHNSON, G., MCKENNA, W. J., SCHUMACHER, L., AND WILHITE, D. Redbrick Vista: Aggregate computation and management. In Intl. Conf. on Data Engineering (1998).
5. GRAEFE, G., AND MCKENNA, W. J. The Volcano Optimizer Generator: Extensibility and Efficient Search. In Intl. Conf. on Data Engineering (1993).
6. GRIFFIN, T., AND LIBKIN, L. Incremental maintenance of views with duplicates. In ACM SIGMOD Intl. Conf. on Management of Data (1995).
7. GUPTA, A., AND MUMICK, I. S. Maintenance of materialized views : Problems, techniques, and applications. IEEE Data Engineering Bulletin 18, 2 (June 1995).
8. GUPTA, H. Selection of views to materialize in a data warehouse. In Intl. Conf. on Database Theory (1997).
9. HARINARAYAN, V., RAJARAMAN, A., AND ULLMAN, J. Implementing data cubes efficiently. In ACM SIGMOD Intl. Conf. on Management of Data (Montreal, Canada, June 1996).
10. QUASS, D., GUPTA, A., MUMICK, I., AND WIDOM, J. Making views self-maintainable for data warehousing. In Intl. Conf. on Parallel and Distributed Information Systems (1996).
11. ROSS, K., SRIVASTAVA, D., AND SUDARSHAN, S. Materialized view maintenance and integrity constraint checking: Trading space for time. In ACM SIGMOD Intl. Conf. on Management of Data (1996).
12. ROUSSOPOLOUS, N. View indexing in relational databases. ACM Trans. on Database Systems 7, 2 (1982), 258-290.
13. ROY, P., SESHADRI, S., SUDARSHAN, S., AND BHOBHE, S. Efficient and extensible algorithms for multi-query optimization. In ACM SIGMOD Intl. Conf. on Management of Data (2000).
14. SELLIS, T. K. Multiple query optimization. ACM Transactions on Database Systems 13, 1 (1988).
15. VISTA, D. Integration of incremental view maintenance into query optimizers. In Intl. Conf. on Extending Database Technology (EDBT) (1998).