Automated design of multidimensional clustering tables for relational databases

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

Volumn , Issue , 2004, Pages 1170-1181

  Lightstone, Sam S ^a   Bhattacharjee, Bishwaranjan ^b  

^a IBM TORONTO LAB   (Canada)

^b IBM T J WATSON RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 33646469790     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-012088469-8.50102-9     Document Type: Chapter

References (21)

1. Transaction Processing Performance Council http://www.tpc.org/default.asp
2. DB2 Universal Database for Linux, UNIX and Windows. http://www.306.ibm.com/software/data/db2/udb/
3. S. Agrawal, S. Chaudhuri and V.R. Narasayya (2000) Automated selection of materialized views and indexes in SQL databases. Proc. VLDB Cairo, Egypt
4. B. Bhattacharjee, S. Padmanabhan, T. Malkemus, T. Lai, L. Cranston and M. Huras (2003) Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2. Proc. VLDB Berlin, Germany
5. S. Chaudhuri, E. Christensen, G. Graefe, V. Narasayya and M. Zwilling (June 1999) Self-Tuning Technology in Microsoft SQL Server. IEEE Data Eng. Bul. 22(2)
6. S. Chaudhuri and V. Narasayya (1998) Auto Admin ‘What-if’ Index Analysis Utility. Proc. SIGMOD Seattle, USA
7. S. Chaudhuri and V. Narasayya (1998) Microsoft Index Tuning Wizard for SQL Server 7.0. Proc. SIGMOD Seattle, USA
8. M.R. Frank, E.R. Omiecinski and S.B. Navathe (1992) Adaptive and Automated Index Selection in RDBMS. Proc. EDBT Vienna, Austria
9. P.J. Haas, J.F. Naughton, S. Seshadri and L. Stokes (1995) Sampling Based Estimation of the Number of Distinct Values of an Attribute. Proc. VLDB Zurich, Switzerland
10. P.J. Haas and L. Stokes (Dec, 1998) Estimating the number of classes in a finite population. JASA V. 93
11. S. Lightstone, D. Zilio, C. Zuzarte, G. Lohman, J. Rao and K. Cheung (2004) DB2 Design Advisor: More than just index selection. Orlando, USA: IDUG
12. J.H. Liou and S.B. Yao (1977) Multi-dimensional clustering for database organizations. Information Systems 2 187-198.
13. G. Lohman, G. Valentin, D. Zilio, M. Zuliani and A. Skelly (2000) DB2 Advisor: An optimizer smart enough to recommend its own indexes. Proc. ICDE San Diego, USA
14. V. Markl, F. Ramsak, R. Bayer, “Improving OLAP Performance by Multi-dimensional Hierarchical Clustering”, Proc. IDEAS'99, Montreal, Canada
15. S. Padmanabhan, B. Bhattacharjee, T. Malkemus, L. Cranston and M. Huras (2003) Multi-Dimensional Clustering: A New Data Layout Scheme in DB2. SIGMOD San Diego, USA
16. N. Pendse and R. Creeth. The OLAP Report http://www.olapreport.com/
17. J. Rao, S. Lightstone, G. Lohman, D. Zilio, A. Storm, C. Garcia-Arellano and S. Fadden (2004) DB2 Design Advisor: integrated automated physical database design. Proc. VLDB Toronto, Canada
18. J. Rao, C. Zhang, N. Megiddo and G. Lohman (2002) Automating physical database design in a parallel database. Proc. SIGMOD Madison, USA
19. B. Schiefer and G. Valentin (June 1999) DB2 Universal Database Performance Tuning. IEEE Data Eng. Bul 22(2)
20. T. Stöhr, H. Märtens and E. Rahm (2000) Multi-Dimensional Database Allocation for Parallel Data Warehouses. Proc. VLDB Cairo, Egypt
21. T. Stohr and E. Rahm (2001) WARLOCK: A Data Allocation Tool for Parallel Warehouses. Proc. VLDB Rome, Italy Software Demonstration