Exploiting correlation and parallelism of materialized-view recommendation for distributed data warehouses

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 276-285

  Jiang, Haifeng ^a   Gao, Dengfeng ^a   Li, Wen Syan ^a  

^a IBM ALMADEN RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPETITIVE INTELLIGENCE; COMPUTATIONAL COMPLEXITY; CORRELATION METHODS; PARALLEL PROCESSING SYSTEMS; SCHEDULING;

DATA LOADING; DATA PLACEMENT; DISTRIBUTED DATA WAREHOUSES; JOB SCHEDULING;

DATA WAREHOUSES;

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

References (13)

1. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated Selection of Materialized Views and Indexes for SQL Database. In VLDB, 2000.
2. M. Altinel, C. Bornhövd, S. Krishnamurthy, C. Mohan, H. Pirahesh, and B. Reinwald. Cache Tables: Paving the Way for an Adaptive Database Cache. In VLDB, 2003.
3. K. Arairi, S. Park, R. Tewari, and S. Padmanabhan. DBProxy: A Dynamic Data Cache for Web Applications. In ICDE, 2003.
4. J. Goldstein and P. Larson. Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. In SIGMOD, 2001.
5. H. Guo, P. L. R. Ramakrishnan, and J. Goldstein. Relaxed Currency and Consistency: How to Say "Good Enough". In SIGMOD, 2004.
6. V. Josifovski, P. Schwarz, L. Haas, and E. Lin. Garlic: A New Flavor of Federated Query Processing for DB2. In SIGMOD, 2002.
7. P. Larson, J. Goldstein, and J. Zhou. MTCache: Transparent Mid-Tier Database Caching in SQL Server. In ICDE, 2004.
8. W.-S. Li, D. C. Zilio, V. S. Batra, M. Subramanian, C. Zuzarte, and I. Narang. Load balancing for multitiered database systems through autonomic placement of materialized views. In ICDE, 2006.
9. Oracle Corp. http://www.oracle.com/.
10. Redbrick, http://www.informix.com/informix/solutions /dw/redbrick/vista/.
11. The TimesTen Team. Mid-tier Caching: the TimesTen Approach. In SIGMOD, 2002.
12. D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In VLDB, 2004.
13. D. C. Zilio, C. Zuzarte, S. Lightstone, W. Ma, R. C. Guy M. Lohman, H. Pirahesh, L. S. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. In Proceedings of the International Conference on Autonomie Computing, 2004.