Home / Current Issue / Paper 1725089
A Systematic Review of Transparent Data Encryption (TDE) Performance Overhead in Regulated Enterprise Database Estates
Subject area: Science,Engineering and Technology · Area of research: Cybersecurity
Abstract
Transparent Data Encryption (TDE) has become the default control that banks, insurers, healthcare providers and public bodies use to meet encryption-at-rest obligations under PCI DSS, HIPAA, the GDPR, the NYDFS Cybersecurity Regulation and the Nigeria Data Protection Regulation, yet its performance cost is reported inconsistently, ranging from vendor estimates of a few percent to practitioner accounts of severe disruption. This paper reports a systematic literature review, conducted in 2019 following the Kitchenham and Charters guidelines, of peer-reviewed studies, standards and vendor documentation covering Oracle Database, Microsoft SQL Server, IBM Db2, MySQL and MongoDB, supported by two contextual seed corpora of 50 regional and 50 international studies. The review finds that steady-state overhead is modest on processors with hardware AES acceleration, because TDE encrypts pages at the I/O boundary and keeps plaintext in the buffer cache, but that overhead rises with I/O-intensive workloads, low cache hit ratios, limited CPU headroom, virtualization that hides AES-NI and the loss of downstream compression. The largest costs arise during lifecycle events, namely initial encryption, backup and restore, key rotation and dependence on external key managers. From these findings the paper develops the TDE Performance Overhead Model, which links regulatory drivers and encryption scope to steady-state and lifecycle overhead through seven testable propositions. The evidence base is dominated by vendor sources with few independent measurements, so the paper concludes with a measurement protocol and deployment recommendations for regulated estates and an agenda for empirical research.
Keywords
AES-NI, conceptual model, database performance, encryption at rest, enterprise database estates, key management, regulatory compliance, systematic literature review, Transparent data encryption
References
[1] Abdulrazaq, K., Yusuf, H. D., Osinem, H. E., & Eribenne, F. (2019). A model for improving infection detection accuracy through integrated laboratory information systems. Iconic Research and Engineering Journals, 3(6), 650-675. https://doi.org/10.64388/IREV3I6-1723089
[2] Adaramola, T. S., Fadero, S., & Gideon, E. N. (2018). Predictive maintenance and condition monitoring in critical power and energy infrastructure. Iconic Research and Engineering Journals, 2(5), 454-477. https://doi.org/10.64388/IREV2I5-1722489
[3] Adeyelu, O. O. (2018). A predictive compliance monitoring framework for detecting systemic safety risks through aviation consumer complaint data. Iconic Research and Engineering Journals, 1(8), 250-276. https://doi.org/10.64388/IREV1I8-1718478
[4] Agbabiaka, J., Okonkwo, C. S., Ogunwole, O., Mayo, W., & Okeke, O. T. (2019). Supply chain risk management model for EPC and gas processing projects. Iconic Research and Engineering Journals, 3(2), 968-980. https://doi.org/10.64388/IREV3I2-1713124
[5] Agboada, P., Ezeako, R., Okoli, I. E., & Ibeh, A. V. (2018). Distributorship and trade finance product design: A conceptual framework for new-to-bank growth in emerging markets. Iconic Research and Engineering Journals, 2(5), 552-578. https://doi.org/10.64388/IREV2I5-1723312
[6] Agboada, P., Ezeako, R., Okoli, I. E., & Uzondu, C. S. (2018). Digital transformation in operations management: A review of advances in automation, analytics, and process redesign. International Journal of Engineering Technology Research & Management, 2(11), 109-134.
[7] Agboada, P., Ezeako, R., Okoli, I. E., & Uzondu, C. S. (2019). Standard operating procedures as change infrastructure: A conceptual framework for sustaining operational improvement. Iconic Research and Engineering Journals, 3(6), 706-730. https://doi.org/10.64388/IREV3I6-1723313
[8] Agrawal, R., Kiernan, J., Srikant, R., & Xu, Y. (2004). Order preserving encryption for numeric data. In Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data (pp. 563-574). ACM.
[9] Agyei, R. K., Izuchukwu, O. T., Feboh, D., & Idowu, A. (2019). Determinants of web-based payment portal adoption in Sub-Saharan Africa: A review and synthesis. International Journal of Computer Science and Mathematical Theory, 5(2), 56-79. https://doi.org/10.56201/ijcsmt.vol.5.no2.2019.pg56.79
[10] Ahmed, K. S., & Odejobi, O. D. (2018a). Conceptual framework for scalable and secure cloud architectures for enterprise messaging. IRE Journals, 2(1), 1-15.
[11] Ahmed, K. S., & Odejobi, O. D. (2018b). Resource allocation model for energy-efficient virtual machine placement in data centers. IRE Journals, 2(3), 1-10.
[12] Ahmed, K. S., Odejobi, O. D., & Oshoba, T. O. (2019). Algorithmic model for constraint satisfaction in cloud network resource allocation. IRE Journals, 2(12), 516-532.
[13] Akdemir, K., Dixon, M., Feghali, W., Fay, P., Gopal, V., Guilford, J., Ozturk, E., Wolrich, G., & Zohar, R. (2010). Breakthrough AES performance with Intel AES New Instructions [White paper]. Intel Corporation.
[14] Akeju, B., Edivri, J., Ogbole, J. I., Okoruwa, P. O., Fadayomi, O., & Abolaji, T. O. (2018). Conceptual model for insider threat classification and risk modeling in complex digital systems. Iconic Research and Engineering Journals, 1(9), 476-492. https://doi.org/10.64388/IREV1I9-1713778
[15] Akomolafe, O., & Agu, M. U. (2018). A conceptual model for enhancing internal audit quality through technology-enabled risk assessment frameworks. Iconic Research and Engineering Journals, 1(9), 458-475.
[16] Akomolafe, O., & Agu, M. U. (2019a). A conceptual framework for developing risk-based internal control models in the insurance and banking sectors. Iconic Research and Engineering Journals, 2(8), 335-354.
[17] Akomolafe, O., & Agu, M. U. (2019b). A review of data-driven risk evaluation models for emerging market financial institutions. Iconic Research and Engineering Journals, 3(6), 433-448.
[18] Akomolafe, O., & Agu, M. U. (2019c). Advances in financial resilience through integrated governance and compliance strategies. Iconic Research and Engineering Journals, 2(10), 607-620.
[19] Amayo, E. B., & Popoola, T. T. (2017b). Scientific study of telecommunication deployment in achieving quality network. International Journal of Trend in Research and Development, 4(5), 311-314.
[20] Aneke, O. B., & Adesemoye, A. C. (2019). Toward an integrated conceptual framework for traceability and chain-of-custody integrity in pharmaceutical distribution. Iconic Research and Engineering Journals, 3(4), 655-672.
[21] Anichukwueze, C. C., Osuji, V. C., & Oguntegbe, E. E. (2019). Global marketing law and consumer protection challenges: A strategic framework for multinational compliance. IRE Journals, 3(6), 325-333.
[22] Anyanwu, K. C. E. (2019). Developing a maturity model for standardizing IT support operations across geographically distributed multi-office organizations. Iconic Research and Engineering Journals, 3(5)., 580-598.
[23] Arasu, A., Blanas, S., Eguro, K., Kaushik, R., Kossmann, D., Ramamurthy, R., & Venkatesan, R. (2013). Orthogonal security with Cipherbase. In Proceedings of the 6th Biennial Conference on Innovative Data Systems Research (CIDR).
[24] Arasu, A., Eguro, K., Joglekar, M., Kaushik, R., Kossmann, D., & Ramamurthy, R. (2015). Transaction processing on confidential data using Cipherbase. In Proceedings of the 31st IEEE International Conference on Data Engineering (ICDE). IEEE.
[25] Asibor, E., & Isong, D. E. (2019). Risk-based process engineering framework for strengthening reliability across complex natural gas infrastructure systems. Iconic Research and Engineering Journals, 3(2), 1020-1060. https://doi.org/10.64388/IREV3I2-1723153
[26] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2018). A systematic review of CI/CD pipeline strategies in Salesforce DevOps: Tools, practices, and deployment outcomes. Iconic Research and Engineering Journals, 2(6).
[27] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2019a). A conceptual model for ETL design and data integration in Salesforce-centric enterprise architectures. Iconic Research and Engineering Journals, 3(5).
[28] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2019b). A governance framework for Salesforce platform management in regulated healthcare environments. Iconic Research and Engineering Journals, 3(6).
[29] Bajaj, S., & Sion, R. (2011). TrustedDB: A trusted hardware based database with privacy and data confidentiality. In Proceedings of the 2011 ACM SIGMOD International Conference on Management of Data. ACM.
[30] Barham, P., Dragovic, B., Fraser, K., Hand, S., Harris, T., Ho, A., Neugebauer, R., Pratt, I., & Warfield, A. (2003). Xen and the art of virtualization. In Proceedings of the 19th ACM Symposium on Operating Systems Principles (pp. 164-177). ACM.
[31] Barker, E. (2016). Recommendation for key management, Part 1: General (NIST Special Publication 800-57 Part 1, Revision 4). National Institute of Standards and Technology.
[32] Barker, E., Smid, M., Branstad, D., & Chokhani, S. (2013). A framework for designing cryptographic key management systems (NIST Special Publication 800-130). National Institute of Standards and Technology.
[33] Bellare, M., Keelveedhi, S., & Ristenpart, T. (2013). Message-locked encryption and secure deduplication. In Advances in Cryptology: EUROCRYPT 2013, Lecture Notes in Computer Science (Vol. 7881). Springer.
[34] Bertino, E., & Sandhu, R. (2005). Database security: Concepts, approaches, and challenges. IEEE Transactions on Dependable and Secure Computing, 2(1), 2-19.
[35] Blaze, M. (1993). A cryptographic file system for UNIX. In Proceedings of the 1st ACM Conference on Computer and Communications Security (pp. 9-16). ACM.
[36] Bola-Sadipe, D., Aliliele, C., & Eboh, E. E. (2019). Conceptual model for strategic accounting systems strengthening financial transparency and regulatory compliance. IRE Journals, 3(6), 535-564. https://doi.org/10.64388/IREV3I6-1715327
[37] Boldyreva, A., Chenette, N., Lee, Y., & O'Neill, A. (2009). Order-preserving symmetric encryption. In Advances in Cryptology: EUROCRYPT 2009, Lecture Notes in Computer Science (Vol. 5479, pp. 224-241). Springer.
[38] Bouganim, L., & Pucheral, P. (2002). Chip-secured data access: Confidential data on untrusted servers. In Proceedings of the 28th International Conference on Very Large Data Bases (VLDB) (pp. 131-142).
[39] Chandramouli, R., Iorga, M., & Chokhani, S. (2013). Cryptographic key management issues and challenges in cloud services (NIST Interagency Report 7956). National Institute of Standards and Technology.
[40] Cooper, B. F., Silberstein, A., Tam, E., Ramakrishnan, R., & Sears, R. (2010). Benchmarking cloud serving systems with YCSB. In Proceedings of the 1st ACM Symposium on Cloud Computing (pp. 143-154). ACM.
[41] Curino, C., Jones, E. P. C., Madden, S., & Balakrishnan, H. (2011). Workload-aware database monitoring and consolidation. In Proceedings of the 2011 ACM SIGMOD International Conference on Management of Data (pp. 313-324). ACM.
[42] Curtmola, R., Garay, J., Kamara, S., & Ostrovsky, R. (2006). Searchable symmetric encryption: Improved definitions and efficient constructions. In Proceedings of the 13th ACM Conference on Computer and Communications Security (pp. 79-88). ACM.
[43] Daemen, J., & Rijmen, V. (2002). The design of Rijndael: AES, the Advanced Encryption Standard. Springer.
[44] Damiani, E., De Capitani di Vimercati, S., Jajodia, S., Paraboschi, S., & Samarati, P. (2003). Balancing confidentiality and efficiency in untrusted relational DBMSs. In Proceedings of the 10th ACM Conference on Computer and Communications Security (pp. 93-102). ACM.
[45] Davida, G. I., Wells, D. L., & Kam, J. B. (1981). A database encryption system with subkeys. ACM Transactions on Database Systems, 6(2), 312-328.
[46] Dogbatsey, E. A., & Ebhojie, O. (2018). Budget compliance and statutory reporting in Sub-Saharan Africa: A systematic review of frameworks, gaps, and reform pathways. Zenodo. https://doi.org/10.5281/zenodo.20446859
[47] Dogbatsey, E. A., Ebhojie, O., & Oyeleye, A. O. (2019). Reconciliation control and financial workflow redesign in emerging market organizations: A conceptual framework. Zenodo. https://doi.org/10.5281/zenodo.20447103
[48] Dosunmu, A. A., & Ogundele, P. O. (2019). Security audit and enterprise risk assessment frameworks for resilient information systems. Iconic Research and Engineering Journals, 3(5), 434-447. https://doi.org/10.64388/IREV3I5-1713225
[49] Douceur, J. R., Adya, A., Bolosky, W. J., Simon, D., & Theimer, M. (2002). Reclaiming space from duplicate files in a serverless distributed file system. In Proceedings of the 22nd International Conference on Distributed Computing Systems (pp. 617-624). IEEE.
[50] Dworkin, M. (2001). Recommendation for block cipher modes of operation: Methods and techniques (NIST Special Publication 800-38A). National Institute of Standards and Technology.
[51] Dworkin, M. (2010). Recommendation for block cipher modes of operation: The XTS-AES mode for confidentiality on storage devices (NIST Special Publication 800-38E). National Institute of Standards and Technology.
[52] Effelsberg, W., & Haerder, T. (1984). Principles of database buffer management. ACM Transactions on Database Systems, 9(4), 560-595.
[53] Ekemezie, U. C., Ohunyon, G., & Sydney, E. (2018). Evaluating IDSR implementation in Benue State, Nigeria: DHIS2 data quality and surveillance capacity. Iconic Research and Engineering Journals, 2(6).
[54] Elovici, Y., Waisenberg, R., Shmueli, E., & Gudes, E. (2004). A structure preserving database encryption scheme. In Secure Data Management (SDM 2004), Lecture Notes in Computer Science (Vol. 3178, pp. 28-40). Springer.
[55] European Parliament and Council of the European Union. (2016). Regulation (EU) 2016/679 (General Data Protection Regulation). Official Journal of the European Union, L 119.
[56] Ezeako, R., Okoli, I. E., Uzondu, C. S., & Ibeh, A. V. (2019). Relationship banking performance: A conceptual framework for portfolio growth and profitability acceleration. International Journal of Engineering Technology Research & Management, 3(11), 132-151.
[57] Fadayomi, O., Abolaji, T. O., Edivri, J., Ogbole, J. I., Okoruwa, P. O., & Akeju, B. (2019). Risk-based cybersecurity assurance and data availability: Limitations, advances and future research opportunities. Iconic Research and Engineering Journals, 2(12), 602-617. https://doi.org/10.64388/IREV2I12-1713779
[58] Ferretti, L., Colajanni, M., & Marchetti, M. (2014). Distributed, concurrent, and independent access to encrypted cloud databases. IEEE Transactions on Parallel and Distributed Systems, 25(2), 437-446.
[59] Garousi, V., Felderer, M., & Mäntylä, M. V. (2019). Guidelines for including grey literature and conducting multivocal literature reviews in software engineering. Information and Software Technology, 106, 101-121.
[60] Ge, T., & Zdonik, S. (2007). Fast, secure encryption for indexing in a column-oriented DBMS. In Proceedings of the 23rd IEEE International Conference on Data Engineering (ICDE). IEEE.
[61] Gentry, C. (2009). Fully homomorphic encryption using ideal lattices. In Proceedings of the 41st Annual ACM Symposium on Theory of Computing (pp. 169-178). ACM.
[62] Gideon, E. N., Adaramola, T. S., & Fadero, S. (2019). Reliability engineering and failure analysis in complex engineering systems. Iconic Research and Engineering Journals, 2(11), 703-727. https://doi.org/10.64388/IREV2I11-1722490
[63] Grubbs, P., Ristenpart, T., & Shmatikov, V. (2017). Why your encrypted database is not secure. In Proceedings of the 16th Workshop on Hot Topics in Operating Systems (HotOS) (pp. 162-168). ACM.
[64] Gueron, S. (2010). Intel Advanced Encryption Standard (AES) New Instructions Set (White paper, Revision 3.0). Intel Corporation.
[65] Hacigumus, H., Iyer, B., Li, C., & Mehrotra, S. (2002). Executing SQL over encrypted data in the database-service-provider model. In Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data (pp. 216-227).
[66] Halcrow, M. A. (2005). eCryptfs: An enterprise-class encrypted filesystem for Linux. In Proceedings of the Linux Symposium (Vol. 1, pp. 209-226).
[67] Halderman, J. A., Schoen, S. D., Heninger, N., Clarkson, W., Paul, W., Calandrino, J. A., Feldman, A. J., Appelbaum, J., & Felten, E. W. (2009). Lest we remember: Cold-boot attacks on encryption keys. Communications of the ACM, 52(5), 91-98.
[68] Harizopoulos, S., Abadi, D. J., Madden, S., & Stonebraker, M. (2008). OLTP through the looking glass, and what we found there. In Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (pp. 981-992). ACM.
[69] IBM. (2019). Db2 native encryption. IBM Db2 11.5 Knowledge Center.
[70] IEEE. (2008). IEEE standard for cryptographic protection of data on block-oriented storage devices (IEEE Std 1619-2007). Institute of Electrical and Electronics Engineers.
[71] Iyer, B., Mehrotra, S., Mykletun, E., Tsudik, G., & Wu, Y. (2004). A framework for efficient storage security in RDBMS. In Advances in Database Technology (EDBT 2004), Lecture Notes in Computer Science (Vol. 2992, pp. 147-164). Springer.
[72] Joint Task Force Transformation Initiative. (2013). Security and privacy controls for federal information systems and organizations (NIST Special Publication 800-53, Revision 4). National Institute of Standards and Technology.
[73] Kallahalla, M., Riedel, E., Swaminathan, R., Wang, Q., & Fu, K. (2003). Plutus: Scalable secure file sharing on untrusted storage. In Proceedings of the 2nd USENIX Conference on File and Storage Technologies (FAST) (pp. 29-42). USENIX Association.
[74] Kamara, S., & Lauter, K. (2010). Cryptographic cloud storage. In Financial Cryptography and Data Security: FC 2010 Workshops, Lecture Notes in Computer Science (Vol. 6054, pp. 136-149). Springer.
[75] Käsper, E., & Schwabe, P. (2009). Faster and timing-attack resistant AES-GCM. In Cryptographic Hardware and Embedded Systems: CHES 2009, Lecture Notes in Computer Science (Vol. 5747, pp. 1-17). Springer.
[76] Kitchenham, B., & Charters, S. (2007). Guidelines for performing systematic literature reviews in software engineering (EBSE Technical Report EBSE-2007-01). Keele University and Durham University.
[77] Kitchenham, B., Brereton, O. P., Budgen, D., Turner, M., Bailey, J., & Linkman, S. (2009). Systematic literature reviews in software engineering: A systematic literature review. Information and Software Technology, 51(1), 7-15.
[78] Ladapo, O. O., Dosunmu, A. A., Jooda, D., & Abolaji, T. O. (2018). Lessons learned from offline assessment of security-critical systems: The case of Microsoft Active Directory. Iconic Research and Engineering Journals, 2(6), 277-299. https://doi.org/10.64388/IREV2I6-1717205
[79] Ladapo, O. O., Jooda, D., Dosunmu, A. A., & Abolaji, T. O. (2019). Implementation of Active Directory for efficient management of enterprise networks. Iconic Research and Engineering Journals, 3(4), 608-627. https://doi.org/10.64388/IREV3I4-1717206
[80] Lawal, O. A., & Oduleye, T. E. (2018a). A conceptual model for financial analytics driven enterprise value creation in technology firms. Iconic Research and Engineering Journals, 2(2).
[81] Lawal, O. A., & Oduleye, T. E. (2018b). A review and conceptual framework for tax governance and cross-border compliance analytics. Iconic Research and Engineering Journals, 2(5).
[82] Lawal, O. A., & Oduleye, T. E. (2019a). A conceptual risk assessment model for transfer pricing in multinational corporations. Iconic Research and Engineering Journals, 2(12).
[83] Lawal, O. A., & Oduleye, T. E. (2019b). Conceptualizing data driven executive decision systems for strategic financial planning. Iconic Research and Engineering Journals, 3(3).
[84] Mbonu, I. S., Aliliele, C., Iwuanyanwu, U., & Oluoha, O. M. (2018). A conceptual framework for legal and ethical risk modeling in enterprise data protection governance systems. Iconic Research and Engineering Journals, 2(2), 207-226. https://doi.org/10.64388/IREV2I2-1714911
[85] Mbonu, I. S., Aliliele, C., Uzoka, E., & Oluoha, O. M. (2019). A review of comparative data protection regulations and secure cloud implementation strategies across jurisdictions. Iconic Research and Engineering Journals, 2(9), 482-501. https://doi.org/10.64388/IREV2I9-1714912
[86] Mbonu, I. S., Iwuanyanwu, U., Uzoka, E., & Oluoha, O. M. (2019). Advances in enterprise log analytics and automated incident response architectures using Python and SIEM platforms. Iconic Research and Engineering Journals, 3(2), 1000-1019. https://doi.org/10.64388/IREV3I2-1714915
[87] McGrew, D. A., & Viega, J. (2004). The security and performance of the Galois/Counter Mode (GCM) of operation. In Progress in Cryptology: INDOCRYPT 2004, Lecture Notes in Computer Science (Vol. 3348, pp. 343-355). Springer.
[88] Mensah, K. O., Pedro, O., Kinyanjui, A., Okoli, I., & Agboada, P. (2019). A review of capital adequacy frameworks and risk weighted asset optimization in modern banking systems. Iconic Research and Engineering Journals, 3(6), 731-768. https://doi.org/10.64388/IREV3I6-1723267
[89] Meyer, D. T., & Bolosky, W. J. (2011). A study of practical deduplication. In Proceedings of the 9th USENIX Conference on File and Storage Technologies (FAST). USENIX Association.
[90] Microsoft. (2019a). Transparent data encryption (TDE). SQL Server documentation, Microsoft Docs.
[91] Microsoft. (2019b). Backup compression (SQL Server). SQL Server documentation, Microsoft Docs.
[92] Mohan, C., Haderle, D., Lindsay, B., Pirahesh, H., & Schwarz, P. (1992). ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Transactions on Database Systems, 17(1), 94-162.
[93] Moher, D., Liberati, A., Tetzlaff, J., Altman, D. G., & The PRISMA Group. (2009). Preferred reporting items for systematic reviews and meta-analyses: The PRISMA statement. PLoS Medicine, 6(7), e1000097.
[94] MongoDB, Inc. (2019). Encryption at rest. MongoDB Manual, version 4.2.
[95] National Information Technology Development Agency. (2019). Nigeria Data Protection Regulation. NITDA.
[96] National Institute of Standards and Technology. (2001). Advanced Encryption Standard (AES) (FIPS Publication 197).
[97] Naveed, M., Kamara, S., & Wright, C. V. (2015). Inference attacks on property-preserving encrypted databases. In Proceedings of the 22nd ACM SIGSAC Conference on Computer and Communications Security (pp. 644-655). ACM.
[98] New York State Department of Financial Services. (2017). Cybersecurity requirements for financial services companies (23 NYCRR Part 500).
[99] Obriki, O. D., & Arumosoye, O. M. (2018). Conceptual modeling of data-driven occupational safety risk control in large-scale energy infrastructure projects. Iconic Research and Engineering Journals, 1(7), 169-189. https://doi.org/10.64388/IREV1I7-1714414
[100] Odejobi, O. D., & Ahmed, K. S. (2018b). Performance evaluation model for multi-tenant Microsoft 365 deployments under high concurrency. IRE Journals, 1(11), 92-107.
[101] Odejobi, O. D., Hammed, N. I., & Ahmed, K. S. (2019). Approximation complexity model for cloud-based database optimization problems. IRE Journals, 2(9), 1-10.
[102] Okonkwo, C. S., Ogunwole, O., Okeke, O. T., & Mayo, W. (2019). Conceptual framework for cost reduction through contract negotiation and vendor governance. Iconic Research and Engineering Journals, 2(9), 468-482. https://doi.org/10.64388/IREV2I9-1713121
[103] Oracle Corporation. (2012). Oracle Advanced Security transparent data encryption best practices [White paper].
[104] Oracle Corporation. (2019). MySQL 8.0 reference manual: InnoDB data-at-rest encryption.
[105] Oracle Corporation. (2019). Oracle Database Advanced Security guide, 19c. Oracle Help Center.
[106] Oshoba, T. O., Hammed, N. I., & Odejobi, O. D. (2019). Secure identity and access management model for distributed and federated systems. IRE Journals, 3(4), 550-567.
[107] PCI Security Standards Council. (2018). Payment Card Industry Data Security Standard: Requirements and security assessment procedures, version 3.2.1.
[108] Popa, R. A., Li, F. H., & Zeldovich, N. (2013). An ideal-security protocol for order-preserving encoding. In Proceedings of the 2013 IEEE Symposium on Security and Privacy (pp. 463-477). IEEE.
[109] Popa, R. A., Redfield, C. M. S., Zeldovich, N., & Balakrishnan, H. (2011). CryptDB: Protecting confidentiality with encrypted query processing. In Proceedings of the 23rd ACM Symposium on Operating Systems Principles (SOSP) (pp. 85-100).
[110] Priebe, C., Vaswani, K., & Costa, M. (2018). EnclaveDB: A secure database using SGX. In Proceedings of the 2018 IEEE Symposium on Security and Privacy (pp. 264-278). IEEE.
[111] Raasveldt, M., Holanda, P., Gubner, T., & Mühleisen, H. (2018). Fair benchmarking considered difficult: Common pitfalls in database performance testing. In Proceedings of the Workshop on Testing Database Systems (DBTest), Article 2. ACM.
[112] Ristenpart, T., Tromer, E., Shacham, H., & Savage, S. (2009). Hey, you, get off of my cloud: Exploring information leakage in third-party compute clouds. In Proceedings of the 16th ACM Conference on Computer and Communications Security (pp. 199-212). ACM.
[113] Rogaway, P., Bellare, M., & Black, J. (2003). OCB: A block-cipher mode of operation for efficient authenticated encryption. ACM Transactions on Information and System Security, 6(3), 365-403.
[114] Scarfone, K., Souppaya, M., & Sexton, M. (2007). Guide to storage encryption technologies for end user devices (NIST Special Publication 800-111). National Institute of Standards and Technology.
[115] Shmueli, E., Vaisenberg, R., Elovici, Y., & Glezer, C. (2009). Database encryption: An overview of contemporary challenges and design considerations. ACM SIGMOD Record, 38(3), 29-34.
[116] Shmueli, E., Vaisenberg, R., Gudes, E., & Elovici, Y. (2014). Implementing a database encryption solution, design and implementation issues. Computers & Security, 44, 33-50.
[117] Song, D. X., Wagner, D., & Perrig, A. (2000). Practical techniques for searches on encrypted data. In Proceedings of the 2000 IEEE Symposium on Security and Privacy (pp. 44-55). IEEE.
[118] Soror, A. A., Minhas, U. F., Aboulnaga, A., Salem, K., Kokosielis, P., & Kamath, S. (2008). Automatic virtual machine configuration for database workloads. In Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data. ACM.
[119] Transaction Processing Performance Council. (2010). TPC Benchmark C standard specification, revision 5.11.
[120] Transaction Processing Performance Council. (2018). TPC Benchmark H standard specification, revision 2.18.
[121] Tu, S., Kaashoek, M. F., Madden, S., & Zeldovich, N. (2013). Processing analytical queries over encrypted data. Proceedings of the VLDB Endowment, 6(5), 289-300.
[122] U.S. Department of Health and Human Services. (2013). HIPAA Security Rule, 45 CFR Part 164, Subpart C.
[123] Uchechi, N., Ominyi, M., Anichukwueze, C. C., & Jones, B. C. (2019). Corporate policy advocacy and regulatory reform: Streamlining statutory bidding workflows in emerging energy markets. Iconic Research and Engineering Journals, 3(5), 672-709. https://doi.org/10.64388/IREV3I5-1722791
[124] Unamma, U. M.-L., Okwesa, I. J., Iwuanyanwu, U., & Ajiga, D. (2018). An offline-first design framework for digital learning in low-connectivity environments. Iconic Research and Engineering Journals, 2(3), 192-211. https://doi.org/10.64388/IREV2I3-1722627
[125] Webster, J., & Watson, R. T. (2002). Analyzing the past to prepare for the future: Writing a literature review. MIS Quarterly, 26(2), xiii-xxiii.
[126] Wikiri, M. (2019). Global technology talent development in emerging markets: A conceptual framework for preparing software professionals for international employment. Iconic Research and Engineering Journals, 3(5), 651-671. https://doi.org/10.64388/IREV3I5-1723088
[127] Wohlin, C. (2014). Guidelines for snowballing in systematic literature studies and a replication in software engineering. In Proceedings of the 18th International Conference on Evaluation and Assessment in Software Engineering (EASE), Article 38. ACM.
[128] Zhu, B., Li, K., & Patterson, H. (2008). Avoiding the disk bottleneck in the Data Domain deduplication file system. In Proceedings of the 6th USENIX Conference on File and Storage Technologies (FAST). USENIX Association.
How to cite this paper
@article{1725089,
author = {Evans Ighodalo, Ayinoluwa Kolawole},
title = {A Systematic Review of Transparent Data Encryption (TDE) Performance Overhead in Regulated Enterprise Database Estates},
journal = {Iconic Research And Engineering Journals},
year = {2019},
volume = {3},
number = {1},
pages = {720-742},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1725089.pdf},
abstract = {Transparent Data Encryption (TDE) has become the default control that banks, insurers, healthcare providers and public bodies use to meet encryption-at-rest obligations under PCI DSS, HIPAA, the GDPR, the NYDFS Cybersecurity Regulation and the Nigeria Data Protection Regulation, yet its performance cost is reported inconsistently, ranging from vendor estimates of a few percent to practitioner accounts of severe disruption. This paper reports a systematic literature review, conducted in 2019 following the Kitchenham and Charters guidelines, of peer-reviewed studies, standards and vendor documentation covering Oracle Database, Microsoft SQL Server, IBM Db2, MySQL and MongoDB, supported by two contextual seed corpora of 50 regional and 50 international studies. The review finds that steady-state overhead is modest on processors with hardware AES acceleration, because TDE encrypts pages at the I/O boundary and keeps plaintext in the buffer cache, but that overhead rises with I/O-intensive workloads, low cache hit ratios, limited CPU headroom, virtualization that hides AES-NI and the loss of downstream compression. The largest costs arise during lifecycle events, namely initial encryption, backup and restore, key rotation and dependence on external key managers. From these findings the paper develops the TDE Performance Overhead Model, which links regulatory drivers and encryption scope to steady-state and lifecycle overhead through seven testable propositions. The evidence base is dominated by vendor sources with few independent measurements, so the paper concludes with a measurement protocol and deployment recommendations for regulated estates and an agenda for empirical research.},
keywords = {AES-NI, conceptual model, database performance, encryption at rest, enterprise database estates, key management, regulatory compliance, systematic literature review, Transparent data encryption},
month = {July},
}