|
[kalm12]
|
D. Kalmuk.
DB2 10.1: Leveraging new capabilities within the WLM best
practices.
IDUG DB2 Tech Conference presentation, November 2012.
[ bib |
.pdf ]
|
|
[kalm10]
|
David Kalmuk.
DB2 workload management overview.
IBM slide deck, 2012.
[ bib |
.pdf ]
|
|
[guku09]
|
Ajay Gulati, Chethan Kumar, and Irfan Ahmad.
Storage workload characterization and consolidation in virtualized
environments.
In Proc. Int'l Workshop on Virtualization Performance: Analysis,
Characterization, and Tools (VPACT'09), 2009.
[ bib |
.pdf ]
|
|
[choz08]
|
L. Cherkasova, K. Ozonat, N. Mi, J. Symons, and E. Smirni.
Anomaly? application change? or workload change?
In Proc. of the International Conference on Dependable Systems
and Networks (DSN'08), 2008.
[ bib |
.pdf ]
|
|
[bopl04]
|
R. Bonilla-Lucas, Peter Plachta, Aamer Sachedina, Daniel
Jiménez-González, Calisto Zuzarte, and Josep-Lluis Larriba-Pey.
Characterization of the data access behavior for TPC-C traces.
In Proc. IEEE International Symposium on Performance Analysis of
Systems and Software, pages 115-122, March 2004.
[ bib |
.pdf ]
|
|
[wama04]
|
Ted J. Wasserman, Patrick Martin, David B. Skillicorn, and Haider 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.
[ bib |
.pdf ]
Query features are response time, CPU utilization during query execution, sequential and random I/O throughput during query execution, and the join degree. Queries are then clustered in feature space, using singular value decomposition and semi-discrete decomposition. TPC-H was used for evaluation.
|
|
[chgu02]
|
Surajit Chaudhuri, Ashish Kumar Gupta, and Vivek Narasayya.
Compressing SQL workloads.
In Proceedings of the ACM SIGMOD International Conference on
Management of Data (SIGMOD'02), pages 488-499, 2002.
[ bib |
.pdf ]
A workload is a weighted set of SQL statements. Problem is to find a subset of these statements that can be used to replace the original workload as an input to certain applications, such that the substitution has little impact on the application's output. Applications considered are automatic index selection and approximate query answering.
|
|
[yuch92]
|
Philip S. Yu, Ming-Syan Chen, Hans-Ulrich Heiss, and Sukho Lee.
On workload characterization of relational database environments.
IEEE Transactions on Software Engineering, 18(4):347-355,
1992.
[ bib |
.pdf ]
Presents some statistics characterizing the database workload generated by some kind of corporate accounting application. Both structural statistics (e.g., number of statements of different types, number of predicates and attributes used in each statement, transaction sizes) and statement execution statistics (e.g., number of tuples retrieved) are collected. There is no attempt to demonstrate that these statistics are useful for any specific purpose.
|