Skip to content

feat(transformation): design specs for supporting dp sql queries as transformation in dcr #49

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
qascade opened this issue May 20, 2023 · 1 comment

Comments

@qascade
Copy link
Owner

qascade commented May 20, 2023

Description

SQL queries are much more user-friendly and readable than any other general-purpose languages like Python or Go. We want to support such SQL queries as transformation if possible, but the catch is that the query result should be differentially private. We may have to look into different strategies on how we can generate an execution plan based on query input that makes the SQL output dp. We would also want the query execution to be done inside a tee.

Some high level strategies may include:

  1. Take any existing DB and modify its query language and execution plan that uses google's dp definition
  2. Write an OLAP db from scratch and make sure the above conditions are met.
  3. Write an interpreter that generates confidential go-apps after reading a SQL query. (In this we will be only able to support a limited set of queries and may have to go from query by query)

Resources:

  1. https://dpfordb.github.io/dpfordb.pdf
  2. https://github.com/google/differential-privacy
@qascade qascade self-assigned this May 20, 2023
@qascade qascade removed their assignment May 20, 2023
@qascade qascade changed the title specs: design specs for supporting dp sql queries as transformation in dcr feat: design and implement specs for supporting dp sql queries as transformation in dcr May 21, 2023
@qascade qascade changed the title feat: design and implement specs for supporting dp sql queries as transformation in dcr feat(transformation): design and implement specs for supporting dp sql queries as transformation in dcr May 21, 2023
@qascade qascade changed the title feat(transformation): design and implement specs for supporting dp sql queries as transformation in dcr feat(transformation): design specs for supporting dp sql queries as transformation in dcr May 26, 2023
@qascade
Copy link
Owner Author

qascade commented May 26, 2023

Implemenation of this spec is to be done in #59

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants