Re: searching for encrypted fields in data columns

<sffan_at_hotmail.com> wrote in message news:4042F2DF.6080800_at_hotmail.com...

> Does any database provide native facilities to store specific columns as
> encrypted data ? The other option I have is to use something like RC4 to
> encrypt the data before storing them in the database.
>
> However, the subsequent problem is how do I search/sort on these columns
> ? Its not a big deal if I have a few hundred records; I could
> potentially retrieve all the records, decrypt the specific fields and
> then do in process searches/sorts. But what happens when I have (say) a
> million records - I really don't want to suck in all that data and work
> on it but instead use the native db search/sort capabilities.
>
>

PointBase is a Java database that supports data encryption in a way that is transparent to the user. It supports several encryption algorithm implementations you can choose from. You just use a database parameter to set the algorithm and the key and data encryption/decryption is handled with no futher attention from you. If you use the Server version, you can also encrypt the communication between the client and the server. Received on Wed Mar 03 2004 - 17:59:10 CST