Database Encryption
Am developing a 2-tier system, with mySQL DBMS. I need to encrypt data before i save to the database.
Q1)Do i need an input/output stream or the normal data transfer is ok
Q2)Which are the encryption basic classes in other than to Cipher and KeyGenerator?
Q3) does it mean that i'll put all datatypes at the database level as varchar, due to the fact that after encryption i expect all manner of characters?
I am new to data encryption and will appreciate your help.
[498 byte] By [
Shikoa] at [2007-11-26 19:38:26]
# 1
Take a look at StrongKey, an open-source Symmetric Key Management System software. It includes a utility called "xenc" which preforms column-level database encryption.
This PDF document (http://www.strongkey.org/index.php?option=com_content&task=view&id=48&Itemid=35) provides some information on how to deal with database encryption (when using StrongKey), the impact on the schema, etc.
# 2
> Take a look at StrongKey, an open-source Symmetric
> Key Management System software. It includes a
> utility called "xenc" which preforms column-level
> database encryption.
>
> This PDF document
> (http://www.strongkey.org/index.php?option=com_content
> &task=view&id=48&Itemid=35) provides some information
> on how to deal with database encryption (when using
> StrongKey), the impact on the schema, etc.
Thanks a bunch! I hope it works.
# 3
You could also have a look at Jasypt ( http://www.jasypt.org), which will ease your encryption tasks and, if you are using Hibernate, integrate transparently for database encryption.Regards,Daniel.
