Dynamic materialization of query views for data warehouse workloads

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2008, Pages 436-445

  Phan, Thomas ^a   Li, Wen Syan ^b  

^a YAHOO INC   (United States)

^b IBM ALMADEN RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ADMINISTRATIVE DATA PROCESSING; DATA WAREHOUSES; DATABASE SYSTEMS; DIESEL ENGINES; DISKS (STRUCTURAL COMPONENTS); GENETIC ALGORITHMS; HEURISTIC METHODS; HEURISTIC PROGRAMMING; MAINTENANCE; MATHEMATICAL TRANSFORMATIONS; TECHNOLOGY;

BASE TABLE; DATA ENGINEERING; DATABASE QUERYING; DYNAMIC MANAGEMENT; INTERNATIONAL CONFERENCES; MANAGEMENT SCHEME; MATERIALIZED QUERY TABLE; MATERIALIZED VIEWS; ON-DEMAND; PRECOMPUTED DATA; REAL-WORLD; RESEARCH EFFORTS; SOLUTION SPACES; VIEW MAINTENANCE;

ELECTRON TUNNELING;

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

References (25)

1. P. Larson and H. Yang. Computing Queries From Derived Relations. In Proc. of VLDB, 1985.
2. S. Chaudhuri, R. Krishnamurthy, S. Potamianos, and K. Shim, Optimizing Queries with Materialized Views. In Proc. of ICDE, 1995.
3. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated Selection of Materialized Views and Indexes for SQL Database. In Proc. of VLDB, 2000.
4. D. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. Lohman, R. Cochrane, H. Pirahesh, L. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending Materialized Views and Indexes with IBM DB 2 Design Advisor. In Proc. of the Intl. Conf. on Autonomic Computing, 2004.
5. S. Agrawal, E. Chu, and V. Narasayya. Automatic Physical Design Tuning: Workload as a Sequence, In Proc. of SIGMOD, 2006.
6. W. Lehner, B. Cochrane, H. Pirahesh, and M. Zaharioudakis, Applying Mass Query Optimization to Speed up Automatic Summary Table Refresh. In Proc. of ICDE, 2001.
7. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, , and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In Proc. of VLDB, 2004.
8. D. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In Proc. of VLDB, 2004.
9. B. Dagerville, D. Das, K. Dias, K. Yagoub, M. Zait, , and M. Ziauddin. Automatic SQL Tuning in Oracle 10g. In Proc. of VLDB, 2004.
10. J. Holland, Adaptation in Natural and Artificial Systems: An Introductory Analysis with Applications to Biology, Control, and Artificial Intelligence. MIT Press, 1992.
11. Kotidis Y and N. Roussopoulos. DynaMat: A Dynamic View Management System for Data Warehouses. In Proc. of SIGMOD, 1999.
12. P. Larson, J. Goldstein, and J. Zhou. MTCache: Transparent Mid-Tier Database Caching in SQL Server. In Proc. of ICDE, 2004.
13. D. Goldberg, Genetic Algorithms in Search, Optimization and Machine Learning. Kluwer Academic Publishers, 1989.
14. L. Davis. Job Shop Scheduling with Genetic Algorithms. In Proc. of the Int. Conf. on Genetic Algorithms, 1985.
15. E. Rundensteiner, A. Koeller, and X. Zhang. Maintaining data warehouses over changing information sources. Communications of the ACM, 43(6): 57-62, 2000.
16. L. Colby, T. Griffin, L. Libkin, I. Mumick, and H. Trickey. Algorithms for Deferred View Maintenance. In Proc. of SIGMOD, 1996.
17. D. Quass, A. Gupta, I. Mumick, and J. Widom. Making Views Self-Maintainable for Data Warehousing. IR Proc. of IPDIS, December 1996.
18. D. Agrawal, A. El Abbadi, A. Singh, and T. Yurek. Efficient View Maintenance in Data Warehouses, In Proc. of the ACM Int. Conf. on Management of Data, 1997.
19. K. Salem, K. S. Beyer, R. Cochrane, and B. G. Lindsay, How to roll a join: Asynchronous Incremental View Maintenance. In Proc. of SIGMOD, 2000.
20. G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. In Proc. of ICDE, 2000.
21. S. Adali, K. S. Candan, Y. Papakonstantinou, and V. S. Subrahmaninan, Query Caching and Optimization in Distributed Mediator Systems. In Proc. of SIGMOD, 1996.
22. J. Shim, P. Scheuermann, and R. Vingralek. Dynamic Caching of Query Results for Decision Support Systems. In Proceedings of the 1999 Symposium on Statistical and Scientific Data Base Management, pages 254-263, 1999.
23. Q. Luo, J. F. Naughton, R. Krishnamurthy, P. Cao, and Y. Li. Active Query Caching for Database Web Servers. In Proc. of the WebDB, 2000.
24. C. Chen and N. Roussopoulos. The Implementation and Performance Evaluation of the ADMS Query Optimizer: Integrating Query Result Caching and Matching. In Proc. of EDBT, 1994.
25. J. Zhou, P. Larson, J. Goldstein, and L. Ding, Dynamic Materialized Views. In Proc. of ICDE, 2007.