PrivateSQL

PrivateSQL employs state-of-art differential privacy technology for aggregate queries. With PrivateSQL, organizations can confidently share data internally as well as with external partners, unlocking new opportunities with compliant data.

Automatic differential privacy

Automatically rewrites queries to be differentially private and executes them on the database.

BEFORE

You can determine Chloe’s salary by querying the database with and without her private data and then calculating the difference.

Query: What is the average employee salary?
Salary Database with Chloe’s data
Salary Database without Chloe’s data
Chloe’s salary data is exposed!

AFTER

With PrivateSQL, the query is rewritten in a differentially private way. The presence or absence of Chloe’s data returns roughly the same result, so Chloe’s data is protected.

Query: What is the average employee salary?
PrivateSQL
Query Rewriter
Salary Database with Chloe’s data
Salary Database without Chloe’s data
Chloe’s data is protected.

No need to white/black-list queries ahead of time. PrivateSQL automatically rejects queries that expose sensitive records or violate column access rules.

Enables the specification and tracking of privacy budgets across teams and external parties.

Certified HIPAA compliant under the expert determination clause of HIPAA

“Working closely with Oasis Labs has allowed OSF Innovation to pioneer new approaches to data privacy in healthcare. Differential privacy technology is a cornerstone of our joint effort to responsibly use patient data and improve outcomes for patients everywhere.”

John Vozenilek, MD

Chief Medical Officer, VP for Innovation and Digital Health, OSF HealthCare

Why PrivateSQL?

Privacy by design
  • State-of-art differential privacy
  • Mathematical guarantees
Query support and expressivity
  • Support for COUNT, SUM, AVG, VAR, STDDEV, PERCENTILE, MIN, and MAX
  • Support for JOINs across shared tables
  • High degree of query expressivity
Ease of deployment
  • Deployment in minutes
  • No modifications to the database, tables, or schemas
Multiple interfaces
  • Jupyter Notebooks clients
  • Intuitive CLI
  • REST API

How to use PrivateSQL

01

Connect your data

Deploy PrivateSQL in minutes, connect to your SQL databases in public clouds, and select the datasets/tables for which you want to query with privacy guarantee.

02

Configure

Manage users or data collaborators and set a privacy budget.

03

Query

Query will be automatically rewritten to be differentially private. Enable the sharing of statistical insights directly from SQL databases without the need for redaction or anonymization.

Start using PrivateSQL on the Google Cloud Marketplace.