A STUDY OF CAPACITY PLANNING FOR DATABASE MANAGEMENT SYSTEMS WITH OLAP WORKLOADS

29th International Computer Measurement Group Conference, CMG 2003

Volumn , Issue , 2003, Pages

  Cui, Xilin ^a   Martin, Patrick ^a   Powley, Wendy ^a  

^a QUEEN S UNIVERSITY   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

BENCHMARKING;

CAPACITY PLANNING; DATABASE DESIGN; DESIGN MANAGEMENT; PREFETCHING; PROCESSING PERFORMANCE; QUEUEING NETWORK MODEL; SYSTEM TUNING; WORKLOAD MODEL;

DATABASE SYSTEMS;

EID: 84893709576     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (15)

1. [AMDA67] G. Amdahl. “Validity of The Single Processor Approach to Achieving Large Scale Computing Capabilities”, AFIPS Conference Proceedings (1967).
2. [CUI03] X. Cui. “Capacity Planning for Database Management Systems with OLAP Workloads”, M. Sc. Thesis, School of Computing, Queen’s University (2003).
3. [DB200] “DB2/UDB Estimator Help”, DB2/UDB Estimator V7, IBM Corp. (2000).
4. [DB203] DB2/UDB Universal Database Administration Guide: Performance, IBM Corporation (2003).
5. [GRAH78] G. S. Graham. “Queueing Network Models of Computer System Performance”, Computing Surveys, Vol. 10, NO. 3, September (1978).
6. [GUNT96] N. J. Gunther. “Understanding the MP Effect: Multiprocessing in Pictures”, CMG Conference Proceedings (1996).
7. [LAZO84] E. Lazowska, J. Zahorjan, S. Graham, and K. Sevcik. “Quantitative System Performance: Computer System Analysis Using Queueing Network Models”, Prentice Hall, Englewood Cliffs, N. J. (1984).
8. [MENA98] D. Menasce, and V. A.F. Almeida. Capacity Planning for Web Performance: Metrics, Models, & Methods, Prentice Hall (1998).
9. [PATT98] D. A. Patterson and K. K. Keeton. “Hardware Technology Trends and Database Opportunities”, Keynote address at ACM-SIGMOD’98, Seattle, Washington, June (1998). Available from http://www.cs.berkeley.edu/~pattrsn/talks/sigmod98keynote-color.pdf
10. [SAUE81] C. H. Sauer and K. M. Chandy. “Computer Systems Performance Modeling”, Prentice Hall (1981).
11. [SHAS] D. Shasha and P. Bonnet. Talk notes, available from http://www.distlab.dk/dbtune/.
12. [STEN97] P. Stenstrom, E. Hagersten, D. J. Lijia, M. Martonosi and M. Venugopal. “Trends in Shared Memory Multiprocessing”, IEEE Computer, 44-50 December (1997).
13. [TPC] Transaction Processing Performance Council. http://www.tpc.org
14. [VIJA99] J. Vijavan, “Capacity Planning More Vital Than Ever”, Computer World, February (1999).
15. [ZAWA02] H. Zawawy, P. Martin and H. Hassanein. “Supporting Capacity Planning for DB2/UDB”, Proceedings of CASCON 2002, 89-97 September (2002).