Research Article
BibTex RIS Cite

SQL Server'da Şifreli Yedekleme İşlemlerinde Performans

Year 2022, Volume: 8 Issue: 2, 380 - 385, 31.12.2022
https://doi.org/10.29132/ijpas.1077979

Abstract

Veritabanı güvenlik özellikleri, veritabanı sistemi geliştirmeye odaklanmak için önemli durumlardır. Ancak güvenlik özelliklerinin kullanılması sistemin performansını etkileyebilir. Şifreleme veritabanı yedeklemesi, anahtarları ve sertifikaları içeren bir tür güvenlik algoritması seçeneğidir. Ek güvenlik katmanı için gereklidir. Bu çalışma, Microsoft SQL Server üzerinde veri güvenliği için bir çözüm aracı olan Şeffaf Veri Şifreleme (TDE) özelliğinin veri tabanı performansını nasıl etkileyeceğini gözlemlemeyi amaçlamaktadır. Bu çalışmada, SQL Server'da yedekleme testi ile veritabanı yedekleme şifrelemesi ve şifreli yedekleme işlemine genel bir bakış yapılacaktır. Bu nedenle araştırma, TDE çözümünü uygularken veritabanı sisteminin performansını izlemek için yedekleme testleri üzerinde yapılacaktır. Çalışma, SQL Server'da yedekleme şifreleme algoritmalarını kullanarak, TDE ile şifrelenmiş yedekleme operasyon performansının ne kadar önemli performans değişikliği olduğunu bularak verimlilik ve kıyaslama açısından literatüre katkıda bulunacaktır.

References

  • Alain, N., Kibe, A., Cheruiyot and W. K., (2019). “International Journal of Scientific Engineering and Technology,” Use of Enhanced Transparent Data Encryption to Protect Database Against Exposure of Backup Data, pp. 477-481.
  • Bouchti, K. El, Ziti, S., Omary, F. and Kharmoum, N. (2020). New Solution Implementation to Protect Encryption Keys Inside the Database Management System, Advances in Science, Technology and Engineering Systems Journal Vol. 5, No. 2, 87-94.
  • Carter, P. (2018). Securing SQL Server: DBAs Defending the Database, ISBN-13 (pbk): 978-1-4842-4160-8, Apress
  • Cherry, D. (2015). Database Backup Security Securing SQL Server (3rd Edition) Protecting administrator Database from Attackers, pp. 293-311.
  • Coles, M. and Landrum, R. (2008). Expert SQL Server Encryption, Springer Natur, 2011. Page 11/17
  • Deshmukh, A.P. A. and Qureshi, G. R. (2011). Transparent Data Encryption- Solution for Security of Database Contents, (IJACSA) International Journal of Advanced Computer Science and Applications, Vol. 2, No.3.
  • Guyer, K., V. Milener, G. and Ray, M. (2019). “Transparent Data Encryption (TDE). [Online].Available: https://docs.microsoft.com/enus/sql/relationaldataba ses/security/encryption/transparent-data- encryption?view=sql-server-ver15.
  • Hammouchi, H., Cherqi, O. , Mezzour, Ghogho, G. M. and Koutbi, M. E. (2019). “International Symposium on Machine Learning and Big Data Analytics for Cybersecurity and Privacy,” Digging Deeper into Data Breaches: An Exploratory Data Analysis of Hacking Breaches Over Time, pp. 1004-1009.
  • Madyatmadja, E.D., Nur Hakim, A., D. And Sembiring, J. M., (2021). Performance Testing on Transparent Data Encryption for SQL Server's Reliability and Efficiency, Journal of Big Data.
  • Malik, M. and Patel, P. T. (2016). Database securityattacks and control methods. International Journal of Information 6.1/2, 175-183.
  • Mukherjee, S. (2018). Popular SQL Server Database Encryption Choices, SSRG International Journal of Computer Science and Engineering (SSRG-IJCSE) – Volume X Issue.
  • Nakamura, S., Qian, C. and Fukumoto, S. (2003). Optimal backup policy for database system with incremental and full backups", Mathematical and Computer Modelling, vol. 38, no. 11–13, pp. 1373-1379.
  • Shmuelia, E., Vaisenberg, R. and Gudesc, E. (2014). Implementing database encryption solution design and implementation issues, Computers & Security., vol. 44, pp. 33-50.
  • Soni, S. and Mathew R. (2019). Database Security: Attacks and Solutions, Proceeding of the International Conference on Computer Networks, Big Data and IoT.

Backup Encryption and Encrypted Backup Operation Performance in SQL Server

Year 2022, Volume: 8 Issue: 2, 380 - 385, 31.12.2022
https://doi.org/10.29132/ijpas.1077979

Abstract

Database security features are important ceses to be focused on database system development. However, using security features can affect the system's performance. Encryption database backup is a kind of security algorithm option, that includes keys and certificates. It is essential for additional layer of security. This study aims to observe how Transparent Data Encryption (TDE) feature, as a solution tool for data security on Microsoft SQL Server, will impact the database performance. In this study, there will be an overview of database backup encryption and encrypted backup operation through backup testing in SQL Server. Hence, the research will be conducted on backup testing for monitoring database system's performance when implementing TDE solution. The study will contribute to the literature with using backup encryption algorithms in SQL Server in terms of efficiency and benchmarking of encrypted backup operation performance with TDE by finding how significant performance change is happening.

