A Novel Secure Scheme for Supporting Complex SQL Queries over Encrypted Databases in Cloud Computing
Joint Authors
Dai, Hua
Wang, Huaqun
Liu, Guoxiu
Xiang, Yang
Yang, Geng
Source
Security and Communication Networks
Issue
Vol. 2018, Issue 2018 (31 Dec. 2018), pp.1-15, 15 p.
Publisher
Hindawi Publishing Corporation
Publication Date
2018-07-03
Country of Publication
Egypt
No. of Pages
15
Main Subjects
Information Technology and Computer Science
Abstract EN
With the advance of database-as-a-service (DaaS) and cloud computing, increasingly more data owners are motivated to outsource their data to cloud database for great convenience and economic savings.
Many encryption schemes have been proposed to process SQL queries over encrypted data in the database.
In order to obtain the desired data, the SQL queries contain some statements to describe the requirement, e.g., arithmetic and comparison operators (+, -, ×, <, >, and =).
However, to support different operators (+, -, ×, <, >, and =) in SQL queries over encrypted data, multiple encryption schemes need to be combined and adjusted to work together.
Moreover, repeated encryptions will reduce the efficiency of execution.
This paper presents a practical and secure homomorphic order-preserving encryption (FHOPE) scheme, which allows cloud server to perform complex SQL queries that contain different operators (such as addition, multiplication, order comparison, and equality checks) over encrypted data without repeated encryption.
These operators are data interoperable, so they can be combined to formulate complex SQL queries.
We conduct security analysis and efficiency evaluation of the proposed scheme FHOPE.
The experiment results show that, compared with the existing approaches, the FHOPE scheme incurs less overhead on computation and communication.
It is suitable for large batch complex SQL queries over encrypted data in cloud environment.
American Psychological Association (APA)
Liu, Guoxiu& Yang, Geng& Wang, Huaqun& Xiang, Yang& Dai, Hua. 2018. A Novel Secure Scheme for Supporting Complex SQL Queries over Encrypted Databases in Cloud Computing. Security and Communication Networks،Vol. 2018, no. 2018, pp.1-15.
https://search.emarefa.net/detail/BIM-1214348
Modern Language Association (MLA)
Liu, Guoxiu…[et al.]. A Novel Secure Scheme for Supporting Complex SQL Queries over Encrypted Databases in Cloud Computing. Security and Communication Networks No. 2018 (2018), pp.1-15.
https://search.emarefa.net/detail/BIM-1214348
American Medical Association (AMA)
Liu, Guoxiu& Yang, Geng& Wang, Huaqun& Xiang, Yang& Dai, Hua. A Novel Secure Scheme for Supporting Complex SQL Queries over Encrypted Databases in Cloud Computing. Security and Communication Networks. 2018. Vol. 2018, no. 2018, pp.1-15.
https://search.emarefa.net/detail/BIM-1214348
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references
Record ID
BIM-1214348