{"id":"https://openalex.org/W2970408474","doi":"https://doi.org/10.14778/3342263.3342274","title":"PrivateSQL","display_name":"PrivateSQL","publication_year":2019,"publication_date":"2019-07-01","ids":{"openalex":"https://openalex.org/W2970408474","doi":"https://doi.org/10.14778/3342263.3342274","mag":"2970408474"},"language":"en","primary_location":{"id":"doi:10.14778/3342263.3342274","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3342263.3342274","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5019737386","display_name":"Ios Kotsogiannis","orcid":null},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ios Kotsogiannis","raw_affiliation_strings":["Duke University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010901844","display_name":"Yuchao Tao","orcid":"https://orcid.org/0000-0002-2101-3973"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yuchao Tao","raw_affiliation_strings":["Duke University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106417734","display_name":"Xi He","orcid":"https://orcid.org/0000-0002-4999-4937"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Xi He","raw_affiliation_strings":["University of Waterloo"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062034876","display_name":"Maryam Fanaeepour","orcid":"https://orcid.org/0000-0003-2654-982X"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Maryam Fanaeepour","raw_affiliation_strings":["Duke University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018314576","display_name":"Ashwin Machanavajjhala","orcid":"https://orcid.org/0000-0003-1555-7330"},"institutions":[{"id":"https://openalex.org/I170897317","display_name":"Duke University","ror":"https://ror.org/00py81415","country_code":"US","type":"education","lineage":["https://openalex.org/I170897317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ashwin Machanavajjhala","raw_affiliation_strings":["Duke University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duke University","institution_ids":["https://openalex.org/I170897317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020275137","display_name":"Michael Hay","orcid":"https://orcid.org/0000-0001-9085-893X"},"institutions":[{"id":"https://openalex.org/I39660569","display_name":"Colgate University","ror":"https://ror.org/05d23ve83","country_code":"US","type":"education","lineage":["https://openalex.org/I39660569"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael Hay","raw_affiliation_strings":["Colgate University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Colgate University","institution_ids":["https://openalex.org/I39660569"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036518572","display_name":"Gerome Miklau","orcid":"https://orcid.org/0000-0003-1369-9239"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gerome Miklau","raw_affiliation_strings":["University of Massachusetts"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.6446,"has_fulltext":false,"cited_by_count":112,"citation_normalized_percentile":{"value":0.97675358,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"12","issue":"11","first_page":"1371","last_page":"1384"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9865000247955322,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8334624767303467},{"id":"https://openalex.org/keywords/differential-privacy","display_name":"Differential privacy","score":0.8185417056083679},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6953990459442139},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6098836064338684},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.561500608921051},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5360085964202881},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4784645736217499},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4730493128299713},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4326237142086029},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4123503565788269},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37187257409095764},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36347347497940063},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24650409817695618}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8334624767303467},{"id":"https://openalex.org/C23130292","wikidata":"https://www.wikidata.org/wiki/Q5275358","display_name":"Differential privacy","level":2,"score":0.8185417056083679},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6953990459442139},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6098836064338684},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.561500608921051},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5360085964202881},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4784645736217499},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4730493128299713},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4326237142086029},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4123503565788269},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37187257409095764},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36347347497940063},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24650409817695618},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3342263.3342274","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3342263.3342274","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W1446333884","https://openalex.org/W1493407996","https://openalex.org/W1585529040","https://openalex.org/W1601184778","https://openalex.org/W1860880244","https://openalex.org/W1981029888","https://openalex.org/W1981932091","https://openalex.org/W1990503647","https://openalex.org/W1992461601","https://openalex.org/W2009611335","https://openalex.org/W2017509273","https://openalex.org/W2027595342","https://openalex.org/W2028628865","https://openalex.org/W2030559796","https://openalex.org/W2071989194","https://openalex.org/W2096803423","https://openalex.org/W2096870293","https://openalex.org/W2110868467","https://openalex.org/W2123733729","https://openalex.org/W2139875914","https://openalex.org/W2150611147","https://openalex.org/W2152191782","https://openalex.org/W2165157425","https://openalex.org/W2169861334","https://openalex.org/W2170204206","https://openalex.org/W2217200224","https://openalex.org/W2361944894","https://openalex.org/W2404133814","https://openalex.org/W2406036028","https://openalex.org/W2436309872","https://openalex.org/W2599449751","https://openalex.org/W2604272474","https://openalex.org/W2761138375","https://openalex.org/W2799269185","https://openalex.org/W2884174229","https://openalex.org/W2897278297","https://openalex.org/W2950884216","https://openalex.org/W3004550542","https://openalex.org/W3099979833","https://openalex.org/W3102407811","https://openalex.org/W3102891118","https://openalex.org/W3102994281","https://openalex.org/W3126102579","https://openalex.org/W3209145103","https://openalex.org/W4205228770","https://openalex.org/W4248861293","https://openalex.org/W4255574744","https://openalex.org/W6707282477"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W2898886863","https://openalex.org/W2902831276","https://openalex.org/W3174970460","https://openalex.org/W1639806124","https://openalex.org/W2165259096","https://openalex.org/W2540682188","https://openalex.org/W2545844851","https://openalex.org/W3022423983"],"abstract_inverted_index":{"Differential":[0],"privacy":[1,47,70,120,154],"is":[2],"considered":[3],"a":[4,45,68,83,100,106,115,152,186,195,199],"de":[5],"facto":[6],"standard":[7,101],"for":[8,35,49,210],"private":[9,61,87,168],"data":[10,40,97,123,138],"analysis.":[11],"However,":[12],"the":[13,18,30,77,130,137,145,158,162,175,213],"definition":[14,31,48],"and":[15,32,54,135,198],"much":[16],"of":[17,29,38,63,109,118,201,212],"supporting":[19],"literature":[20],"applies":[21],"to":[22,95,121,140,181],"flat":[23],"tables.":[24],"While":[25],"there":[26,43],"exist":[27],"variants":[28],"specialized":[33],"algorithms":[34],"specific":[36],"types":[37],"relational":[39,88],"(e.g.":[41],"graphs),":[42],"isn't":[44],"general":[46],"multi-relational":[50,122],"schemas":[51],"with":[52],"constraints,":[53],"no":[55],"system":[56,104],"that":[57,124,147,178,209],"permits":[58],"accurate":[59],"differentially":[60,86],"answering":[62,165],"SQL":[64,110],"queries":[65,74,159,166,214],"while":[66],"imposing":[67],"fixed":[69,153],"budget":[71],"across":[72,156],"all":[73,157],"posed":[75,160],"by":[76,161,164],"analyst.":[78],"This":[79],"work":[80],"presents":[81],"PrivateSQL,":[82],"first-of-its-kind":[84],"end-to-end":[85],"database":[89,102],"system.":[90],"PrivateSQL":[91,113,150,193,215],"allows":[92,136],"an":[93],"analyst":[94,163],"query":[96,188],"stored":[98],"in":[99,129,144],"management":[103],"using":[105],"rich":[107],"class":[108],"counting":[111],"queries.":[112,206],"adopts":[114],"novel":[116],"generalization":[117],"differential":[119],"takes":[125],"into":[126],"account":[127],"constraints":[128],"schema":[131,146],"like":[132],"foreign":[133],"keys,":[134],"owner":[139],"flexibly":[141],"specify":[142],"entities":[143],"need":[148],"privacy.":[149],"ensures":[151],"loss":[155],"on":[167,185,194],"synopses":[169],"generated":[170],"from":[171,227],"several":[172],"views":[173],"over":[174],"base":[176],"relation":[177],"are":[179],"tuned":[180],"have":[182],"low":[183],"error":[184,222],"representative":[187],"workload.":[189],"We":[190,207],"experimentally":[191],"evaluate":[192],"real-world":[196],"dataset":[197],"workload":[200],"more":[202],"than":[203,224],"3,":[204],"600":[205],"show":[208],"50%":[211],"offers":[216],"at":[217],"least":[218],"1,":[219],"000x":[220],"better":[221],"rates":[223],"solutions":[225],"adapted":[226],"prior":[228],"work.":[229]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":14},{"year":2024,"cited_by_count":22},{"year":2023,"cited_by_count":22},{"year":2022,"cited_by_count":11},{"year":2021,"cited_by_count":20},{"year":2020,"cited_by_count":15},{"year":2019,"cited_by_count":2}],"updated_date":"2026-08-22T07:34:49.880490","created_date":"2019-09-05T00:00:00"}