References

  • Alain, N., Kibe, A., Cheruiyot and W. K., (2019). “International Journal of Scientific Engineering and Technology,” Use of Enhanced Transparent Data Encryption to Protect Database Against Exposure of Backup Data, pp. 477-481.
  • Bouchti, K. El, Ziti, S., Omary, F. and Kharmoum, N. (2020). New Solution Implementation to Protect Encryption Keys Inside the Database Management System, Advances in Science, Technology and Engineering Systems Journal Vol. 5, No. 2, 87-94.
  • Carter, P. (2018). Securing SQL Server: DBAs Defending the Database, ISBN-13 (pbk): 978-1-4842-4160-8, Apress
  • Cherry, D. (2015). Database Backup Security Securing SQL Server (3rd Edition) Protecting administrator Database from Attackers, pp. 293-311.
  • Coles, M. and Landrum, R. (2008). Expert SQL Server Encryption, Springer Natur, 2011. Page 11/17
  • Deshmukh, A.P. A. and Qureshi, G. R. (2011). Transparent Data Encryption- Solution for Security of Database Contents, (IJACSA) International Journal of Advanced Computer Science and Applications, Vol. 2, No.3.
  • Guyer, K., V. Milener, G. and Ray, M. (2019). “Transparent Data Encryption (TDE). [Online].Available: https://docs.microsoft.com/enus/sql/relationaldataba ses/security/encryption/transparent-data- encryption?view=sql-server-ver15.
  • Hammouchi, H., Cherqi, O. , Mezzour, Ghogho, G. M. and Koutbi, M. E. (2019). “International Symposium on Machine Learning and Big Data Analytics for Cybersecurity and Privacy,” Digging Deeper into Data Breaches: An Exploratory Data Analysis of Hacking Breaches Over Time, pp. 1004-1009.
  • Madyatmadja, E.D., Nur Hakim, A., D. And Sembiring, J. M., (2021). Performance Testing on Transparent Data Encryption for SQL Server's Reliability and Efficiency, Journal of Big Data.
  • Malik, M. and Patel, P. T. (2016). Database securityattacks and control methods. International Journal of Information 6.1/2, 175-183.
  • Mukherjee, S. (2018). Popular SQL Server Database Encryption Choices, SSRG International Journal of Computer Science and Engineering (SSRG-IJCSE) – Volume X Issue.
  • Nakamura, S., Qian, C. and Fukumoto, S. (2003). Optimal backup policy for database system with incremental and full backups", Mathematical and Computer Modelling, vol. 38, no. 11–13, pp. 1373-1379.
  • Shmuelia, E., Vaisenberg, R. and Gudesc, E. (2014). Implementing database encryption solution design and implementation issues, Computers & Security., vol. 44, pp. 33-50.
  • Soni, S. and Mathew R. (2019). Database Security: Attacks and Solutions, Proceeding of the International Conference on Computer Networks, Big Data and IoT.
There are 14 citations in total.

Details

Primary Language English
Subjects Engineering
Journal Section Articles
Authors

Zühre Aydın Yenioğlu 0000-0002-5992-4983

Early Pub Date December 29, 2022
Publication Date December 31, 2022
Submission Date February 24, 2022
Acceptance Date August 30, 2022
Published in Issue Year 2022 Volume: 8 Issue: 2

Cite

APA Aydın Yenioğlu, Z. (2022). Backup Encryption and Encrypted Backup Operation Performance in SQL Server. International Journal of Pure and Applied Sciences, 8(2), 380-385. https://doi.org/10.29132/ijpas.1077979
AMA Aydın Yenioğlu Z. Backup Encryption and Encrypted Backup Operation Performance in SQL Server. International Journal of Pure and Applied Sciences. December 2022;8(2):380-385. doi:10.29132/ijpas.1077979
Chicago Aydın Yenioğlu, Zühre. “Backup Encryption and Encrypted Backup Operation Performance in SQL Server”. International Journal of Pure and Applied Sciences 8, no. 2 (December 2022): 380-85. https://doi.org/10.29132/ijpas.1077979.
EndNote Aydın Yenioğlu Z (December 1, 2022) Backup Encryption and Encrypted Backup Operation Performance in SQL Server. International Journal of Pure and Applied Sciences 8 2 380–385.
IEEE Z. Aydın Yenioğlu, “Backup Encryption and Encrypted Backup Operation Performance in SQL Server”, International Journal of Pure and Applied Sciences, vol. 8, no. 2, pp. 380–385, 2022, doi: 10.29132/ijpas.1077979.
ISNAD Aydın Yenioğlu, Zühre. “Backup Encryption and Encrypted Backup Operation Performance in SQL Server”. International Journal of Pure and Applied Sciences 8/2 (December 2022), 380-385. https://doi.org/10.29132/ijpas.1077979.
JAMA Aydın Yenioğlu Z. Backup Encryption and Encrypted Backup Operation Performance in SQL Server. International Journal of Pure and Applied Sciences. 2022;8:380–385.
MLA Aydın Yenioğlu, Zühre. “Backup Encryption and Encrypted Backup Operation Performance in SQL Server”. International Journal of Pure and Applied Sciences, vol. 8, no. 2, 2022, pp. 380-5, doi:10.29132/ijpas.1077979.
Vancouver Aydın Yenioğlu Z. Backup Encryption and Encrypted Backup Operation Performance in SQL Server. International Journal of Pure and Applied Sciences. 2022;8(2):380-5.

154501544915448154471544615445