A Novel Secure Scheme for Supporting Complex SQL Queries over Encrypted Databases in Cloud Computing

المؤلفون المشاركون

Dai, Hua
Wang, Huaqun
Liu, Guoxiu
Xiang, Yang
Yang, Geng

المصدر

Security and Communication Networks

العدد

المجلد 2018، العدد 2018 (31 ديسمبر/كانون الأول 2018)، ص ص. 1-15، 15ص.

الناشر

Hindawi Publishing Corporation

تاريخ النشر

2018-07-03

دولة النشر

مصر

عدد الصفحات

15

التخصصات الرئيسية

تكنولوجيا المعلومات وعلم الحاسوب

الملخص 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.

نمط استشهاد جمعية علماء النفس الأمريكية (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

نمط استشهاد الجمعية الأمريكية للغات الحديثة (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

نمط استشهاد الجمعية الطبية الأمريكية (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

نوع البيانات

مقالات

لغة النص

الإنجليزية

الملاحظات

Includes bibliographical references

رقم السجل

BIM-1214348