Title: Cryptographic key management scheme for supporting multi-user SQL queries over encrypted databases

Authors: K. Srinivasa Reddy; S. Ramachandram

Addresses: Department of Computer Science and Engineering, Osmania University, Hyderabad-500007, Telangana, India ' Department of Computer Science and Engineering, Osmania University, Hyderabad-500007, Telangana, India

Abstract: Database outsourcing is getting more popular bringing in a new standard, called database-as-a-service, where an organisation's database is stored in cloud. In such a setting, both access control and data confidentiality plays an important role, particularly when a data owner likes to publish his data for external use. Any cloud provider promises the security of its platform, while the execution of solutions to ensure confidentiality of the data stored in cloud databases is left to the data owner. The state-of-the-art solutions deal few preliminary issues with aid of SQL queries on encrypted data. In this paper, we propose a novel cryptographic key management scheme that combines data encryption and key management and supports multi-user SQL queries over encrypted databases. Our approach shows the proposed solutions for enforcing access control and for ensuring confidentiality of data. The experimental results obtained in this paper show the performance of proposed scheme.

Keywords: data confidentiality; access control; key derivation; encryption; metadata.

DOI: 10.1504/IJCAET.2020.10027753

International Journal of Computer Aided Engineering and Technology, 2020 Vol.12 No.4, pp.461 - 479

Received: 28 Feb 2017
Accepted: 01 Jan 2018

Published online: 29 May 2020 *

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