Performance testing on Transparent Data Encryption for SQL Server's reliability and efficiency

Evaristus Didik Madyatmadja,Aditya Nur Hakim,David Jumpa Malem Sembiring

doi:10.1186/s40537-021-00520-z

Evaristus Didik Madyatmadja, Aditya Nur Hakim + Show 1 more

Open Access

https://doi.org/10.1186/s40537-021-00520-z

Copy DOI

Abstract

Data security is being one of the most crucial aspects to be focused on system development. However, using such a feature to enhance the security of data might affect the system's performance. This study aims to observe how substantial Transparent Data Encryption as a solution for data security on Microsoft SQL Server will affect the database management system's performance. Each of the system performance is conducted with stress and load test. This paper concentrates on the upsides of using Transparent Data Encryption over standard database by finding how significant performance degradation has occurred in terms of Reliability and Efficiency.

Highlights

In the age of information explosion, data has already been a part of our daily lives that we are often unaware that we are using one
We focus on performance value such as Reliability and Efficiency to know how significant performance degradation once a system is implemented by Transparent Data Encryption (TDE) by doing Load Testing, Stress Testing and Backup Testing
This paper has shown that Transparent Data Encryption develop a performance degradation for database system

Summary

Introduction

In the age of information explosion, data has already been a part of our daily lives that we are often unaware that we are using one. Data are processed to create information as meaningful and useful content and communicated to a recipient who uses it to make a decision [1]. A system called Database Management System (DBMS) is used as a solution for storing and retrieving data [2]. The existence of risks in using the system cannot be avoided as our present-day life is vastly driven by data [3]. Various possibilities of data theft can occur when carrying out a particular project such as database server migration, cloning activities on data file storage, natural disasters that may arise, or when trying to retrieve existing data file storage [4]. The database’s security is essential as data is one of the most valuable assets owned and cannot be disclosed by anyone [5]

Objectives

Methods

Findings

Discussion

Conclusion