It may be time to protect your data where it lives–in your database.
But you can’t encrypt everything in your database. Indexed fields, for example, can’t be encrypted because your database-management software will sort the encrypted strings in hexadecimal values, which won’t match the real, unencrypted form. So your index, which is supposed to speed access to the data by preordering it, won’t work. Even if you could relate the encrypted index field to the original data, the collation order wouldn’t match.
Until databases support encryption natively, encrypted indices will be a problem. Remember that any indices generated from encrypted fields won’t be valid, either. And because these fields don’t relate to the actual data, it’ll be harder for the database administrator and developer to debug problems.
Database software, such as Sybase’s, lets you create encrypted databases.
Ingrian Networks’ DataSecure Platform, which lets you encrypt certain fields before you enter them in the database and automatically decrypts them on the way out, has been around for a couple of years.
Bottom line: When building your disk capacity for database encryption, anticipate that your data will triple or quadruple in size.
More info: [url=http://www.securitypipeline.com/story/showArticle.jhtml?articleID=16600160]http://www.securitypipeline.com/story/showArticle.jhtml?articleID=16600160[/url]