Abstract
Performance self tuning in database systems is a challenge work since it is hard to identify tuning parameters and make a balance to choose proper configuration values for them. In this paper, we propose a neural network based algorithm for performance self-tuning. We first extract Automatic Workload Repository report automatically, and then identify key system performance parameters and performance indicators. We then use the collected data to construct a Neural Network model. Finally, we develop a self-tuning algorithm to tune these parameters. Experimental results for oracle database system in TPC-C workload environment show that the proposed method can dynamically improve the performance.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Alhadi, N., Ahmad, K.: Query tuning in oracle database. Journal of Computer Science 8(11), 1889–1896 (2012)
Agrawal, S., Chaudhuri, S., Narasayya, V.R.: Automated Selection of Materialized Views and Indexes in SQL Databases. In: 2000 International Conference on Very Large Data Base, pp. 496–505 (2000)
Bigus, J.P.: Applying neural networks to computer system performance tuning. In: 1994 IEEE International Conference on Neural Networks, vol. 4, pp. 2442–2447 (1994)
Belknap, P., Dageville, B., Dias, K., et al.: Self-tuning for SQL performance in Oracle database 11g. In: 2009 IEEE International Conference on Data Engineering, pp. 1694–1700 (2009)
Dageville, B., Dias, K.: Oracle’s Self-Tuning Architecture and Solutions. IEEE Data Engineer. Bulletin 29, 24–31 (2006)
Debnath, B.K., Lilja, D.J., Mokbel, M.F.: SARD: A Statistical Approach for Ranking Database Tuning Parameters. In: 2008 IEEE International Conference on Data Engineering Workshop, pp. 11–18 (2008)
Gordon-Ross, A., Vahid, F.: A self-tuning configurable cache. In: ACM Proceedings of the 44th Annual Design Automation Conference, pp. 234–237 (2007)
Haykin, S.S.: Neural networks and learning machines, 3rd edn. Pearson Education, Upper Saddle River (2009)
Panayotakis, K.: Decision Support Systems, OLTP vs DSS systems (2006), http://ezinearticles.com/?expert=Kostis-Panayotakis
Oh, J.S., Lee, S.H.: Resource selection for autonomic database tuning. In: 2005 IEEE International Conference on Data Engineering Workshops, p. 1218 (2005)
Perlovsky, L.I.: Neural Networks and Intellect: using model-based concepts. Oxford University Press, New York (2001)
Rodd, S.F., Kulkrani, U.P., Yardi, A.R.: Neural Network based Database Tuning Architecture. International Journal of Recent Trends in Engineering (2009)
Rodd, S.F., Kulkrani, U.P., Yardi, A.R.: Adaptive neuro-fuzzy technique for performance tuning of database management systems. Evolving Systems 4(2), 133–143 (2013)
TPC Benchmark C Specification, C, Revision 5.0 (2001), http://www.tpc.org/tpcc/defalut.asp
Verma, A.: Enhanced Performance of Database by Automated Self-Tuned Systems. International Journal of Computer Science (2011), 2231–5268
Yoo, R.M., Lee, H., Chow, K., et al.: Constructing a non-linear model with neural networks for workload characterization. In: 2006 IEEE International Symposium on Workload Characterization, pp. 150–159 (2006)
Zhang, G., Chen, M., Liu, L.: A Model for Application-Oriented Database Performance Tuning. In: 2012 6th IEEE International Conference on New Trends in Information Science and Service Science and Data Mining, pp. 389–394 (2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Zheng, C., Ding, Z., Hu, J. (2014). Self-tuning Performance of Database Systems with Neural Network. In: Huang, DS., Bevilacqua, V., Premaratne, P. (eds) Intelligent Computing Theory. ICIC 2014. Lecture Notes in Computer Science, vol 8588. Springer, Cham. https://doi.org/10.1007/978-3-319-09333-8_1
Download citation
DOI: https://doi.org/10.1007/978-3-319-09333-8_1
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-09332-1
Online ISBN: 978-3-319-09333-8
eBook Packages: Computer ScienceComputer Science (R0)