Visible to the public Sensitivity Analysis of SQL Queries

TitleSensitivity Analysis of SQL Queries
Publication TypeConference Paper
Year of Publication2018
AuthorsLaud, Peeter, Pettai, Martin, Randmets, Jaak
Conference NameProceedings of the 13th Workshop on Programming Languages and Analysis for Security
PublisherACM
Conference LocationNew York, NY, USA
ISBN Number978-1-4503-5993-1
Keywordscomposability, Differential privacy, pubcrawl, Sensitivity, SQL
Abstract

The sensitivity of a function is the maximum change of its output for a unit change of its input. In this paper we present a method for determining the sensitivity of SQL queries, seen as functions from databases to datasets, where the change is measured in the number of rows that differ. Given a query, a database schema and a number, our method constructs a formula that is satisfiable only if the sensitivity of the query is bigger than this number. Our method is composable, and can also be applied to SQL workflows. Our results can be used to calibrate the amount of noise that has to be added to the output of the query to obtain a certain level of differential privacy.

URLhttps://dl.acm.org/citation.cfm?doid=3264820.3264825
DOI10.1145/3264820.3264825
Citation Keylaud_sensitivity_2018