{"id":"https://openalex.org/W2047847010","doi":"https://doi.org/10.1145/2462410.2462428","title":"Enabling intensional access control via preference-aware query optimization","display_name":"Enabling intensional access control via preference-aware query optimization","publication_year":2013,"publication_date":"2013-06-05","ids":{"openalex":"https://openalex.org/W2047847010","doi":"https://doi.org/10.1145/2462410.2462428","mag":"2047847010"},"language":"en","primary_location":{"id":"doi:10.1145/2462410.2462428","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2462410.2462428","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM symposium on Access control models and technologies","raw_type":"proceedings-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/A5081943471","display_name":"Nicholas L. Farnan","orcid":null},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Nicholas L. Farnan","raw_affiliation_strings":["University of Pittsburgh, Pittsburgh, PA, USA"],"affiliations":[{"raw_affiliation_string":"University of Pittsburgh, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032842781","display_name":"Adam J. Lee","orcid":"https://orcid.org/0000-0002-2596-7256"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Adam J. Lee","raw_affiliation_strings":["University of Pittsburgh, Pittsburgh, PA, USA"],"affiliations":[{"raw_affiliation_string":"University of Pittsburgh, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068023630","display_name":"Panos K. Chrysanthis","orcid":"https://orcid.org/0000-0001-7189-9816"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Panos K. Chrysanthis","raw_affiliation_strings":["University of Pittsburgh, Pittsburgh, PA, USA"],"affiliations":[{"raw_affiliation_string":"University of Pittsburgh, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080357184","display_name":"Ting Yu","orcid":"https://orcid.org/0000-0001-6386-1906"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ting Yu","raw_affiliation_strings":["North Carolina State University, Raleigh, NC, USA"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, NC, USA","institution_ids":["https://openalex.org/I137902535"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5081943471"],"corresponding_institution_ids":["https://openalex.org/I170201317"],"apc_list":null,"apc_paid":null,"fwci":0.4942,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.76483781,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"189","last_page":"192"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","score":0.9998000264167786,"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.9998000264167786,"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.9997000098228455,"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/T10927","display_name":"Access Control and Trust","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social 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.8846454620361328},{"id":"https://openalex.org/keywords/intension","display_name":"Intension","score":0.7871994972229004},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6816627979278564},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6427421569824219},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6252477169036865},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5749882459640503},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5007832050323486},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4937475621700287},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.48187264800071716},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.47554394602775574},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.4538728594779968},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4389636814594269},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.4119284451007843},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4094788432121277},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.21792516112327576},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1447872519493103}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8846454620361328},{"id":"https://openalex.org/C61341680","wikidata":"https://www.wikidata.org/wiki/Q1923256","display_name":"Intension","level":2,"score":0.7871994972229004},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6816627979278564},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6427421569824219},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6252477169036865},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5749882459640503},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5007832050323486},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4937475621700287},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.48187264800071716},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.47554394602775574},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4538728594779968},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4389636814594269},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4119284451007843},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4094788432121277},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.21792516112327576},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1447872519493103},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2462410.2462428","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2462410.2462428","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM symposium on Access control models and technologies","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.723.8106","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.723.8106","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://people.cs.pitt.edu/%7Eadamlee/pubs/2013/farnan2013sacmat.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.49000000953674316,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W1535576579","https://openalex.org/W2058442663"],"related_works":["https://openalex.org/W2007397391","https://openalex.org/W3025111826","https://openalex.org/W1992658322","https://openalex.org/W2554271401","https://openalex.org/W2150741898","https://openalex.org/W2186703450","https://openalex.org/W2970853428","https://openalex.org/W2955368753","https://openalex.org/W1461606193","https://openalex.org/W2034583622"],"abstract_inverted_index":{"Although":[0],"the":[1,28,79,86,94],"declarative":[2],"nature":[3],"of":[4,30,68,88,105,127],"SQL":[5,95,123],"provides":[6],"great":[7],"utility":[8],"to":[9,24,36,51,81,93,113],"database":[10,16],"users,":[11],"its":[12],"use":[13],"in":[14,21,44,125],"distributed":[15],"management":[17],"systems":[18],"can":[19,56],"result":[20],"unintended":[22],"consequences":[23],"user":[25],"privacy":[26],"over":[27],"course":[29],"query":[31,54,62,107],"evaluation.":[32],"By":[33],"allowing":[34],"users":[35,77],"merely":[37],"say":[38],"what":[39],"data":[40],"they":[41],"are":[42],"interested":[43],"accessing":[45],"without":[46],"providing":[47],"guidance":[48],"regarding":[49],"how":[50],"retrieve":[52],"it,":[53],"optimizers":[55],"generate":[57],"plans":[58,115],"that":[59,75,109,116],"leak":[60],"sensitive":[61],"intension.":[63],"To":[64],"address":[65],"these":[66,118],"types":[67],"issues,":[69],"we":[70,101,110],"have":[71,111],"created":[72],"a":[73,103],"framework":[74],"empowers":[76],"with":[78],"ability":[80],"specify":[82],"access":[83],"controls":[84],"on":[85],"intension":[87],"their":[89],"queries":[90,124],"through":[91],"extensions":[92],"SELECT":[96],"statement.":[97],"In":[98],"this":[99],"demonstration,":[100],"present":[102],"version":[104],"PostgreSQL's":[106],"optimizer":[108],"modified":[112],"produce":[114],"respect":[117],"constraints":[119],"while":[120],"optimizing":[121],"user-specified":[122],"terms":[126],"performance.":[128]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}