Skip to content
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

feat: implement a SQL grammer that lets collaborators define differentially private transformation and run it on our system. #59

Open
qascade opened this issue May 22, 2023 · 0 comments

Comments

@qascade
Copy link
Owner

qascade commented May 22, 2023

Description

For now our system is built for generic transformations and a collaborator has to provide the code for transformation which is good for ML Use Cases (given it is Federated) but normal analysts just want simple SQL queries to run. We should give them a user friendly way to express their queries with additional specifications/parameters for Noises and Compile it onto some database that can be run on intel SGX.

One such option may be : https://github.com/edgelesssys/edgelessdb

Some idea on how the SQL may look like from Google's ZetaSql extension:

SELECT WITH ANONYMIZATION OPTIONS (   
		epsilon={{epsilon_val}}, 
		delta={{delta_val}}, 
		kappa={{kappa_val}}
) ANON_COUNT({{count_col}} CLAMPED {{threshold}}) AS {{transformation_name}}
 FROM {{table1}} join {{table2}} using {{join_key}}. 
@qascade qascade changed the title spec: define a SQL grammer that lets collaborators define differentially private transformation and run it on our system. feat: define and implemet a SQL grammer that lets collaborators define differentially private transformation and run it on our system. May 22, 2023
@qascade qascade changed the title feat: define and implemet a SQL grammer that lets collaborators define differentially private transformation and run it on our system. feat: define and implement a SQL grammer that lets collaborators define differentially private transformation and run it on our system. May 22, 2023
@qascade qascade changed the title feat: define and implement a SQL grammer that lets collaborators define differentially private transformation and run it on our system. feat: implement a SQL grammer that lets collaborators define differentially private transformation and run it on our system. May 26, 2023
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