170944

Securing Query results for Cloud Databases

Article

Last updated: 03 Jan 2025

Subjects

-

Tags

-

Abstract

Cloud computing offers several computing service. Among these services is the Database Service, which stores outsourced databases and provides all the database services to users. However, despite, the attractiveness of the database services to users, security issues remain a main concern to database owners, as the data and the execution of database is out of their control. To ensure the outsourced database confidentiality and integrity, which are two of the most important security concerns in data outsourcing, we propose the design and implementation of an efficient Secure scheme to provide Confidentiality and Integrity of Query results for Cloud Databases based on Merkle B-Tree (SCIQ-CD). We develop a technique to convert the Merkle B-Tree into data authentication tables and store it within the relational database in DSP. We have implement query rewrite algorithms for trusted third party to generate the SQL statements to speed up the query processing, which will be sent within the query by the user to DSP. The performance analysis shows that our proposed scheme is secure and efficient for practical deployment. The experimental results show that our scheme imposes a low overhead for queries executions with confidentiality and integrity assurance.

DOI

10.21608/ijicis.2021.71016.1081

Keywords

Cloud Database, confidentiality, Integrity, Merkle B-Tree

Authors

First Name

Mai

Last Name

Rady

MiddleName

Mustafa

Affiliation

Information System Department, Faculty of Computer and Information Technology, Ain Shams University, Cairo, Egypt

Email

mai.mustafa.rady@gmail.com

City

-

Orcid

0000-0002-9448-6640

First Name

Tamer

Last Name

Mostafa

MiddleName

-

Affiliation

Vice Dean for Community Service and Environmental Development, Faculty of computer and Information Sciences, Ain Shams University

Email

tammabde@cis.asu.edu.eg

City

-

Orcid

0000-0003-4060-2535

First Name

Rasha

Last Name

Ismail

MiddleName

-

Affiliation

Vice Dean for Postgraduate Studies & Research, Faculty of Computer and Information Sciences, Ain Shams University

Email

rashaismail@cis.asu.edu.eg

City

-

Orcid

0000-0003-3581-8112

Volume

21

Article Issue

1

Related Issue

21725

Issue Date

2021-02-01

Receive Date

2021-04-04

Publish Date

2021-03-03

Page Start

104

Page End

118

Print ISSN

1687-109X

Online ISSN

2535-1710

Link

https://ijicis.journals.ekb.eg/article_170944.html

Detail API

https://ijicis.journals.ekb.eg/service?article_code=170944

Order

9

Type

Original Article

Type Code

494

Publication Type

Journal

Publication Title

International Journal of Intelligent Computing and Information Sciences

Publication Link

https://ijicis.journals.ekb.eg/

MainTitle

Securing Query results for Cloud Databases

Details

Type

Article

Created At

22 Jan 2023