Developing a characterization of business intelligence workloads for sizing new database systems

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2004, Pages 7-13

  Wasserman, Ted J ^a   Martin, Patrick ^a   Skillicorn, David B ^a   Rizvi, Haider ^b  

^a QUEEN S UNIVERSITY   (Canada)

^b IBM TORONTO LAB   (Canada)

Author keywords

Business Intelligence; Capacity Planning; Clustering; Sizing; Workload Characterization

Indexed keywords

ALGORITHMS; BENCHMARKING; DATA STORAGE EQUIPMENT; DATA WAREHOUSES; DATABASE SYSTEMS; EXTRAPOLATION; PARAMETER ESTIMATION; QUALITY OF SERVICE; QUERY LANGUAGES; QUEUEING NETWORKS;

CAPACITY PLANNING; CLUSTERING; SIZING; WORKLOAD CHARACTERIZATION;

COMPETITIVE INTELLIGENCE;

EID: 19644392703     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1031763.1031766     Document Type: Conference Paper

References (22)

1. M. Calzarossa and G. Serazzi. "Construction and Use of Multiclass Workload Models", Performance Evaluation, 9, 4, 1994.
2. X. Cui, P. Martin, and W. Powley. "A Study of Capacity Planning for Database Management Systems With OLAP Workloads", Proceedings of CMG 2003, December 2003.
3. S. Elnaffar and P. Martin. "Characterizing Computer Systems' Workloads", Technical Report 2002-461, School of Computing, Queen's University, Canada, 2002.
4. D. Ferrari, Computer Systems Performance Evaluation, Prentice Hall, 1978.
5. C. Elms. "Clustering - One method for Workload Characterization", Proceedings of the International Conference on Computer Capacity Management, San Francisco, California, 1980.
6. Gartner, Press Room - Quick Statistics. Retrieved from http://www.dataquest.com/press_gartner/quickstats/databases.html on June 1, 2004.
7. A. Ghosh, J. Parikh, V.S. Sengar and J. R. Haritsa. "Plan Selection Based on Query Clustering", Proceedings of VLDB, 2002.
8. G.B. Gibbs et. al/ IBM e-server pSeries Sizing and Capacity Planning: A Practical Guide. IBM Redbook SG-247071, March 2004, http://www.redbooks.ibm.com/redbooks/pdfs/sg247071.pdf.
9. M. Golfarelli and E. Saltarelli. "The Workload You Have, the Workload You Would Lik", Proceedings 6th ACM International Workshop on Data Warehousing and OLAP (DOLAP 2003), 2003.
10. G.H. Golub and C.F. van Loan. Matrix Computations, Johns Hopkins University Press, 3rd edition, 1996.
11. S. Hahn et. al. Capacity Planning for Business Intelligence Applications: Approaches and Methodologies, IBM Redbook SG24-5685, November 2000, http://www.redbooks.ibm.com/redbooks/pdfs/sg245689.pdf
12. IBM. DB2 Universal Database, http://www.software.ibm.com/data/db2/udb.
13. T.G. Kolda and D.P. O'Leary. "Computation and uses of the semidiscrete matrix decomposition", ACM Transactions on Information Processing, 1999.
14. S. Lam and K. H. Chan. Computer Capacity Planning: Theory and Practice, Academic Press, 1987.
15. Mathworks Incorporated. MATLAB, http://www.mathworks.com.
16. D. Menascè, V.A.F. Almeida, and L. Dowdy. Capacity Planning and Performance Modeling: From Mainframes to Client-Server Systems, Prentice Hall, 1994.
17. C. Nikolaou et. al. "The Impact of Workload Clustering on Transaction Routing", Technical Report FORTH-ICS TR-2238, 1998,
18. Transaction Processing Performance Council. TPC Benchmark H Standard Specification, Revision 2.1.0 http://www.tpc.org/tpch/spec/tpch2.1.0.pdf.
19. T.J. Wasserman. Sizing Database Systems for Business Intelligence Workloads, M.Sc. Thesis, School of Computing, Queen's University, 2004.
20. T.J. Wasserman, P. Martin, and H. Rizvi. "Sizing DB2 UDB Servers for Business Intelligence Workloads", Proceedings of GASCON 2004, October 2004.
21. J-R Wen, J-Y Nie and H-J Zhang. "Query clustering using user logs", ACM Transactions on Information Systems, 20, 1, 2002.
22. H. Zawawy, P. Martin and H. Hassanein. "Supporting Capacity Planning for DB2 UDB", Proceedings of GASCON 2003, September 2003.