DB2 Design Advisor

Proceedings 2004 VLDB Conference: The 30th International Conference on Very Large Databases (VLDB)

Volumn , Issue , 2004, Pages 1087-1097

  Zilio, Daniel C ^a   Lightstone, Sam ^a   Storm, Adam ^a   Garcia Arellano, Christian ^a   Rao, Jun ^b   Lohman, Guy ^b   Fadden, Scott ^c  

^a IBM TORONTO LAB   (Canada)

^b IBM ALMADEN RESEARCH CENTER   (United States)

^c IBM   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 84882124087     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-012088469-8.50095-4     Document Type: Chapter

References (23)

1. S. Agrawal Sanjay, S. Chaudhuri Surajit and V.R. Narasayya Vivek R. (2000) Automated Selection of Materialized Views and Indexes in SQL Databases. Proceedings of 26th International Conference on Very Large Data Bases 496-505.
2. S. Agrawal Sanjay, V.R. Narasayya Vivek R. and B. Yang Beverly (2004) Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design. SIGMOD Conference
3. C.K. Baru Chaitanya K., G. Fecteau Gilles, A. Goyal Ambuj, H.-I. Hsiao Hui-I, A. Jhingran Anant, S. Padmanabhan Sriram and W.G. Wilson Walter G. (1995) An Overview of DB2 Parallel Edition. SIGMOD Conference 460-462.
4. S. Chaudhuri Surajit, A. Gupta Ashish and R Vivek (2002) Narasayya: Compressing SQL workloads. SIGMOD Conference 488-499.
5. S. Chaudhuri Surajit and V.R. Narasayya Vivek R. (1998) Microsoft Index Tuning Wizard for SQL Server 7.0. Proceedings ACM SIGMOD International Conference on Management of Data 553-554.
6. S. Chaudhuri Surajit and V.R. Narasayya Vivek R. (1998) AutoAdmin “What-Il” Index Analysis Utility. Proceedings of ACM SIGMOD Scattle
7. S. Finkelstein, M. Schikolnick and P. Tiberio (1988) Physical Database Design for Relational Databases. ACM Transactions of Database Systems 13(1), 91-128.
8. G. Graefe Goetz (1999) The Value of Merge-Join and Hash-Join in SQL Server. VLDB 250-253.
9. http://www.ibm.com/software/db2/
10. http://www.ibm.com/software/rational/
11. http://www.ibm.com/software/data/informix/redbrick/
12. S. Lightstone Sam and B. Bhattacharjee Bishwaranjan (2004) Automated design of Multi-dimensional Clustering tables for relational databases. VLDB
13. G.M. Lohman Guy M. and S. Lightstone Sam (2002) SMART: Making DB2 (More) Autonomic. VLDB 877-879.
14. http://www.oracle.com/
15. S. Padmanabhan Sriram, B. Bhattacharjee Bishwaranjan, T. Malkemus Timothy, L. Cranston Leslie and M. Huras Matthew (2003) Multi-Dimensional Clustering: A New Data Layout Scheme in DB2. SIGMOD Conference 637-641.
16. Query Patroller http://www.ibm.com/software/data/db2/querypatroller/
17. J. Rao Jun, C. Zhang Chun, N. Megiddo Nimrod and G.M. Lohman Guy M. (2002) Automating physical database design in a parallel database. SIGMOD Conference 558-569.
18. http://researchweb.watson.ibm.com/autonomic/manifesto
19. http://www.sap.com/
20. TPC-H benchmark. http://www.tpc.org/
21. G. Valentin Gary, M. Zuliani Michael, D.C. Zilio Daniel C., G. Lohman Guy and A. Skelley Alan (2000) DB2 Advisor: An optimizer smart enough to recommend its own indexes. Proceedings of the ICDE Conference 101-110.
22. M. Zaharioudakis Markos, R. Cochrane Roberta, G. Lapis George, H. Pirahesh Hamid and M. Urata Monica (2000) Answering Complex SQL Queries Using Automatic Summary Tables. SIGMOD Conference 105-116.
23. D.C. Zilio Daniel C., et al. (2004) Recommending Materialized Views and Indexes with IBM's DB2 Design Advisor. International Conference on Autonomic Computing