{"id":"https://openalex.org/W4392451859","doi":"https://doi.org/10.1080/09540091.2024.2323059","title":"SQL queries over encrypted databases: a survey","display_name":"SQL queries over encrypted databases: a survey","publication_year":2024,"publication_date":"2024-03-05","ids":{"openalex":"https://openalex.org/W4392451859","doi":"https://doi.org/10.1080/09540091.2024.2323059"},"language":"en","primary_location":{"id":"doi:10.1080/09540091.2024.2323059","is_oa":true,"landing_page_url":"https://doi.org/10.1080/09540091.2024.2323059","pdf_url":"https://www.tandfonline.com/doi/pdf/10.1080/09540091.2024.2323059?needAccess=true","source":{"id":"https://openalex.org/S4210188800","display_name":"Connection Science","issn_l":"0954-0091","issn":["0954-0091","1360-0494"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Connection Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.tandfonline.com/doi/pdf/10.1080/09540091.2024.2323059?needAccess=true","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5102115053","display_name":"Bo Sun","orcid":"https://orcid.org/0009-0005-3715-2600"},"institutions":[{"id":"https://openalex.org/I149594827","display_name":"Xidian University","ror":"https://ror.org/05s92vm98","country_code":"CN","type":"education","lineage":["https://openalex.org/I149594827"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bo Sun","raw_affiliation_strings":["School of Computer Science and Technology, Xidian University, Xi'an, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Xidian University, Xi'an, China","institution_ids":["https://openalex.org/I149594827"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101836987","display_name":"Sen Zhao","orcid":"https://orcid.org/0000-0003-3860-8647"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sen Zhao","raw_affiliation_strings":["State Key Laboratory of Integrated Service Networks, Xi'an, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Integrated Service Networks, Xi'an, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5013399667","display_name":"Guohua Tian","orcid":"https://orcid.org/0000-0002-9775-695X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Guohua Tian","raw_affiliation_strings":["State Key Laboratory of Integrated Service Networks, Xi'an, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Integrated Service Networks, Xi'an, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5013399667"],"corresponding_institution_ids":[],"apc_list":{"value":1270,"currency":"USD","value_usd":1270},"apc_paid":{"value":1270,"currency":"USD","value_usd":1270},"fwci":0.9762,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.78026938,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"36","issue":"1","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10237","display_name":"Cryptography and Data Security","score":1.0,"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":1.0,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9968000054359436,"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.8406360149383545},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6978179216384888},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6340066194534302},{"id":"https://openalex.org/keywords/encryption","display_name":"Encryption","score":0.5779355764389038},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4884475767612457},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.44697463512420654},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.09127876162528992}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8406360149383545},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6978179216384888},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6340066194534302},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.5779355764389038},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4884475767612457},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44697463512420654},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.09127876162528992}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1080/09540091.2024.2323059","is_oa":true,"landing_page_url":"https://doi.org/10.1080/09540091.2024.2323059","pdf_url":"https://www.tandfonline.com/doi/pdf/10.1080/09540091.2024.2323059?needAccess=true","source":{"id":"https://openalex.org/S4210188800","display_name":"Connection Science","issn_l":"0954-0091","issn":["0954-0091","1360-0494"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Connection Science","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:b908ba504cd74612b35605b0bdab9712","is_oa":false,"landing_page_url":"https://doaj.org/article/b908ba504cd74612b35605b0bdab9712","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Connection Science, Vol 36, Iss 1 (2024)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1080/09540091.2024.2323059","is_oa":true,"landing_page_url":"https://doi.org/10.1080/09540091.2024.2323059","pdf_url":"https://www.tandfonline.com/doi/pdf/10.1080/09540091.2024.2323059?needAccess=true","source":{"id":"https://openalex.org/S4210188800","display_name":"Connection Science","issn_l":"0954-0091","issn":["0954-0091","1360-0494"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Connection Science","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4392451859.pdf"},"referenced_works_count":83,"referenced_works":["https://openalex.org/W44936433","https://openalex.org/W1502708590","https://openalex.org/W1502927489","https://openalex.org/W1532434344","https://openalex.org/W1539859404","https://openalex.org/W1553146597","https://openalex.org/W1556683487","https://openalex.org/W1754574012","https://openalex.org/W1895952394","https://openalex.org/W1966416874","https://openalex.org/W1979514837","https://openalex.org/W1984462474","https://openalex.org/W1988374166","https://openalex.org/W1996453724","https://openalex.org/W2009128540","https://openalex.org/W2012056301","https://openalex.org/W2031533839","https://openalex.org/W2035871140","https://openalex.org/W2042012257","https://openalex.org/W2048401199","https://openalex.org/W2059160950","https://openalex.org/W2067768229","https://openalex.org/W2074388704","https://openalex.org/W2086763678","https://openalex.org/W2101631537","https://openalex.org/W2114296561","https://openalex.org/W2132172731","https://openalex.org/W2136936712","https://openalex.org/W2138001464","https://openalex.org/W2146828512","https://openalex.org/W2147929033","https://openalex.org/W2154496743","https://openalex.org/W2159915142","https://openalex.org/W2163992091","https://openalex.org/W2169046918","https://openalex.org/W2185907055","https://openalex.org/W2250570571","https://openalex.org/W2292693431","https://openalex.org/W2344670370","https://openalex.org/W2404098708","https://openalex.org/W2472177816","https://openalex.org/W2498209126","https://openalex.org/W2523477148","https://openalex.org/W2592789682","https://openalex.org/W2604861932","https://openalex.org/W2620918839","https://openalex.org/W2639926268","https://openalex.org/W2765456579","https://openalex.org/W2766780042","https://openalex.org/W2788385473","https://openalex.org/W2790080641","https://openalex.org/W2795193970","https://openalex.org/W2886130626","https://openalex.org/W2898477690","https://openalex.org/W2913096406","https://openalex.org/W2952698068","https://openalex.org/W2963053811","https://openalex.org/W2970420884","https://openalex.org/W2979771948","https://openalex.org/W2981797988","https://openalex.org/W3004727795","https://openalex.org/W3006791962","https://openalex.org/W3007218738","https://openalex.org/W3008509668","https://openalex.org/W3012623189","https://openalex.org/W3031749496","https://openalex.org/W3112962245","https://openalex.org/W3116592023","https://openalex.org/W3122422767","https://openalex.org/W3125665830","https://openalex.org/W3134573374","https://openalex.org/W3151309405","https://openalex.org/W3152901657","https://openalex.org/W3172850950","https://openalex.org/W3196996325","https://openalex.org/W3213787872","https://openalex.org/W4236786653","https://openalex.org/W4293783486","https://openalex.org/W4366503934","https://openalex.org/W4376456651","https://openalex.org/W4382983058","https://openalex.org/W4387886077","https://openalex.org/W6712237015"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W2902831276","https://openalex.org/W2540682188","https://openalex.org/W4385834214","https://openalex.org/W3022423983","https://openalex.org/W12347151","https://openalex.org/W2957025774","https://openalex.org/W1575529579"],"abstract_inverted_index":{"Limited":[0],"by":[1],"the":[2,15,30,39,73,103,132,145],"local":[3],"storage":[4],"resource,":[5],"data":[6,12,25],"users":[7],"have":[8],"to":[9,18,21,49,62,91],"encrypt":[10],"their":[11,160],"and":[13,43,53,95,115,124,135,139,147,156,175,195,201],"outsource":[14],"encrypted":[16,69],"databases":[17],"cloud":[19],"servers":[20],"enjoy":[22],"low-cost,":[23],"professional":[24],"management":[26],"services,":[27],"which":[28],"promotes":[29],"rapid":[31],"development":[32],"of":[33,67,75,122,137,152,172,183],"outsourcing":[34],"database":[35,46,70],"technology.":[36],"Despite":[37],"this,":[38],"complex":[40,192,200],"underlying":[41,76],"setting":[42],"loosely":[44],"coupled":[45],"architecture":[47],"lead":[48],"various":[50],"security":[51,78,96],"risks":[52],"performance":[54,197],"bottlenecks,":[55],"while":[56],"there":[57],"is":[58],"currently":[59],"no":[60],"work":[61],"achieve":[63,180,190],"a":[64,120],"comprehensive":[65],"evaluation":[66,89],"existing":[68,104],"solutions":[71,188],"from":[72,97,150],"aspects":[74],"settings,":[77],"levels,":[79],"functions,":[80],"etc.":[81],"In":[82,185],"this":[83,128],"work,":[84],"we":[85,101,130,143],"first":[86],"propose":[87],"an":[88],"model":[90],"assess":[92],"SQL":[93,105,153,165,193],"functionalities":[94],"multiple":[98],"dimensions.":[99],"Secondly,":[100],"categorise":[102],"query":[106,166],"schemes":[107,167],"into":[108],"three":[109],"categories:":[110],"software-based":[111,146],"construction,":[112,114,117],"hardware-based":[113,148,187],"hybrid-based":[116],"that":[118,168],"is,":[119],"combination":[121],"software":[123],"hardware":[125],"components.":[126],"On":[127],"basis,":[129],"analyse":[131],"framework,":[133],"advantages,":[134],"limitations":[136],"classic":[138],"state-of-the-art":[140],"schemes.":[141],"Finally,":[142],"summarise":[144],"approaches":[149],"dimensions":[151],"functionality,":[154],"security,":[155],"efficiency,":[157],"thus":[158],"clarifying":[159],"ideal":[161],"application":[162],"scenarios.":[163],"Notably,":[164],"exhibit":[169],"minimal":[170],"equality":[171],"pair":[173],"leakage":[174],"support":[176],"strong":[177],"obliviousness":[178],"can":[179,189],"higher":[181],"levels":[182],"security.":[184],"addition,":[186],"more":[191],"queries":[194],"superior":[196],"without":[198],"designing":[199],"functionally-limited":[202],"cryptographic":[203],"tools.":[204]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2026-05-06T08:25:59.206177","created_date":"2025-10-10T00:00:00"}