{"id":"https://openalex.org/W7160624885","doi":"https://doi.org/10.1109/tdsc.2026.3691474","title":"Element-Level Access Control on Encrypted SQL Tables Using CP-ABE: Optimized on Reusable Sub-Policy","display_name":"Element-Level Access Control on Encrypted SQL Tables Using CP-ABE: Optimized on Reusable Sub-Policy","publication_year":2026,"publication_date":"2026-05-08","ids":{"openalex":"https://openalex.org/W7160624885","doi":"https://doi.org/10.1109/tdsc.2026.3691474"},"language":null,"primary_location":{"id":"doi:10.1109/tdsc.2026.3691474","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2026.3691474","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/A5028608513","display_name":"Juhao Hu","orcid":null},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Juhao Hu","raw_affiliation_strings":["School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0009-2910-3795","affiliations":[{"raw_affiliation_string":"School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135646743","display_name":"Jing Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jing Wu","raw_affiliation_strings":["School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0003-2359-7084","affiliations":[{"raw_affiliation_string":"School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053052475","display_name":"Chengnian Long","orcid":"https://orcid.org/0000-0003-1668-1712"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chengnian Long","raw_affiliation_strings":["School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0003-1668-1712","affiliations":[{"raw_affiliation_string":"School of Automation and Intelligent Sensing, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I183067930"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.55753851,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"23","issue":"4","first_page":"9196","last_page":"9208"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","score":0.3828999996185303,"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.3828999996185303,"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.28769999742507935,"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"}},{"id":"https://openalex.org/T11424","display_name":"Security and Verification in Computing","score":0.13089999556541443,"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/encryption","display_name":"Encryption","score":0.586899995803833},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5605000257492065},{"id":"https://openalex.org/keywords/access-control","display_name":"Access control","score":0.5145000219345093},{"id":"https://openalex.org/keywords/control","display_name":"Control (management)","score":0.34779998660087585},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.32330000400543213},{"id":"https://openalex.org/keywords/cryptography","display_name":"Cryptography","score":0.3019999861717224},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.2924000024795532}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8668000102043152},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.586899995803833},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5605000257492065},{"id":"https://openalex.org/C527821871","wikidata":"https://www.wikidata.org/wiki/Q228502","display_name":"Access control","level":2,"score":0.5145000219345093},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46799999475479126},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3564999997615814},{"id":"https://openalex.org/C2775924081","wikidata":"https://www.wikidata.org/wiki/Q55608371","display_name":"Control (management)","level":2,"score":0.34779998660087585},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.32429999113082886},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.32330000400543213},{"id":"https://openalex.org/C178489894","wikidata":"https://www.wikidata.org/wiki/Q8789","display_name":"Cryptography","level":2,"score":0.3019999861717224},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.2924000024795532},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.2892000079154968},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.2824000120162964},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2824000120162964},{"id":"https://openalex.org/C70000936","wikidata":"https://www.wikidata.org/wiki/Q4672467","display_name":"Access method","level":2,"score":0.28110000491142273},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.2791999876499176},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.27639999985694885},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.26330000162124634},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.257999986410141}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tdsc.2026.3691474","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2026.3691474","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":[],"awards":[{"id":"https://openalex.org/G1153740917","display_name":null,"funder_award_id":"62273236","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2240670854","display_name":null,"funder_award_id":"62136006","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8323115622","display_name":null,"funder_award_id":"62473259","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"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"With":[0],"the":[1,26,63,115,150,155,159],"rapid":[2],"growth":[3],"of":[4,154],"cloud":[5],"computing,":[6],"securely":[7],"outsourcing":[8],"sensitive":[9],"data":[10,32],"has":[11],"become":[12],"crucial":[13],"for":[14,20,30,39],"protecting":[15],"user":[16,59],"privacy.":[17],"SQL,":[18],"renowned":[19],"its":[21,172],"expressiveness":[22],"and":[23,105,110,144,170,188,201],"flexibility,":[24],"remains":[25],"predominant":[27],"query":[28],"language":[29],"big":[31],"analytics.":[33],"However,":[34],"existing":[35],"access":[36,60,83,99],"control":[37,84],"mechanisms":[38],"encrypted":[40,86],"SQL":[41,87],"databases":[42],"primarily":[43],"operate":[44],"at":[45,62],"coarse":[46],"granularity":[47],"levels,":[48],"such":[49],"as":[50],"databases,":[51],"tables,":[52],"or":[53],"columns,":[54],"failing":[55],"to":[56,96,174,192],"meet":[57],"nuanced":[58],"requirements":[61],"individual":[64],"data-element":[65],"level.":[66],"To":[67,113],"address":[68],"this":[69],"challenge,":[70],"we":[71,129],"propose":[72],"<italic":[73],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"":[74,162],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">EGuardSQL</i>,":[75],"a":[76],"novel":[77],"architecture":[78],"that":[79,101,136,181],"enables":[80],"fine-grained,":[81],"element-level":[82],"over":[85],"tables.":[88],"Our":[89],"approach":[90],"leverages":[91],"Ciphertext-Policy":[92],"Attribute-Based":[93],"Encryption":[94],"(CP-ABE)":[95],"define":[97],"hybrid":[98],"policies":[100],"integrate":[102],"both":[103],"row-level":[104],"column-level":[106],"permissions,":[107],"facilitating":[108],"precise":[109],"flexible":[111],"control.":[112],"mitigate":[114],"inherent":[116],"computational":[117,187],"overhead":[118,200],"associated":[119],"with":[120,125],"CP-ABE,":[121],"particularly":[122],"when":[123],"dealing":[124],"complex":[126],"policy":[127],"structures,":[128],"introduce":[130],"an":[131],"optimized":[132],"reusable":[133],"sub-policy":[134],"mechanism":[135],"effectively":[137],"reduces":[138],"redundant":[139],"cryptographic":[140],"computations":[141],"during":[142],"encryption":[143],"decryption":[145],"processes.":[146],"We":[147],"formally":[148],"prove":[149],"selective":[151],"IND-CPA":[152],"security":[153,203],"EGuardSQL":[156,182],"scheme":[157],"under":[158],"decisional":[160],"<inline-formula":[161],"xmlns:xlink=\"http://www.w3.org/1999/xlink\"><tex-math":[163],"notation=\"LaTeX\">$q$</tex-math></inline-formula>-parallel":[164],"Bilinear":[165],"Diffie-Hellman":[166],"Exponent":[167],"(BDHE)":[168],"assumption":[169],"demonstrate":[171],"resistance":[173],"collusion":[175],"attacks.":[176],"Comprehensive":[177],"performance":[178],"evaluations":[179],"illustrate":[180],"achieves":[183],"significant":[184],"improvements":[185],"in":[186],"communication":[189],"efficiency":[190],"compared":[191],"conventional":[193],"CP-ABE":[194],"approaches,":[195],"while":[196],"maintaining":[197],"low":[198],"storage":[199],"robust":[202],"guarantees.":[204]},"counts_by_year":[],"updated_date":"2026-07-11T05:44:25.926202","created_date":"2026-05-09T00:00:00"}