arrow
返回

SQL queries over encrypted databases: a survey

delete2024-03-05
delete1
delete
OA
AI
B
Bo Sun
S
Sen Zhao
G
Guohua Tian *
DOI:10.1080/09540091.2024.2323059delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
Limited by the local storage resource, data users have to encrypt their data and outsource the encrypted databases to cloud servers to enjoy low-cost, professional data management services, which promotes the rapid development of outsourcing database technology. Despite this, the complex underlying setting and loosely coupled database architecture lead to various security risks and performance bottlenecks, while there is currently no work to achieve a comprehensive evaluation of existing encrypted database solutions from the aspects of underlying settings, security levels, functions, etc. In this work, we first propose an evaluation model to assess SQL functionalities and security from multiple dimensions. Secondly, we categorise the existing SQL query schemes into three categories: software-based construction, hardware-based construction, and hybrid-based construction, that is, a combination of software and hardware components. On this basis, we analyse the framework, advantages, and limitations of classic and state-of-the-art schemes. Finally, we summarise the software-based and hardware-based approaches from dimensions of SQL functionality, security, and efficiency, thus clarifying their ideal application scenarios. Notably, SQL query schemes that exhibit minimal equality of pair leakage and support strong obliviousness can achieve higher levels of security. In addition, hardware-based solutions can achieve more complex SQL queries and superior performance without designing complex and functionally-limited cryptographic tools.
Keyword:
SQL queries
encrypted databases
evaluation model

期刊

Connection Science 封面图
Connection Science
IF:
3.4
论文数:
854
被引数:
1.5K

机构

X
Xidian University
学者数:
2.4W
论文数: 1.9W
被引数: 9.7K
引用论文

引用论文

Retrieval of vertical concentration profiles from OSIRIS UV–visible limb spectra通过OSIRIS紫外-可见光临边光谱反演垂直浓度廓线
err2002-03-01
err0
PREAI
errK Strong; B M Joseph; R Dosanjh; I C McDade; C A McLinden; J C McConnell; J Stegman; D P Murtagh; E J Llewellyn
err分享
err收藏
Customer Experience
err
IF0
err2010-01-01
err0
PREAI
errColin Shaw; Qaalfa Dibeehi; Steven Walden
err分享
err收藏
A dynamic actin cytoskeleton is required to prevent constitutive VDAC-dependent MAPK signalling and aberrant lipid homeostasis
err2023-09-01
err0
errOAAI
errJack Davis; Thorsten Meyer; Martin Smolnig; Daniel G.J. Smethurst; Lisa Neuhaus; Jonas Heyden; Filomena Broeskamp; Elizabeth S.M. Edrich; Oskar Knittelfelder; Dagmar Kolb; Tobias von der Haar; Campbell W. Gourlay; Patrick Rockenfeller
err分享
err收藏
Omeprazole provides quicker symptom relief and duodenal ulcer healing than ranitidine
err1990-02-01
err0
PREAI
errR.J. McFarland; M.C. Bateson; J.R.B. Green; D.P. O'Donoghue; M.W. Dronfield; P.W.N. Keeling; G.J. Burke; R.J. Dickinson; D.R. Shreeve; E.M. Peers; P.D.I. Richardson
err分享
err收藏
err
IF0
err
err0
PREAI
err
err分享
err收藏
Analysis of copy number variation by sequencing in fetuses with nuchal translucency thickening
err2020-04-27
err0
errOAAI
errLiubing Lan; Heming Wu; Lingna She; Bosen Zhang; Yanhong He; Dandan Luo; Huaxian Wang; Zhiyuan Zheng
err分享
err收藏
学者 查看更多内容