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 条
  • [1] Verifiable Set Operations over Outsourced Databases
    Canetti, Ran
    Paneth, Omer
    Papadopoulos, Dimitrios
    Triandopoulos, Nikos
    [J]. PUBLIC-KEY CRYPTOGRAPHY - PKC 2014, 2014, 8383 : 113 - 130
  • [2] Publicly Verifiable Conjunctive Keyword Search in Outsourced Databases
    Azraoui, Monir
    Elkhiyaoui, Kaoutar
    Onen, Melek
    Molva, Refik
    [J]. 2015 IEEE CONFERENCE ON COMMUNICATIONS AND NETWORK SECURITY (CNS), 2015, : 619 - 627
  • [3] Processing secure, verifiable and efficient SQL over outsourced database
    Xiang, Tao
    Li, Xiaoguo
    Chen, Fei
    Guo, Shangwei
    Yang, Yuanyuan
    [J]. INFORMATION SCIENCES, 2016, 348 : 163 - 178
  • [4] Flexible and Publicly Verifiable Aggregation Query for Outsourced Databases in Cloud
    Yuan, Jiawei
    Yu, Shucheng
    [J]. 2013 IEEE CONFERENCE ON COMMUNICATIONS AND NETWORK SECURITY (CNS), 2013, : 520 - 524
  • [5] IoT data security in outsourced databases: A survey of verifiable database
    Chen, Ailin
    Yu, Shaoyuan
    Yang, Xinyi
    Huang, Ding
    Ren, Yongjun
    [J]. HELIYON, 2024, 10 (07)
  • [6] Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey
    Zhang, Bo
    Dong, Boxiang
    Wang, Wendy Hui
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2021, 33 (04) : 1601 - 1618
  • [7] vSQL: Verifying Arbitrary SQL Queries over Dynamic Outsourced Databases
    Zhang, Yupeng
    Genkin, Daniel
    Katz, Jonathan
    Papadopoulos, Dimitrios
    Papamanthou, Charalampos
    [J]. 2017 IEEE SYMPOSIUM ON SECURITY AND PRIVACY (SP), 2017, : 863 - 880
  • [8] Verifiable Auditing Protocol with Proxy Re-Encryption for Outsourced Databases in Cloud
    GAO Ziyuan
    WANG Baocang
    LIU Hequn
    LU Ke
    ZHAN Yu
    [J]. Wuhan University Journal of Natural Sciences, 2018, 23 (02) : 120 - 128
  • [9] Verifiable Privacy-Preserving Outsourced Frequent Itemset Mining on Vertically Partitioned Databases
    Zhao, Zhen
    Lan, Lei
    Wang, Baocang
    Lai, Jianchang
    [J]. ELECTRONICS, 2023, 12 (08)
  • [10] PRISM: Private Verifiable Set Computation over Multi-Owner Outsourced Databases
    Li, Yin
    Ghosh, Dhrubajyoti
    Gupta, Peeyush
    Mehrotra, Sharad
    Panwar, Nisha
    Sharma, Shantanu
    [J]. SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 1116 - 1128