Optimal re-encryption strategy for joins in encrypted databases

  • Authors:
  • Florian Kerschbaum;Martin Härterich;Patrick Grofig;Mathias Kohler;Andreas Schaad;Axel Schröpfer;Walter Tighzert

  • Affiliations:
  • SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany;SAP Applied Research, Karlsruhe, Germany

  • Venue:
  • DBSec'13 Proceedings of the 27th international conference on Data and Applications Security and Privacy XXVII
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

In order to perform a join in a deterministically, adjustably encrypted database one has to re-encrypt at least one column. The problem is to select that column that will result in the minimum number of re-encryptions even under an unknown schedule of joins. Naive strategies may perform too many or even infinitely many re-encryptions. We provide two strategies that allow for a much better performance. In particular the asymptotic behavior is O(n3/2) resp. O(n logn) re-encryptions for n columns. We show that there can be no algorithm better than O(n logn). We further extend our result to element-wise re-encryptions and show experimentally that our algorithm results in the optimal cost in 41% of the cases.