CODEWITHSUNDEEP
databasesearchencryption
Mohammad
Mohammad

Reputation: 41

Search in encrypted fields without decrypting the field

I want to encrypt my data before save them in my database.

One of my fields is a numeric value and I want to search in the table items upper or lower than a specified item. For example I save my data 3287 encoded, and I want to find which items has value upper than 500.

In the case of huge rows (For example 100,000,000 rows) it is too inefficient to decrypt each element and check the value.

Is there any better solution for my problem?

Upvotes: 1

Views: 449

Answers (1)

user246672
user246672

Reputation:

Old Q but maybe you wanted an encrypted database index. For something FOSS that front-ends MySQL and Postgres, check out CryptDB. Supports some homomorphic encryption and much more. Paper Another paper MSFT arguable crack

For encrypted full-text search Hitachi Credeon is built on Solr. It uses homomorphic encryption IIRC.

There's also the NSA's project on Apache which is likely deployed on a massive scale to search everyone's underwear drawer and pr0n collection... it's basically CouchBase meets Solr.

Upvotes: 1

Related Questions