Framework for Searchable Encryption with SQL Databases

Monir Azraoui, Melek Önen, Refik Molva

2018

Abstract

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.

Paper Citation

in Harvard Style

Azraoui M., Önen M. and Molva R. (2018). Framework for Searchable Encryption with SQL Databases.In Proceedings of the 8th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER, ISBN 978-989-758-295-0, pages 57-67. DOI: 10.5220/0006666100570067

in Bibtex Style

@conference{closer18,
author={Monir Azraoui and Melek Önen and Refik Molva},
title={Framework for Searchable Encryption with SQL Databases},
booktitle={Proceedings of the 8th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,},
year={2018},
pages={57-67},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006666100570067},
isbn={978-989-758-295-0},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 8th International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,
TI - Framework for Searchable Encryption with SQL Databases
SN - 978-989-758-295-0
AU - Azraoui M.
AU - Önen M.
AU - Molva R.
PY - 2018
SP - 57
EP - 67
DO - 10.5220/0006666100570067