Storage workload estimation for database management systems

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2007, Pages 377-388

  Ozmen, Oguzhan ^a   Salem, Kenneth ^a   Uysal, Mustafa ^b   Attar, M Hossein Sheikh ^a  

^a UNIVERSITY OF WATERLOO   (Canada)

^b HEWLETT PACKARD LABORATORIES   (United States)

Author keywords

Database management systems; Storage configuration; Storage management; Workload characterization

Indexed keywords

COMPUTER AIDED SOFTWARE ENGINEERING; COMPUTER NETWORKS; DATA ACQUISITION; DATA STORAGE EQUIPMENT; PROBLEM SOLVING;

STORAGE CONFIGURATION; STORAGE MANAGEMENT; STORAGE RESOURCES; WORKLOAD CHARACTERIZATION;

DATABASE SYSTEMS;

EID: 35448993358     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1247480.1247523     Document Type: Conference Paper

References (20)

1. S. Agrawal, S. Chaudhuri, A. Das, and V. Narasayya. Automating layout of relational databases. In International Conference on Data Engineering (ICDE'OS), pages 607-618, 2003.
2. S. Agrawal, S. Chaudhuri, L. Kollor, A. P. Marathe, V. R. Narasayya, and M. Syamala. Database tuning advisor for Microsoft SQL server. In International Conference on Very Large Data Bases (VLDB '04), pages 1110-1121, 2004.
3. E. Anderson, M. Hobbs, K. Keeton, S. Spence, M. Uysal, and A. Veitch. Hippodrome: running circles around storage administration. In Conf. on File and Storage Technology, pages 175-188, Jan. 2002.
4. E. Anderson, S. Spence, R. Swaminathan, M. Kallahalla, and Q. Wang. Quickly finding near-optimal storage designs. ACM Transactions on Computer Systems, 23(4):337-374, 2005.
5. S. Chaudhuri and V. R. Narasayya. Autoadmin 'what-if index analysis utility. In Proc. ACM SIGMOD International Conference on Management of Data, pages 367-378, 1998.
6. I. Foster and S. Tuecke. Describing the elephant: The different faces of IT as service. Queue, 3(6):26-29, 2005.
7. T. Johnson and D. Shasha. 2Q: A low overhead high performance buffer management replacement algorithm. In Proc. International Conference on Very Large Data Bases (VLDB'94), pages 439-450, 1994.
8. K. Keeton, C. Santos, D. Beyer, J. Chase, and J. Wilkes. Designing for disasters. In Proc. of File and Storage Technologies (FAST'04), pages 7-12, March-April 2004.
9. J. O. Kephart and D. M. Chess. The vision of autonomic computing. IEEE Computer, 36(1):41-50, January 2003.
10. D. Narayanan, E. Thereska, and A. Ailamaki. Continuous resource monitoring for self-predicting DBMS. In International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS'05), pages 239-248, 2005.
11. J. Rao, C. Zhang, G. M. Lohman, and N. Megiddo. Automating physical database design in a parallel database. In Proc. ACM SIGMOD Int'l Conf. on Management of Data, pages 558-569, 2002.
12. S. Singhal, M. Arlitt, D. Beyer, S. Graupner, V. Machiraju, J. Pruyne, J. Rolia, A. Sahai, C. Santos, J. Ward, and X. Zhu. Quartermaster - a resource utility system. In Proceedings of the 9th IFIF'/IEEE Intl. Symposium on Integrated Network Management, May 2005.
13. Sun Microsystems. Sun Grid Compute Utility: Reference Guide, June 2006. Part No. 819-5131-11.
14. M. Uysal, G. A. Alvarez, and A. Merchant. A modular, analytical throughput model for modern disk arrays. In Proceedings of the Ninth International Symposium on Modeling, Analysis and Simulation of Computer and Telecommunications Systems (MASCOTS-Z001), pages 183-192, 2001.
15. A. Veitch and K. Keeton. The Rubicon workload characterization tool. Technical Report HPL-SSP-2003-13, HP Laboratories, Mar. 2003.
16. J. Ward, M. O'Sullivan, T. Shahoumian, and J. Wilkes. Appia: automatic storage area network design. In Conference on File and Storage Technology (FAST'02), pages 203-217, Jan. 2002.
17. T. J. Wasserman, P. Martin, D. B. Skillicorn, and H. Rizvi. Developing a characterization of business intelligence workloads for sizing new database systems. In Proceedings of the 7th ACM International Workshop on Data Warehousing and OLAP, pages 7-13. ACM Press, 2004.
18. J. Wilkes. Traveling to Rome: QoS specifications for automated storage system management. In Proc. Intl. Workshop on Quality of Service (IWQoS'2001), number 2092 in Lecture Notes in Computer Science, pages 75-91. Springer-Verlag, June 2001.
19. J. Wilkes, G. Janakiraman, P. Goldsack, L. Russell, S. Singhal, and A. Thomas. Eos - the dawn of the resource economy. In 8th Workshop on Hot Topics in Operating Systems, May 2001.
20. D. C. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. M. Lohman, R. Cochrane, 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 IEEE Int'l Conf. on Autonomic Computing, pages 180-188, 2004.