Graduate School and Research Center in Digital Sciences

Framework for searchable encryption with SQL databases

Azraoui, Monir; Önen, Melek; Molva, Refik

CLOSER 2018, 8th International Conference on Cloud Computing and Services Science, March 19-21, 2018, Funchal, Madeira, Portugal

In recent years, the increasing popularity of outsourcing data to third-party cloud servers sparked a major concern towards data breaches. A standard measure to thwart this problem and to ensure data confidentiality is data encryption. Nevertheless, organizations that use traditional encryption techniques face the challenge of how to enable untrusted cloud servers perform search operations while the actually outsourced data remains confidential. Searchable encryption is a powerful tool that attempts to solve the challenge of querying data outsourced at untrusted servers while preserving data confidentiality. Whereas the literature mainly considers searching over an unstructured collection of files, this paper explores methods to execute SQL queries over encrypted databases. We provide a complete framework that supports private search queries over encrypted SQL databases, in particular for PostgreSQL and MySQL databases. We extend the solution for searchable encryption designed by Curtmola et al., to the case of SQL databases. We also provide features for evaluating range and boolean queries. We finally propose a framework for implementing our construction, validating its practicality.

Document Bibtex

Title:Framework for searchable encryption with SQL databases
Keywords:Searchable Encryption, SQL Database, Data Confidentiality
Type:Conference
Language:English
City:Funchal
Country:PORTUGAL
Date:
Department:Digital Security
Eurecom ref:5418
Copyright: © Springer. Personal use of this material is permitted. The definitive version of this paper was published in CLOSER 2018, 8th International Conference on Cloud Computing and Services Science, March 19-21, 2018, Funchal, Madeira, Portugal and is available at :
Bibtex: @inproceedings{EURECOM+5418, year = {2018}, title = {{F}ramework for searchable encryption with {SQL} databases}, author = {{A}zraoui, {M}onir and {\"{O}}nen, {M}elek and {M}olva, {R}efik}, booktitle = {{CLOSER} 2018, 8th {I}nternational {C}onference on {C}loud {C}omputing and {S}ervices {S}cience, {M}arch 19-21, 2018, {F}unchal, {M}adeira, {P}ortugal}, address = {{F}unchal, {PORTUGAL}}, month = {03}, url = {http://www.eurecom.fr/publication/5418} }
See also: