SIMD-PAC-DB: Pretty Performant PAC Privacy

Fuente: arXiv
Saved in:
Bibliographic Details
Main Authors: Battiston, Ilaria, Yuan, Dandan, Zhu, Xiaochen, Boncz, Peter
Format: Preprint
Published: 2026
Subjects:
Online Access:
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1866917353143402496
author Battiston, Ilaria
Yuan, Dandan
Zhu, Xiaochen
Boncz, Peter
author_facet Battiston, Ilaria
Yuan, Dandan
Zhu, Xiaochen
Boncz, Peter
contents This work presents a highly optimized implementation of PAC-DB, a recent and promising database privacy model. We prove that our SIMD-PAC-DB can compute the same privatized answer with just a single query, instead of the 128 stochastic executions against different 50% database sub-samples needed by the original PAC-DB. Our key insight is that every bit of a hashed primary key can be seen to represent membership of such a sub-sample. We present new algorithms for approximate computation of stochastic aggregates based on these hashes, which, thanks to their SIMD-friendliness, run up to 40x faster than scalar equivalents. We release an open-source DuckDB community extension which includes a rewriter that PAC-privatizes arbitrary SQL queries. Our experiments on TPC-H, Clickbench, and SQLStorm evaluate thousands of queries in terms of performance and utility, significantly advancing the ease of use and functionality of privacy-aware data systems in practice.
format Preprint
id arxiv_https___arxiv_org_abs_2603_15023
institution arXiv
publishDate 2026
record_format arxiv
spellingShingle SIMD-PAC-DB: Pretty Performant PAC Privacy
Battiston, Ilaria
Yuan, Dandan
Zhu, Xiaochen
Boncz, Peter
Databases
This work presents a highly optimized implementation of PAC-DB, a recent and promising database privacy model. We prove that our SIMD-PAC-DB can compute the same privatized answer with just a single query, instead of the 128 stochastic executions against different 50% database sub-samples needed by the original PAC-DB. Our key insight is that every bit of a hashed primary key can be seen to represent membership of such a sub-sample. We present new algorithms for approximate computation of stochastic aggregates based on these hashes, which, thanks to their SIMD-friendliness, run up to 40x faster than scalar equivalents. We release an open-source DuckDB community extension which includes a rewriter that PAC-privatizes arbitrary SQL queries. Our experiments on TPC-H, Clickbench, and SQLStorm evaluate thousands of queries in terms of performance and utility, significantly advancing the ease of use and functionality of privacy-aware data systems in practice.
title SIMD-PAC-DB: Pretty Performant PAC Privacy
topic Databases
url https://arxiv.org/abs/2603.15023