Preprocessing for fast refreshing materialized views in DB2

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 4081 LNCS, Issue , 2006, Pages 55-64

  Xu, Wugang ^a   Zuzarte, Calisto ^b   Theodoratos, Dimitri ^a   Wenbin, Ma ^b  

^a NEW JERSEY INSTITUTE OF TECHNOLOGY   (United States)

^b IBM CANADA LTD   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER SCIENCE; COMPUTER SIMULATION; DATA REDUCTION; OPTIMIZATION; QUERY LANGUAGES;

MATERIALIZED VIEWS (MV); QUERY MATCHING; QUERY SHARING;

DATA WAREHOUSES;

EID: 33751366119     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/11823728_6     Document Type: Conference Paper

References (10)

1. TPC (Transaction Processing Performance Council) Web Site: http://www.tpc.org.
2. Nathan Folkert, Abhinav Gupta, Andrew Witkowski, Sankar Subramanian, Srikanth Bellamkonda, Shrikanth Shankar, Tolga Bozkaya, and Lei Sheng. Optimizing Refresh of a Set of Materialized Views. In Proceedings of the 31st International Conference on Very Large Data Bases, Trondheim, Norway, August 30 - September 2, 2005, pages 1043-1054, 2005.
3. Alon Y. Halevy. Answering Queries Using Views: A survey. VLDB J., 10(4):270-294, 2001.
4. Wolfgang Lehner, Roberta Cochrane, Hamid Pirahesh, and Markos Zaharioudakis. fAST Refresh Using Mass Query Optimization. In Proceedings of the 17th International Conference on Data Engineering, April 2-6, 2001, Heidelberg, Germany, pages 391-398, 2001.
5. Wolfgang Lehner, Richard Sidle, Hamid Pirahesh, and Roberta Cochrane. Maintenance of automatic summary tables. In Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, May 16-18, 2000, Dallas, Texas, USA., pages 512-513, 2000.
6. Timos K. Sellis. Multiple-Query Optimization. ACM Trans. Database Syst., 13(1):23-52, 1988.
7. Dimitri Theodoratos and Mokrane Bouzeghoub. A General Framework for the View Selection Problem for Data Warehouse Design and Evolution. In DOLAP 2000, ACM Seventh International Workshop on Data Warehousing and OLAP, Washington, DC, USA, November 10, 2000, Proceedings, pages 1-8, 2000.
8. Dimitri Theodoratos and Wugang Xu. Constructing Search Spaces for Materialized View Selection. In DOLAP 2004, ACM Seventh International Workshop on Data Warehousing and OLAP, Washington, DC, USA, November 12-13, 2004, Proceedings, pages 112-121, 2004.
9. Markos Zaharioudakis, Roberta Cochrane, George Lapis, Hamid Pirahesh, and Monica Urata. Answering complex sql queries using automatic summary tables. In Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, May 16-18, 2000, Dallas, Texas, USA., pages 105-116, 2000.
10. Daniel C. Zilio, Calisto Zuzarte, Sam Lightstone, Wenbin Ma, Guy M. Lohman, Roberta Cochrane, Hamid Pirahesh, Latha S. Colby, Jarek Gryz, Eric Alton, Dongming Liang, and Gary Valentin. Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. In 1st International Conference on Autonomic Computing (ICAC 2004), 17-19 May 2004, New York, NY, USA, pages 180-188, 2004.