{"id":"https://openalex.org/W2962933337","doi":"https://doi.org/10.14778/3055330.3055334","title":"SMCQL","display_name":"SMCQL","publication_year":2017,"publication_date":"2017-02-01","ids":{"openalex":"https://openalex.org/W2962933337","doi":"https://doi.org/10.14778/3055330.3055334","mag":"2962933337"},"language":"en","primary_location":{"id":"doi:10.14778/3055330.3055334","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3055330.3055334","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/A5012292994","display_name":"Johes Bater","orcid":"https://orcid.org/0000-0001-7384-1183"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Johes Bater","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024638893","display_name":"Gregory Elliott","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gregory Elliott","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035154197","display_name":"Craig Eggen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Craig Eggen","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109910296","display_name":"Satyender Goel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Satyender Goel","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105421228","display_name":"Abel Kho","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abel Kho","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056003081","display_name":"Jennie Rogers","orcid":"https://orcid.org/0000-0002-4218-8502"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jennie Rogers","raw_affiliation_strings":["Northwestern University"],"affiliations":[{"raw_affiliation_string":"Northwestern University","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5012292994"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.2293,"has_fulltext":false,"cited_by_count":120,"citation_normalized_percentile":{"value":0.97094986,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"10","issue":"6","first_page":"673","last_page":"684"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","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/T10237","display_name":"Cryptography and Data Security","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/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9986000061035156,"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/T11614","display_name":"Cloud Data Security Solutions","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8446042537689209},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5573832392692566},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5447789430618286},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5298476219177246},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5125565528869629},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.5028707385063171},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.49616941809654236},{"id":"https://openalex.org/keywords/pooling","display_name":"Pooling","score":0.48845282196998596},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.45769602060317993},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.44505417346954346},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.42781081795692444},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.39630475640296936},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.35801568627357483}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8446042537689209},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5573832392692566},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5447789430618286},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5298476219177246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5125565528869629},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5028707385063171},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49616941809654236},{"id":"https://openalex.org/C70437156","wikidata":"https://www.wikidata.org/wiki/Q7228652","display_name":"Pooling","level":2,"score":0.48845282196998596},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.45769602060317993},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.44505417346954346},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.42781081795692444},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39630475640296936},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.35801568627357483},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3055330.3055334","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3055330.3055334","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/16","score":0.4000000059604645,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320332498","display_name":"Quality Enhancement Research Initiative","ror":"https://ror.org/03cdz5d08"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W3168804","https://openalex.org/W112650321","https://openalex.org/W150396298","https://openalex.org/W181949725","https://openalex.org/W238561561","https://openalex.org/W966799963","https://openalex.org/W1480225633","https://openalex.org/W1496712790","https://openalex.org/W1520270249","https://openalex.org/W1928359578","https://openalex.org/W1958471089","https://openalex.org/W1991271936","https://openalex.org/W2001084165","https://openalex.org/W2004154155","https://openalex.org/W2005756274","https://openalex.org/W2017839015","https://openalex.org/W2022063165","https://openalex.org/W2027471022","https://openalex.org/W2056360854","https://openalex.org/W2073226520","https://openalex.org/W2080911030","https://openalex.org/W2092422002","https://openalex.org/W2095273830","https://openalex.org/W2096870293","https://openalex.org/W2114423840","https://openalex.org/W2119956568","https://openalex.org/W2122049982","https://openalex.org/W2124919972","https://openalex.org/W2128906841","https://openalex.org/W2148373824","https://openalex.org/W2150174204","https://openalex.org/W2158106499","https://openalex.org/W2159915142","https://openalex.org/W2403789702","https://openalex.org/W2911978475","https://openalex.org/W4299301436"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W3156363426","https://openalex.org/W4244527061","https://openalex.org/W2556786504","https://openalex.org/W2406556739","https://openalex.org/W2152149667","https://openalex.org/W2186703450","https://openalex.org/W175663584","https://openalex.org/W2413368787","https://openalex.org/W3125756434"],"abstract_inverted_index":{"People":[0],"and":[1,27,39,123,144,148,207,235],"machines":[2],"are":[3,34,47,151],"collecting":[4],"data":[5,87,197],"at":[6],"an":[7,118],"unprecedented":[8],"rate.":[9],"Despite":[10],"this":[11,70],"newfound":[12],"abundance":[13],"of":[14,88,156,184,213,232],"data,":[15],"progress":[16],"has":[17],"been":[18],"slow":[19],"in":[20,49],"sharing":[21],"it":[22],"for":[23,54,82,162],"open":[24],"science,":[25],"business,":[26],"other":[28,66],"data-intensive":[29],"endeavors.":[30],"Many":[31],"such":[32],"efforts":[33],"stymied":[35],"by":[36],"privacy":[37],"concerns":[38],"regulatory":[40],"compliance":[41],"issues.":[42],"For":[43,217],"example,":[44],"many":[45],"hospitals":[46],"interested":[48],"pooling":[50],"their":[51],"medical":[52],"records":[53,62],"research,":[55],"but":[56],"none":[57],"may":[58],"disclose":[59],"arbitrary":[60],"patient":[61],"to":[63,103,107,117,153,177,195],"researchers":[64],"or":[65,199],"healthcare":[67],"providers.":[68],"In":[69,92],"context":[71],"we":[72,222],"propose":[73],"the":[74,85,108,112,154,182,200,204,208,211,229],"Private":[75],"Data":[76],"Network":[77],"(PDN),":[78],"a":[79,93,115,160,214,224],"federated":[80],"database":[81,97],"querying":[83],"over":[84,127,181],"collective":[86],"mutually":[89],"distrustful":[90],"parties.":[91],"PDN,":[94],"each":[95,137],"member":[96],"does":[98],"not":[99],"reveal":[100],"its":[101,104,125,145,185,237],"tuples":[102,194],"peers":[105],"nor":[106],"query":[109,116,139,179,220,238],"writer.":[110],"Instead,":[111],"user":[113],"submits":[114],"honest":[119,201,205],"broker":[120,206],"that":[121,227],"plans":[122],"coordinates":[124],"execution":[126,140],"multiple":[128],"private":[129],"databases":[130,187],"using":[131],"secure":[132,219,233],"multiparty":[133],"computation":[134,234],"(SMC).":[135],"Here,":[136],"database's":[138],"is":[141],"oblivious":[142],",":[143],"program":[146],"counters":[147],"memory":[149],"traces":[150],"agnostic":[152],"inputs":[155],"others.":[157],"We":[158],"introduce":[159],"framework":[161],"executing":[163],"PDN":[164,215],"queries":[165],"named":[166],"smcql":[167],".":[168],"This":[169],"system":[170],"translates":[171],"SQL":[172],"statements":[173],"into":[174,240],"SMC":[175],"primitives":[176],"compute":[178],"results":[180,212],"union":[183],"source":[186],"without":[188],"revealing":[189],"sensitive":[190],"information":[191],"about":[192],"individual":[193],"peer":[196],"providers":[198],"broker.":[202],"Only":[203],"querier":[209],"receive":[210],"query.":[216],"fast,":[218],"evaluation,":[221],"explore":[223],"heuristics-driven":[225],"optimizer":[226],"minimizes":[228],"PDN's":[230],"use":[231],"partitions":[236],"evaluation":[239],"scalable":[241],"slices.":[242]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":19},{"year":2024,"cited_by_count":19},{"year":2023,"cited_by_count":17},{"year":2022,"cited_by_count":17},{"year":2021,"cited_by_count":16},{"year":2020,"cited_by_count":13},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":3}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2019-07-30T00:00:00"}