Load balancing for multi-tiered database systems through autonomic placement of materialized views

Proceedings - International Conference on Data Engineering

Volumn 2006, Issue , 2006, Pages 102-

  Li, Wen Syan ^a   Zilio, Daniel C ^b   Batra, Vishal S ^c   Subramanian, Mahadevan ^a   Zuzarte, Calisto ^b   Narang, Inderpal ^a  

^a IBM ALMADEN RESEARCH CENTER   (United States)

^b IBM CANADA LTD   (Canada)

^c IBM INDIA RESEARCH LAB   (India)

Author keywords

[No Author keywords available]

Indexed keywords

DATA PLACEMENT ADVISOR (DPA); DATABASE QUERY; LOAD BALANCING STRATEGIES; MULTI-TIERED DATABASE SYSTEMS;

DATA REDUCTION; INFORMATION ANALYSIS; QUERY LANGUAGES; SERVERS;

DATABASE SYSTEMS;

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

References (18)

1. V. Josifovski, P. Schwarz, L. Haas, and E. Lin. Garlic: A New Flavor of Federated Query Processing for DB2. In Proceedings of the ACM SIGMOD International Conference on Management of Data, 2002.
2. Daniel C. Zilio, Calisto Zuzarte, Sam Lightstone, Wenbin Ma, Roberta Cochrane Guy M. Lohman, 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 Proceedings of the International Conference on Autonomie Computing, 2004.
3. Daniel C. Zilio, Jun Rao, Sam Lightstone, Guy M. Lohman, Adam Storm, Christian Garcia-Arellano, and Scott Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In Proceedings of the International Conference on Very Large Data Bases, 2004.
4. W. Lehner, B. Cochrane, H. Pirahesh, and M. Zaharioudakis. Applying Mass Query Optimization to Speed up Automatic Summary Table Refresh. In Proceedings of the International Conference on Data Engineering, 2001.
5. Wen-Syan Li, Vishal S. Batra, Vijayshankar Raman, Wei Han, Kasim Selcuk Candan, and Inderpal Narang. Load and Network Aware Query Routing for Information Integration. In Proceedings of the International Conference on Data Engineering, 2005.
6. TPC-H Benchmark, http://www.tpc.org/.
7. Red Brick, http://www.informix.com/informix/solutions/dw/redbrick/vista/.
8. Oracle Corp. http://www.oracle.com/.
9. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated Selection of Materialized Views and Indexes for SQL Database. In Proceedings of the International Conference on Very Large Data Bases, 2000.
10. K. Amiri, R. Tewari S. Park, and S. Padmanabhan. A Self-managing Data Cache for Edge-of-network Web Applications . In Proceedings of the International Conference Information and Knowledge Management, 2002.
11. K. Amiri, S. Park, R. Tewari, and S. Padmanabhan. DBProxy: A Dynamic Data Cache for Web Applications . In Proceedings of the International Conference on Data Engineering, 2003.
12. The TimesTen Team. Mid-tier Caching: the TimesTen Approach. In Proceedings of 2002 ACM SIGMOD Conference, Madison, Wisconsin, USA, June 2002.
13. Qiong Luo, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, Honguk Woo, Bruce G. Lindsay, and Jeffrey F. Naughton. Middle-tier Database Caching for e-Business. In Proceedings of 2002 ACM SIGMOD Conference, Madison, Wisconsin, USA, June 2002.
14. Mehmet Altinel, Christof Bornhövd, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, and Berthold Reinwald. Cache Tables: Paving the Way for an Adaptive Database Cache. In Proceedings of the 2003 VLDB Conference, Berlin, Germany, September 2003.
15. Wen-Syan Li, Oliver Po, Wang-Pin Hsiung, K. Selçuk Candan, Divyakant Agrawal, Yusuf Akca, and Kunihiro Taniguchi. CachePortal II: Acceleration of Very Large Scale Data Center-Hosted Database-driven Web Applications. In Proceedings of the 2003 VLDB Conference, Berlin, Germany, September 2003.
16. Paul Larson, Jonathan Goldstein, and Jingren Zhou. MTCache: Transparent Mid-Tier Database Caching in SQL Server. In Proceedings of the International Conference on Data Engineering, 2004.
17. Jonathan Goldstein and Paul Larson. Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. In Proceedings of the ACM SIGMOD International Conference on Management of Data, 2001.
18. Hongfei Guo, Paul Larson Raghu Ramakrishnan, and Jonathan Goldstein. Relaxed Currency and Consistency: How to Say "Good Enough". In Proceedings of the ACM SIGMOD International Conference on Management of Data, 2004.