Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Perimeter

11/20/2009
08:00 AM
Adrian Lane
Adrian Lane
Commentary
50%
50%

Two Ways To Encrypt Your Database

File/operating system level-encryption is actually implemented outside the database engine -- but it's still a form of database encryption. And it's referred to as "transparent" encryption because it doesn't require any changes to the database, or calling an application.

File/operating system level-encryption is actually implemented outside the database engine -- but it's still a form of database encryption. And it's referred to as "transparent" encryption because it doesn't require any changes to the database, or calling an application.In my last post, I introduced transparent database encryption perform as part of the native database technology. This is in contrast to file/OS encryption, which performs encryption tasks as part of the underlying operating system, independent of the database platform.

File/OS encryption works by intercepting the database's writes to disk, encrypting data blocks before storing them. Conversely, data is decrypted as the database requests information from disk. It can be used to encrypt an entire disk or just specific folders where the data is stored. This provides a degree of granularity if you only want to encrypt some portion of the database or a single database instance in a larger installation.

If you are confused that two database encryption technologies with radically different implementations both are considered "transparent," you're not alone. So let's compare and contrast transparent database encryption proper and file/OS encryption.

Both methods protect data stored on disk or media from direct inspection. Both can be easily retrofitted into existing database environments. Both operate seamlessly and do not require modifications to the database structure, queries, or calling application platform to use. Both offer industry-standard encryption algorithms and optional external key-management support. And perhaps most importantly, both are acceptable for many compliance mandates, such as PCI.

So when deciding which one to adopt, you should consider:

Ease of deployment: OS or file-level encryption is installed as a component of the operating system, requiring a software installation, configuration, possibly a recompilation of the kernel, and a system reboot. Database transparent encryption gets the edge in simplicity as it usually only involves changing some of the database configuration and, as worst, a database restart. In the big picture, both are simple operations.

Performance: My experience shows both are very close. Informal testing and feedback from several clients indicate database transparent encryption hovers around 6 percent overhead for typical environments. File/OS layer encryption was around 3 percent overhead, giving the external variant a slight edge. This is not a scientific evaluation and can vary a lot given how the database is used, but the distinction is somewhat irrelevant as both offer satisfactory performance.

Vendor Association: Let's face it, trust in the vendor and ability to haggle on price play a part as well. Many firms have a long-standing relationship with their database vendor and trust their products -- not to say file/OS is less reliable, but established trust is a big deal to many firms I speak with. Couple that with customers leveraging pricing and support as a bundle, and discounted pricing wins many customers over.

Versatility. Odds are you have multiple security and compliance issues to address, and being able to leverage a single investment to solve multiple security problems is a big advantage. As file/OS products encrypt general files as well as database contents, you can secure nondatabase content. This single product can be used for multiple purposes with a single, unified interface. And for companies that run more than one type of database, file/OS options give a unified approach to database encryption. The file/OS options provide a breadth of coverage with greater flexibility.

Adrian Lane is an analyst/CTO with Securosis LLC, an independent security consulting practice. Special to Dark Reading. Adrian Lane is a Security Strategist and brings over 25 years of industry experience to the Securosis team, much of it at the executive level. Adrian specializes in database security, data security, and secure software development. With experience at Ingres, Oracle, and ... View Full Bio

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
Mobile Banking Malware Up 50% in First Half of 2019
Kelly Sheridan, Staff Editor, Dark Reading,  1/17/2020
7 Tips for Infosec Pros Considering A Lateral Career Move
Kelly Sheridan, Staff Editor, Dark Reading,  1/21/2020
For Mismanaged SOCs, The Price Is Not Right
Kelly Sheridan, Staff Editor, Dark Reading,  1/22/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon Contest
Write a Caption, Win a Starbucks Card! Click Here
Latest Comment:   It's a PEN test of our cloud security.
Current Issue
IT 2020: A Look Ahead
Are you ready for the critical changes that will occur in 2020? We've compiled editor insights from the best of our network (Dark Reading, Data Center Knowledge, InformationWeek, ITPro Today and Network Computing) to deliver to you a look at the trends, technologies, and threats that are emerging in the coming year. Download it today!
Flash Poll
How Enterprises are Attacking the Cybersecurity Problem
How Enterprises are Attacking the Cybersecurity Problem
Organizations have invested in a sweeping array of security technologies to address challenges associated with the growing number of cybersecurity attacks. However, the complexity involved in managing these technologies is emerging as a major problem. Read this report to find out what your peers biggest security challenges are and the technologies they are using to address them.
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2019-3697
PUBLISHED: 2020-01-24
UNIX Symbolic Link (Symlink) Following vulnerability in the packaging of gnump3d in openSUSE Leap 15.1 allows local attackers to escalate from user gnump3d to root. This issue affects: openSUSE Leap 15.1 gnump3d version 3.0-lp151.2.1 and prior versions.
CVE-2019-3694
PUBLISHED: 2020-01-24
A Symbolic Link (Symlink) Following vulnerability in the packaging of munin in openSUSE Factory, Leap 15.1 allows local attackers to escalate from user munin to root. This issue affects: openSUSE Factory munin version 2.0.49-4.2 and prior versions. openSUSE Leap 15.1 munin version 2.0.40-lp151.1.1 a...
CVE-2019-3693
PUBLISHED: 2020-01-24
A symlink following vulnerability in the packaging of mailman in SUSE SUSE Linux Enterprise Server 11, SUSE Linux Enterprise Server 12; openSUSE Leap 15.1 allowed local attackers to escalate their privileges from user wwwrun to root. Additionally arbitrary files could be changed to group mailman. Th...
CVE-2019-3687
PUBLISHED: 2020-01-24
The permission package in SUSE SUSE Linux Enterprise Server allowed all local users to run dumpcap in the "easy" permission profile and sniff network traffic. This issue affects: SUSE SUSE Linux Enterprise Server permissions versions starting from 85c83fef7e017f8ab7f8602d3163786d57344439 t...
CVE-2019-3692
PUBLISHED: 2020-01-24
The packaging of inn on SUSE SUSE Linux Enterprise Server 11; openSUSE Factory, Leap 15.1 allows local attackers to escalate from user inn to root via symlink attacks. This issue affects: SUSE SUSE Linux Enterprise Server 11 inn version 2.4.2-170.21.3.1 and prior versions. openSUSE Factory inn versi...