Sarus

Qrlew Playground

Simple Query Rewriting with Differential Privacy

Qrlew is an open source library that aims to parse and compile SQL queries into an Intermediate Representation (IR) that is well-suited for various rewriting tasks, including Differential Privacy.

In this playground you can change parameters interactively and see how Qrlew represent your query and rewrite it into a Differentially Private one.

Query, Dataset and Parameters

Query

SELECT sum(duration) FROM action_table WHERE duration > 0 AND duration < 24

SELECT sum(duration) FROM action_table WHERE duration > 0 AND duration < 24

Dataset definition

{
  "tables":[
     {
        "name":"user_table",
        "path":["schema","user_table"],
        "schema":{
           "fields":[
              { "name":"id",  "data_type":"Integer", "constraint":"Unique" },
              { "name":"name", "data_type":"Text" },
              { "name":"age", "data_type":"Integer" },
              { "name":"weight", "data_type":"Float" }
           ]
        },
        "size":1000
     },
     {
        "name":"action_table",
        "path":["schema","action_table"],
        "schema":{
           "fields":[
              { "name":"action", "data_type":"Text" },
              { "name":"user_id", "data_type":"Integer" },
              { "name":"duration", "data_type":"Float" }
           ]
        },
        "size":10000
     }
  ]
}

{
  "tables":[
     {
        "name":"user_table",
        "path":["schema","user_table"],
        "schema":{
           "fields":[
              { "name":"id",  "data_type":"Integer", "constraint":"Unique" },
              { "name":"name", "data_type":"Text" },
              { "name":"age", "data_type":"Integer" },
              { "name":"weight", "data_type":"Float" }
           ]
        },
        "size":1000
     },
     {
        "name":"action_table",
        "path":["schema","action_table"],
        "schema":{
           "fields":[
              { "name":"action", "data_type":"Text" },
              { "name":"user_id", "data_type":"Integer" },
              { "name":"duration", "data_type":"Float" }
           ]
        },
        "size":10000
     }
  ]
}

Synthetic Data

[
  ["user_table","synthetic_user_table"],
  ["action_table","synthetic_action_table"]
]

[
  ["user_table","synthetic_user_table"],
  ["action_table","synthetic_action_table"]
]

Privacy Unit

[
  ["user_table",[],"id"],
  ["action_table",[["user_id","user_table","id"]],"id"]
]

[
  ["user_table",[],"id"],
  ["action_table",[["user_id","user_table","id"]],"id"]
]

Epsilon

1.0

1.0

Delta

1e-5

1e-5

Rewritten DP Query

Intermediate Representation

Rewritten Intermediate Representation

Qrlew project is licensed under the Apache License, Version 2.0 (the "License"); you may not use it except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Sarus Technologies