加密字段全文搜索,最佳方法? [英] Encrypted Fields & Full Text Search, Best Approach?
问题描述
我有一些字段,用于存储便条和敏感信息,这些信息在进入数据库之前需要进行加密.
I've got some fields that store notes and sensitive information that I'd like to encrypt before it makes its way into the database.
现在,我使用SQL全文本搜索来搜索这些字段.显然,对这些数据进行加密将使我的搜索结果失败.
Right now, I use a SQL Full-Text Search to search these fields. Obviously encrypting this data is going to throw off my search results.
加密这些字段的最佳方法是什么,但仍然允许搜索?
What's the best way to encrypt these fields, but still allow searching?
推荐答案
这并不容易.您所描述的内容很少在商业数据库中实现,尽管该领域有一些理论结果.我建议您去谷歌学者,然后开始寻找有关该主题的论文.
It's not going to be easy. What you're describing is rarely implemented in commercial databases, although there are some theoretical results in the field. I'd suggest that you go to google scholar and start looking for papers on the subject.
以下是一些入门指南:
- 黎明Xiaodong Song,David Wagner和Adrian Perrig. 用于 搜索加密数据.
- R. Brinkman,L.Feng,J.Doumen,P.H. Hartel和W. Jonke.加密数据中的有效树搜索.在信息系统安全中,第126-135页,2004年 .
- D Boneh,G Di Crescenzo,R Ostrovsky和G Persiano. 使用关键字搜索"进行公钥加密
- P Golle,J Staddon,B Waters. 对加密数据进行安全的联合关键字搜索.. li>
- Dawn Xiaodong Song, David Wagner, and Adrian Perrig. Practical techniques for searches on encrypted data.
- R. Brinkman, L. Feng, J. Doumen, P.H. Hartel, and W. Jonke. Efficient Tree Search in Encrypted Data. In Security In Information Systems, pages 126-135, 2004.
- D Boneh, G Di Crescenzo, R Ostrovsky, G Persiano. Public Key Encryption with keyword Search
- P Golle, J Staddon, B Waters. Secure Conjunctive Keyword Search over Encrypted Data.
这篇关于加密字段全文搜索,最佳方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!