Paper 2021/852 Original: eprint.iacr.org/2021/852 ↗
Improved Structured Encryption for SQL Databases via Hybrid Indexing
Abstract
We introduce a new technique for indexing joins in encrypted SQL databases called partially precomputed joins which achieves lower leakage and bandwidth than those used in prior constructions. These techniques are incorporated into state-of-the-art structured encryption schemes for SQL data, yielding a hybrid indexing scheme with both partially and fully precomputed join indexes. We then introduce the idea of leakage-aware query planning by giving a heuristic that helps the client decide, at query time, which index to use so as to minimize leakage and stay below a given bandwidth budget. We conclude by simulating our constructions on real datasets, showing that our heuristic is accurate and that partially-precomputed joins perform well in practice.
Metadata
- Available format(s)
PDF- Category
- Cryptographic protocols
- Publication info
- Preprint.
- History
- 2021-06-22: last updated
- 2021-06-22: published
- Short URL
- https://ia.cr/2021/852
- License
- https://creativecommons.org/licenses/by/4.0/
BibTeX
@misc{cryptoeprint:2021/852,
author = {David Cash and Ruth Ng and Adam Rivkin},
title = {Improved Structured Encryption for SQL Databases via Hybrid Indexing},
howpublished = {Cryptology {ePrint} Archive, Paper 2021/852},
year = {2021},
url = {https://eprint.iacr.org/2021/852}
}