Encrypt 1.5 million records and decrypting.

[manohars]

Hi,

I have a requirement, where the database data should be encrypted during storing and decrypted during retrieving. What are the ways or tools available for this. Also, kindly let me know of the ways to improve performance in this case. I urgently need these information.

Thanks in Advance,
Manohar

 

[hmckillop]

Have a look at following links, most encryption use an API prior to insertion of the database, and these calls into the API then decrypt or encrypt the data.

http://www.netlib.com/sql-server-encryption.shtml

http://www.safelogic.com/en_safejdbc_technical_brief.pdf

the simplest of this way of encrypting data using .NET architecture is

http://www.devx.com/dbzone/Article/26726

http://www.windowsitpro.com/Article/ArticleID/44550/44550.html

there is always a performance overhead as at some stage the data needs to go through an algorithm to encrypt it, also the actual storage of the data will increase as generally you will need binary field types to store the encrypted data.

Also things to watch for, when encrypting data is making sure you only encrypt what you need, not just for performance, but also encrypted data is very hard to manage when you require searches. But all this should be explained on the different sites.


The last article listed above is probably the 1st you should read as it reviews some commercial sofwtare alternatives.,


"I'm living so far beyond my income that we may almost be said to be living apart