Autonomic databases: Detection of workload shifts with n-Gram-Models

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 5207 LNCS, Issue , 2008, Pages 127-142

  Holze, Marc ^a   Ritter, Norbert ^a  

^a UNIVERSITY OF HAMBURG   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

INFORMATION SYSTEMS;

AUTONOMIC DATABASES; CONTINUOUS; DATABASE WORKLOADS; PHYSICAL DESIGNS; SELF-MANAGEMENT; TOTAL COST OF OWNERSHIPS; WORKLOAD MODELS;

DATABASE SYSTEMS;

EID: 54249134490     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-85713-6_10     Document Type: Conference Paper

References (19)

1. Agrawal, S., et al.: Database tuning advisor for Microsoft SQL Server 2005. In: Proceedings of the 30th International Conference on Very Large Data Bases, pp. 1110-1121. Morgan Kaufmann, San Francisco (2004)
2. Dageville, B., Dias, K.: Oracle's self-tuning architecture and solutions. IEEE Data Engineering Bulletin 29(3) (2006)
3. Ganik, Corbi,: The dawning of the autonomic computing era. Ibm Systems Journal 42(1), 5-18 (2003)
4. Dageville, B., et al.: Automatic SQL tuning in Oracle 10g. In: Proceedings of the 30th International Conference on Very Large Data Bases, pp. 1098-1109. Morgan Kaufmann, San Francisco (2004)
5. Zilio, D.C., et al.: Recommending materialized views and indexes with IBM DB2 design advisor. In: Proceedings of the International Conference on Autonomic Computing, pp. 180-188. IEEE Computer Society, Los Alamitos (2004)
6. Lahiri, T., et al.: The self-managing database: Automatic SGA memory management. White paper, Oracle Corporation (2003)
7. Storm, A.J., et al.: Adaptive self-tuning memory in DB2. In: Proceedings of the 32nd International Conference on Very Large Data Bases, pp. 1081-1092. ACM, New York (2006)
8. Holze, M., Ritter, N.: Towards workload shift detection and prediction for autonomic databases. In: Proceedings of the ACM first Ph.D. workshop in CIKM, pp. 109-116. ACM Press, New York (2007)
9. Lightstone, S., et al.: Making DB2 products self-managing: Strategies and experiences. IEEE Data Engineering Bulletin 29(3) (2006)
10. Fink, G.: Markov Models for Pattern Recognition, 1st edn. Springer, Heidelberg (2008)
11. Parekh, S., et al.: Throttling utilities in the IBM DB2 universal database server. In: Proceedings of the American Control Conference, pp. 1986-1991. IEEE Computer Society, Los Alamitos (2004)
12. Yao, Q., et al.: Finding and analyzing database user sessions. In: Zhou, L., Ooi, B.C., Meng, X. (eds.) DASFAA 2005. LNCS, vol. 3453, pp. 851-862. Springer, Heidelberg (2005)
13. Katz, S.: Estimation of probabilities from sparse data for the language model component of a speech recognizer. IEEE Transactions on Acoustics, Speech, and Signal Processing 35(3), 400-401 (1987)
14. Jelinek, F., Mercer, R.L.: Interpolated estimation of markov source parameters from sparse data. In: Pattern Recognition in Practice, pp. 381-397. North-Holland, Amsterdam (1980)
15. Dell Laboratories: Dell DVD store database test suite (2008), http://linux.dell.com/dvdstore/
16. Schnaitter, K., et al.: On-line index selection for shifting workloads. In: Proceedings of the 23rd International Conference on Data Engineering Workshops. IEEE Computer Society Press, Los Alamitos (2007)
17. Bruno, N., Chaudhuri, S.: An online approach to physical design tuning. In: Proceedings of the 23nd International Conference on Data Engineering, pp. 826-835. IEEE Computer Society Press, Los Alamitos (2007)
18. Elnaffar, S., Martin, P., Horman, R.: Automatically classifying database workloads. In: Proceedings of the 2002 ACM CIKM International Conference on Information and Knowledge Management. ACM Press, New York (2002)
19. Martin, P., et al.: Workload models for autonomic database management systems. In: Proceedings of the International Conference on Autonomic and Autonomous Systems, p. 10. IEEE Computer Society, Los Alamitos (2006)