A benchmark for online index selection

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2009, Pages 1701-1708

  Schnaitter, Karl ^a   Polyzotis, Neoklis ^a  

^a University of California   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CONCRETE CONTRIBUTION; INDEX SELECTION; ONLINE TUNING ALGORITHM; PHYSICAL DESIGN TUNING;

DATABASE SYSTEMS;

TUNING;

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

References (14)

1. N. Bruno and S. Chaudhuri, "An online approach to physical design tuning," in ICDE '07: Proceedings of the 23rd International Conference on Data Engineering, 2007.
2. K.-U. Sattler, M. Lühring, I. Geist, and E. Schallehn, "Autonomous management of soft indexes," in SMDB '07: Proceedings of the 2nd International Workshop on Self-Managing Database Systems, 2007.
3. K. Schnaitter, S. Abiteboul, T. Milo, and N. Polyzotis, "On-line index selection for shifting workloads," in 2nd International Workshop on Self-Managing Database Systems (SMDB), 2007.
4. S. Agrawal, S. Chaudhuri, and V.Narasayya, "Automated Selection of Materialized Views and Indexes for SQL Databases," in International Conference on Very Large Databases, 2000, pp. 496 505.
5. N. Bruno and S. Chaudhuri, "Automatic Physical Database Tuning: A Relaxation-based Approach," in ACM SIGMOD International Conference on Management of Data, 2005.
6. S. Finkelstein, M. Schkolnick, and P. Tiberio, "Physical database design for relational databases," ACM Trans. Database Syst., vol. 13, no. 1, pp. 91-128, 1988.
7. A. Borodin, N. Linial, and M. E. Saks, "An optimal on-line algorithm for metrical task system," Journal of the ACM, vol. 39, no. 4, pp. 745-763, 1992.
8. W. R. Burley and S. Irani, "On algorithm design for metrical task systems," Algorithmica, vol. 18, no. 4, pp. 461-485, 1997.
9. S. Chaudhuri and V. Narasayya, "Autoadmin "what-if" index analysis utility," SIGMOD Rec., vol. 27, no. 2, pp. 367-378, 1998.
10. M. Hammer and A. Chan, "Index selection in a self-adaptive data base management system," in ACM SIGMOD International Conference on Management of Data, 1976, pp. 1-8.
11. S. Chaudhuri and V. R. Narasayya, "An efficient cost-driven index selection tool for microsoft sql server," in International Conference on Very Large Databases, 1997, pp. 146-155.
12. D. C. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden, "Db2 design advisor: integrated automatic physical database design," in International Conference on Very Large Databases, 2004, pp. 1087-1097.
13. N. Bruno, "A critical look at the tab benchmark for physical design tools," SIGMOD Rec., vol. 36, no. 4, pp. 7-12, 2007.
14. M. P. Consens, D. Barbosa, A. Teisanu, and L. Mignet, "Goals and benchmarks for autonomic configuration recommenders," in SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data, 2005, pp. 239-250.