Abstract
With the rapid development of technology, now it can not only be aimed a correct running of systems but also a high level of technical performance. In this paper, we will evaluate the database performance in terms of optimization and also the security it provides. We will present briefly the potential causes of an unsatisfactory performance of the database and also the solution for each determined issue. We will give in detail the optimization of TempDB, Cache and Index Fragmentation and how does those affect the overall DB performance. The optimization is intended to be achieved by simultaneous implementation of these optimization techniques. Also, we will determine some of the best security techniques in the DB, such as encryption or recognizing User Roles, and High Availability, which provides security in several database hierarchies. The combinations of these techniques provide overall database security.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
LeBlanc, P., Jorgensen, A., Segarra, J., Nelson, A., Chinchilla, J.: Microsoft SQL Server Bible (2012)
Tripp, K.L.: https://www.sqlskills.com
Boral, H., DeWitt, D.: A methodology for database system performance evaluation. In: ACM SIGMOD International Conference on Management of Data, pp. 176–185 (1984)
Subharthi, P., Jain, R.: Database systems performance evaluation techniques, a Project report, November 2008
Rees, S., Rech, T., Depper, O., Singh, N.K., Shen, G., B. Melnyk, R.: Best practices, tuning and monitoring database system performance. IBM publication, July 2013
Kaladi, A., Ponnusamy, P.: Performance evaluation of database management systems by the analysis of DBMS. Int. J. Modern Eng. Res. (IJMER) 2(2), 067–072 (2012). ISSN 2249-6645
Goodwell, M.: Application Performance Management (2014). https://www.dynatrace.com/blog/five-easy-steps-improvedatabase-performance/
Burleson, D.: High Throughput vs Response time (2015). http://www.dba-oracle.com/t_tuning_high_throughput_vs_fast_response_time.htm
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this paper
Cite this paper
Kushe, R., Karafili, K. (2018). Evaluation of Techniques for Improving Performance and Security in Relational Databases. In: Barolli, L., Xhafa, F., Javaid, N., Spaho, E., Kolici, V. (eds) Advances in Internet, Data & Web Technologies. EIDWT 2018. Lecture Notes on Data Engineering and Communications Technologies, vol 17. Springer, Cham. https://doi.org/10.1007/978-3-319-75928-9_42
Download citation
DOI: https://doi.org/10.1007/978-3-319-75928-9_42
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-75927-2
Online ISBN: 978-3-319-75928-9
eBook Packages: EngineeringEngineering (R0)