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

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

doi:10.1155/2018/7383514

Cited by 10 publications

(7 citation statements)

References 36 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Meanwhile, [30]- [33] have relied on a combination of encryption schemes to prevent data breaches. They depend on the concept that no single cryptosystem can support all types of queries.…”

Section: A Related Workmentioning

confidence: 99%

Using Blockchain in Cloud Computing to Enhance Relational Database Security

Awadallah¹,

Samsudin

2021

IEEE Access

View full text Add to dashboard Cite

Cloud computing has now become a very standardised concept in our society. However, many modern applications need a better level of security that includes saving data from internal breaches. Thus, cloud databases need effective security mechanisms to keep track of data modifications. This paper will introduce the enhanced structure of cloud relational database (RDB) based on blockchain technology (BC) named BC over cloud-RDB. To provide the client with an effective self-verification process to detect and prevent erroneous manipulation of RDBs. We proposed two systems to improve cloud-RDB: agile BCbased RDB and secure BC-based RDB. Both are distributed among several cloud service providers based on the Byzantine Fault Tolerance consensus. Additionally, both rely on linking records to each other using the SHA-256. At the same time, secure BC-based RDB uses a proof-of-work consensus to make data offensive operation impossible. Based on both systems' performance and security analysis, the agile BC-based RDB is highly suggested for the high throughput database. On the other hand, the secure BC-based RDB is recommended for RDB that contains sensitive data and low throughput performance. The improved RDB is flexible and can be operated based on the data owner's specifications.

show abstract

“…Meanwhile, [30]- [33] have relied on a combination of encryption schemes to prevent data breaches. They depend on the concept that no single cryptosystem can support all types of queries.…”

Section: A Related Workmentioning

confidence: 99%

Using Blockchain in Cloud Computing to Enhance Relational Database Security

Awadallah¹,

Samsudin

2021

IEEE Access

View full text Add to dashboard Cite

show abstract

“…Liu et al [28] proposed a fully homomorphic orderpreserving encryption system (FHOPE) to execute complex SQL queries over encrypted numeric data. This system allows cloud providers to run arithmetic and comparison operators over encrypted data without repeating the encryption, thus helping to resist homomorphic order-preserving attacks.…”

Section: ) Current Approaches To Process Sql Queries Over Encrypted Databasesmentioning

confidence: 99%

An Efficient Secure System for Fetching Data From the Outsourced Encrypted Databases

et al. 2021

View full text Add to dashboard Cite

Recently, database users have begun to use cloud database services to outsource their databases. The reason for this is the high computation speed and the huge storage capacity that cloud owners provide at low prices. However, despite the attractiveness of the cloud computing environment to database users, privacy issues remain a cause for concern for database owners since data access is out of their control. Encryption is the only way of assuaging users' fears surrounding data privacy, but executing Structured Query Language (SQL) queries over encrypted data is a challenging task, especially if the data are encrypted by a randomized encryption algorithm. Many researchers have addressed the privacy issues by encrypting the data using deterministic, onion layer, or homomorphic encryption. Nevertheless, even with these systems, the encrypted data can still be subjected to attack. In this research, we first propose an indexing scheme to encode the original table's tuples into bit vectors (BVs) prior to the encryption. The resulting index is then used to narrow the range of retrieved encrypted records from the cloud to a small set of records that are candidates for the user's query. Based on the indexing scheme, we then design a system to execute SQL queries over the encrypted data. The data are encrypted by a single randomized encryption algorithm, namely the Advanced Encryption Standard-Cipher-Block Chaining (AES-CBC). In the proposed scheme, we store the index values (BVs) at user's side , and we extend the system to support most of relational algebra operators, such as select, join, etc. Implementation and evaluation of the proposed system reveals that it is practical and efficient at reducing both the computation and space overhead when compared with state-of-the-art systems like CryptDB.

show abstract

“…However, Wong et al's scheme does not consider the problem of multi-user key updates. Liu et al [14] proposed a practical and secure homomorphic order-preserving encryption (FHOPE) scheme to solve efficiency problems associated with multiple encryption combinations. FHOPE allows cloud servers to perform complex SQL queries with different operators on encrypted data without repeated encryption.…”

Section: Related Workmentioning

confidence: 99%

A Multi-user Shared Searchable Encryption Scheme Supporting SQL Query

Jia

2021

Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering

View full text Add to dashboard Cite

Due to the tremendous benefits of cloud computing, organizations are highly motivated to store electronic records on clouds. However, outsourcing data to cloud servers separates it from physical control, resulting in data privacy disclosure. Although encryption enhances data confidentiality, it also complicates the execution of encrypted database operations. In this paper, we propose a multi-user shared searchable encryption scheme that supports multi-user selective authorization and secure access to encrypted databases. First, we apply the Diffie-Hellman protocol to a trapdoor generate algorithm to facilitate fine-grained search control without incremental conversions. Second, we utilize a private key to generate an encrypted index by bilinear mapping, which makes it impossible for an adversary to obtain trapdoor keywords by traversing the keyword space and to carry out keyword guessing attacks. Third, we use double-layered encryption to encrypt a symmetric decryption key. Only the proxies whose attributes are matched with access control list can obtain the key of decrypted data. Through theoretical security analysis and experimental verifications, we show that our scheme can provide secure and efficacious ciphertext retrieval without the support of a secure channel.

show abstract

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

Cited by 10 publications

References 36 publications

Using Blockchain in Cloud Computing to Enhance Relational Database Security

Using Blockchain in Cloud Computing to Enhance Relational Database Security

An Efficient Secure System for Fetching Data From the Outsourced Encrypted Databases

A Multi-user Shared Searchable Encryption Scheme Supporting SQL Query

Contact Info

Product

Resources

About