Title: A novel approach for query over encrypted data in database

Authors: Jaafer Al-Saraireh

Addresses: Princess Sumaya University for Technology, Amman, 11941, Jordan

Abstract: Database management is considered an essential component of many information systems to store data. Some database system contains secure data; these data are protected by using encryption techniques. The query performance is affected by encryption techniques. Therefore; should be a balance between the security and performance. A new technique in this research work has been proposed to enhance the query performance over the encrypted fields in a database system. This technique is based on producing a unique hash value for each secure data and transforms the SQL query into an appropriate formula to be executed over the hash value fields. The proposed approach has eliminated any statistical relationship between encrypted and hash value fields. The time of execution encryption/decryption is reduced to enhance the performance of the query over encrypted secure data in the proposed technique. A set of experiments are carried out, and the results indicate that the performance of SQL-query is enhanced by reducing the average response time to 14 compared with others related approaches.

Keywords: SQL; hash value; secure data; database; security; encryption.

DOI: 10.1504/IJICS.2019.103083

International Journal of Information and Computer Security, 2019 Vol.11 No.6, pp.621 - 636

Received: 21 Apr 2017
Accepted: 23 Feb 2018

Published online: 15 Oct 2019 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article