IntegriDB: Verifiable SQL for Outsourced Databases

被引:57
|
作者
Zhang, Yupeng [1 ,2 ]
Katz, Jonathan [2 ,3 ]
Papamanthou, Charalampos [1 ,2 ]
机构
[1] Univ Maryland, ECE Dept, College Pk, MD 20742 USA
[2] Univ Maryland, UMIACS, College Pk, MD 20742 USA
[3] Univ Maryland, CS Dept, College Pk, MD 20742 USA
关键词
Verifiable Computation; Authenticated Data Structures;
D O I
10.1145/2810103.2813711
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
This paper presents INTEGRIDB, a system allowing a data owner to outsource storage of a database to an untrusted server, and then enable anyone to perform verifiable SQL queries over that database. Our system handles a rich subset of SQL queries, including multidimensional range queries, JOIN, SUM, MAX/MIN, COUNT, and AVG, as well as (limited) nestings of such queries. Even for tables with 1 0 5 entries, INTEGRIDB has small proofs (a few KB) that depend only logarithmically on the size of the database, low verification time (tens of milliseconds), and feasible server computation (under a minute). Efficient updates are also supported. We prove security of INTEGRIDB based on known cryptographic assumptions, and demonstrate its practicality and expressiveness via performance measurements and verifiable processing of SQL queries from the TPC-H and TPC-C benchmarks.
引用
收藏
页码:1480 / 1491
页数:12
相关论文
共 50 条
  • [21] Verifiable Pattern Matching on Outsourced Texts
    Catalano, Dario
    Di Raimondo, Mario
    Faro, Simone
    [J]. SECURITY AND CRYPTOGRAPHY FOR NETWORKS, SCN 2016, 2016, 9841 : 333 - 350
  • [22] Analysis of an ABE Scheme with Verifiable Outsourced Decryption
    Liao, Yongjian
    He, Yichuan
    Li, Fagen
    Jiang, Shaoquan
    Zhou, Shijie
    [J]. SENSORS, 2018, 18 (01):
  • [23] Towards Verifiable Resource Accounting for Outsourced Computation
    Chen, Chen
    Maniatis, Petros
    Perrig, Adrian
    Vasudevan, Amit
    Sekar, Vyas
    [J]. ACM SIGPLAN NOTICES, 2013, 48 (07) : 167 - 178
  • [24] Verifiable Auditing for Outsourced Database in Cloud Computing
    Wang, Jianfeng
    Chen, Xiaofeng
    Huang, Xinyi
    You, Ilsun
    Xiang, Yang
    [J]. IEEE TRANSACTIONS ON COMPUTERS, 2015, 64 (11) : 3293 - 3303
  • [25] Batch Verifiable Computation of Polynomials on Outsourced Data
    Zhang, Liang Feng
    Safavi-Naini, Reihaneh
    [J]. COMPUTER SECURITY - ESORICS 2015, PT II, 2015, 9327 : 167 - 185
  • [26] Publicly Verifiable Outsourced Database with Full Delegations
    全委托的公共可验证的外包数据库方案
    [J]. Zhou, Fu-Cai (fczhou@mail.neu.edu.cn), 1600, Chinese Academy of Sciences (32): : 3901 - 3916
  • [27] Verifiable outsourced computation over encrypted data
    Yu, Xixun
    Yan, Zheng
    Zhang, Rui
    [J]. INFORMATION SCIENCES, 2019, 479 : 372 - 385
  • [28] SQL Ledger: Cryptographically Verifiable Data in Azure SQL Database
    Antonopoulos, Panagiotis
    Kaushik, Raghav
    Kodavalla, Hanuma
    Aceves, Sergio Rosales
    Wong, Reilly
    Anderson, Jason
    Szymaszek, Jakub
    [J]. SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 2437 - 2449
  • [29] AssureMR: Verifiable SQL Execution on MapReduce
    Zhang, Bo
    Dong, Boxiang
    Wang, Wendy Hui
    [J]. 2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2018, : 1228 - 1231
  • [30] ANONYMOUS AND VERIFIABLE REGISTRATION IN DATABASES
    BRANDT, J
    DAMGARD, IB
    LANDROCK, P
    [J]. LECTURE NOTES IN COMPUTER SCIENCE, 1988, 330 : 167 - 176