{"id":"https://openalex.org/W2943245411","doi":"https://doi.org/10.1109/tdsc.2019.2914209","title":"PSpec-SQL: Enabling Fine-Grained Control for Distributed Data Analytics","display_name":"PSpec-SQL: Enabling Fine-Grained Control for Distributed Data Analytics","publication_year":2019,"publication_date":"2019-04-30","ids":{"openalex":"https://openalex.org/W2943245411","doi":"https://doi.org/10.1109/tdsc.2019.2914209","mag":"2943245411"},"language":"en","primary_location":{"id":"doi:10.1109/tdsc.2019.2914209","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2019.2914209","pdf_url":null,"source":{"id":"https://openalex.org/S133795288","display_name":"IEEE Transactions on Dependable and Secure Computing","issn_l":"1545-5971","issn":["1545-5971","1941-0018","2160-9209"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Dependable and Secure Computing","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/A5002967615","display_name":"Chen Luo","orcid":"https://orcid.org/0000-0002-2180-7749"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Luo","raw_affiliation_strings":["School of Software, Tsinghua University, China"],"raw_orcid":"https://orcid.org/0000-0002-2180-7749","affiliations":[{"raw_affiliation_string":"School of Software, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042735025","display_name":"Fei He","orcid":"https://orcid.org/0000-0002-4266-875X"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Fei He","raw_affiliation_strings":["School of Software, Tsinghua University, China"],"raw_orcid":"https://orcid.org/0000-0002-4266-875X","affiliations":[{"raw_affiliation_string":"School of Software, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101805365","display_name":"Fei Peng","orcid":"https://orcid.org/0000-0002-1270-6583"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Fei Peng","raw_affiliation_strings":["School of Software, Tsinghua University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software, Tsinghua University, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102568331","display_name":"Dong Yan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dong Yan","raw_affiliation_strings":["Intel Labs, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Intel Labs, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100455988","display_name":"Dan Zhang","orcid":"https://orcid.org/0000-0001-5684-9618"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dan Zhang","raw_affiliation_strings":["Intel Labs, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Intel Labs, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085049630","display_name":"Xin Zhou","orcid":"https://orcid.org/0000-0003-2418-3350"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xin Zhou","raw_affiliation_strings":["Intel Labs, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Intel Labs, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.1412,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.54645398,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"18","issue":"2","first_page":"810","last_page":"824"},"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.9995999932289124,"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.9995999932289124,"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.9995999932289124,"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"}},{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","score":0.9988999962806702,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8688617944717407},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6607425212860107},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5563101172447205},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.515503466129303},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5146594643592834},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.47436127066612244},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.43959861993789673},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4225788712501526},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.21548649668693542},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11937716603279114},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09860894083976746},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08395928144454956}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8688617944717407},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6607425212860107},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5563101172447205},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.515503466129303},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5146594643592834},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.47436127066612244},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.43959861993789673},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4225788712501526},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21548649668693542},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11937716603279114},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09860894083976746},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08395928144454956},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tdsc.2019.2914209","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2019.2914209","pdf_url":null,"source":{"id":"https://openalex.org/S133795288","display_name":"IEEE Transactions on Dependable and Secure Computing","issn_l":"1545-5971","issn":["1545-5971","1941-0018","2160-9209"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Dependable and Secure Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.5199999809265137}],"awards":[{"id":"https://openalex.org/G3740624217","display_name":null,"funder_award_id":"61527812","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4861134968","display_name":null,"funder_award_id":"2016ZX01038101","funder_id":"https://openalex.org/F4320329860","funder_display_name":"National Science and Technology Major Project"},{"id":"https://openalex.org/G6040694725","display_name":"\u9762\u5411\u8f6f\u4ef6\u6f14\u5316\u7684\u56de\u5f52\u5f62\u5f0f\u5316\u9a8c\u8bc1\u7814\u7a76","funder_award_id":"61672310","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320329860","display_name":"National Science and Technology Major Project","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":47,"referenced_works":["https://openalex.org/W8494308","https://openalex.org/W192814132","https://openalex.org/W1512840853","https://openalex.org/W1557915535","https://openalex.org/W1651603939","https://openalex.org/W1655092483","https://openalex.org/W1948417575","https://openalex.org/W1963971515","https://openalex.org/W1964691382","https://openalex.org/W1967221886","https://openalex.org/W1981490327","https://openalex.org/W1986950008","https://openalex.org/W2003367163","https://openalex.org/W2008896880","https://openalex.org/W2022063165","https://openalex.org/W2038412523","https://openalex.org/W2052312648","https://openalex.org/W2069555406","https://openalex.org/W2096745467","https://openalex.org/W2096870293","https://openalex.org/W2101771965","https://openalex.org/W2108409407","https://openalex.org/W2109426455","https://openalex.org/W2110086534","https://openalex.org/W2114423840","https://openalex.org/W2116236474","https://openalex.org/W2122049982","https://openalex.org/W2124321177","https://openalex.org/W2134167315","https://openalex.org/W2139135093","https://openalex.org/W2159024459","https://openalex.org/W2173213060","https://openalex.org/W2344251723","https://openalex.org/W2401617229","https://openalex.org/W2509824384","https://openalex.org/W2620965427","https://openalex.org/W2911978475","https://openalex.org/W2914418376","https://openalex.org/W3021135929","https://openalex.org/W3136699861","https://openalex.org/W6607754154","https://openalex.org/W6633288396","https://openalex.org/W6641330010","https://openalex.org/W6680506379","https://openalex.org/W6713252871","https://openalex.org/W6738977434","https://openalex.org/W6758947373"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W2614112517","https://openalex.org/W2108932068","https://openalex.org/W1980548249","https://openalex.org/W2340883001","https://openalex.org/W1488984669","https://openalex.org/W2512678083","https://openalex.org/W2038123353","https://openalex.org/W4388053677","https://openalex.org/W4223894417"],"abstract_inverted_index":{"Business":[0],"organizations":[1,34],"regularly":[2],"collect":[3],"customer":[4,32],"data":[5,15,24,28,51,71,76,82,85,88],"to":[6,13,22,73,86,96],"improve":[7],"their":[8],"services.":[9],"Organizations":[10],"may":[11],"want":[12],"share":[14],"within":[16],"themselves":[17],"or":[18],"even":[19],"with":[20,132],"third-parties":[21],"maximize":[23],"utility.":[25],"Since":[26],"business":[27],"contain":[29],"lots":[30],"of":[31,108,112,129],"data,":[33],"must":[35],"respect":[36],"customers'":[37],"privacy":[38,41,57],"expounded":[39],"by":[40],"laws.":[42],"In":[43],"this":[44],"paper,":[45],"we":[46],"present":[47],"PSpec-SQL,":[48],"a":[49,65,106,117],"distributed":[50],"analytics":[52],"system":[53,63,92,131],"that":[54],"automatically":[55],"enforces":[56],"compliance":[58],"for":[59,69],"SQL":[60],"queries.":[61],"Our":[62],"provides":[64],"high-level":[66],"language":[67],"PSpec":[68],"the":[70,81,121,127],"owner":[72],"specify":[74],"her":[75],"usage":[77],"policy.":[78],"As":[79],"usual,":[80],"analyst":[83],"queries":[84,100],"perform":[87],"analysis,":[89],"but":[90],"our":[91,130],"checks":[93],"each":[94],"query":[95,136],"ensure":[97],"only":[98],"policy-compliant":[99],"are":[101],"executed.":[102],"We":[103],"have":[104],"implemented":[105],"prototype":[107],"PSpec-SQL":[109],"on":[110,120],"top":[111],"Spark-SQL,":[113],"and":[114],"carried":[115],"out":[116],"case":[118],"study":[119],"TPC":[122],"benchmarks.":[123],"The":[124],"results":[125],"show":[126],"practicability":[128],"negligible":[133],"overhead":[134],"over":[135],"processing.":[137]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}