{"id":"https://openalex.org/W2054844101","doi":"https://doi.org/10.4018/ijdwm.2014100104","title":"SQL-Based Fuzzy Query Mechanism Over Encrypted Database","display_name":"SQL-Based Fuzzy Query Mechanism Over Encrypted Database","publication_year":2014,"publication_date":"2014-10-01","ids":{"openalex":"https://openalex.org/W2054844101","doi":"https://doi.org/10.4018/ijdwm.2014100104","mag":"2054844101"},"language":"en","primary_location":{"id":"doi:10.4018/ijdwm.2014100104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2014100104","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","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/A5060212061","display_name":"Zheli Liu","orcid":"https://orcid.org/0000-0002-2984-2661"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Zheli Liu","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034762138","display_name":"Jingwei Li","orcid":"https://orcid.org/0000-0001-8457-0454"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]},{"id":"https://openalex.org/I37987034","display_name":"Guangzhou University","ror":"https://ror.org/05ar8rn06","country_code":"CN","type":"education","lineage":["https://openalex.org/I37987034"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jingwei Li","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China","School of Computer Science, Guangzhou University, Guangzhou, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]},{"raw_affiliation_string":"School of Computer Science, Guangzhou University, Guangzhou, China","institution_ids":["https://openalex.org/I37987034"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023173849","display_name":"Li Jin","orcid":"https://orcid.org/0000-0002-7898-8405"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]},{"id":"https://openalex.org/I37987034","display_name":"Guangzhou University","ror":"https://ror.org/05ar8rn06","country_code":"CN","type":"education","lineage":["https://openalex.org/I37987034"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jin Li","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China","School of Computer Science, Guangzhou University, Guangzhou, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]},{"raw_affiliation_string":"School of Computer Science, Guangzhou University, Guangzhou, China","institution_ids":["https://openalex.org/I37987034"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005646333","display_name":"Chunfu Jia","orcid":"https://orcid.org/0000-0002-5588-9690"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chunfu Jia","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101801967","display_name":"Jun Yang","orcid":"https://orcid.org/0000-0001-7888-2187"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun Yang","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5079760696","display_name":"Ke Yuan","orcid":"https://orcid.org/0000-0002-9388-5690"},"institutions":[{"id":"https://openalex.org/I205237279","display_name":"Nankai University","ror":"https://ror.org/01y1kjr75","country_code":"CN","type":"education","lineage":["https://openalex.org/I205237279"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ke Yuan","raw_affiliation_strings":["College of Computer and Control Engineering, Nankai University, Tianjin, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer and Control Engineering, Nankai University, Tianjin, China","institution_ids":["https://openalex.org/I205237279"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5060212061"],"corresponding_institution_ids":["https://openalex.org/I205237279"],"apc_list":null,"apc_paid":null,"fwci":2.9595,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.92225577,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"10","issue":"4","first_page":"71","last_page":"87"},"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/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9994999766349792,"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.9976999759674072,"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.8996596336364746},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.7189540863037109},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7042592763900757},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6920616030693054},{"id":"https://openalex.org/keywords/encryption","display_name":"Encryption","score":0.6223329305648804},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6198315620422363},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4969196617603302},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4881335198879242},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.45968812704086304},{"id":"https://openalex.org/keywords/cloud-database","display_name":"Cloud database","score":0.4171743392944336},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4051807224750519},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.38067102432250977},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36913207173347473},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3152989447116852},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.30682310461997986},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.14243978261947632},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08376970887184143},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.0697333812713623}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8996596336364746},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7189540863037109},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7042592763900757},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6920616030693054},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.6223329305648804},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6198315620422363},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4969196617603302},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4881335198879242},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.45968812704086304},{"id":"https://openalex.org/C2778974508","wikidata":"https://www.wikidata.org/wiki/Q2499178","display_name":"Cloud database","level":3,"score":0.4171743392944336},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4051807224750519},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.38067102432250977},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36913207173347473},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3152989447116852},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.30682310461997986},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.14243978261947632},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08376970887184143},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0697333812713623}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijdwm.2014100104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2014100104","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:10:y:2014:i:4:p:71-87","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/ijdwm.2014100104","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W124928283","https://openalex.org/W1481785025","https://openalex.org/W1483091879","https://openalex.org/W1535147830","https://openalex.org/W1556640847","https://openalex.org/W1560562394","https://openalex.org/W1596609552","https://openalex.org/W1895952394","https://openalex.org/W1973735641","https://openalex.org/W1982763286","https://openalex.org/W1985623009","https://openalex.org/W1989455386","https://openalex.org/W2030888439","https://openalex.org/W2043508455","https://openalex.org/W2117740674","https://openalex.org/W2122590785","https://openalex.org/W2123975394","https://openalex.org/W2132034299","https://openalex.org/W2135157467","https://openalex.org/W2146828512","https://openalex.org/W2147929033","https://openalex.org/W2154496743","https://openalex.org/W2156030242","https://openalex.org/W2159915142","https://openalex.org/W2169660454","https://openalex.org/W2284660031"],"related_works":["https://openalex.org/W2406556739","https://openalex.org/W644450836","https://openalex.org/W1548279772","https://openalex.org/W2554271401","https://openalex.org/W2970853428","https://openalex.org/W2334227691","https://openalex.org/W4244527061","https://openalex.org/W2152149667","https://openalex.org/W2186703450","https://openalex.org/W2119118464"],"abstract_inverted_index":{"With":[0],"the":[1,22,33,97,102,108,139,147,154],"development":[2],"of":[3,138],"cloud":[4,82],"computing":[5],"and":[6,36,42,81,131],"big":[7],"data,":[8,125],"data":[9,34,103],"privacy":[10,104],"protection":[11],"has":[12],"become":[13],"an":[14,70],"urgent":[15],"problem":[16],"to":[17,26,68,100,156],"solve.":[18],"Data":[19],"encryption":[20,94],"is":[21,66,127,142],"most":[23],"effective":[24],"way":[25],"protect":[27,101],"privacy;":[28],"however,":[29],"it":[30,65,149],"will":[31,45],"change":[32,107],"format":[35],"result":[37],"in:":[38],"1.":[39],"database":[40,90,109],"structure":[41],"application":[43],"software":[44],"be":[46],"changed;":[47],"2.":[48],"structured":[49],"query":[50,73,118,122],"language":[51],"(SQL)":[52],"operations":[53],"cannot":[54],"work":[55],"properly,":[56],"especially":[57],"in":[58],"SQL-based":[59,71,116],"fuzzy":[60,72,117],"query.":[61],"As":[62],"a":[63,88,114],"result,":[64],"necessary":[67],"provide":[69],"mechanism":[74,119,141],"over":[75,123],"encrypted":[76,124],"databases,":[77],"including":[78],"traditional":[79],"databases":[80],"outsourced":[83],"databases.":[84],"This":[85],"paper":[86],"establishes":[87],"secure":[89],"system":[91,155],"using":[92],"format-preserving":[93],"(FPE)":[95],"as":[96,144],"underlying":[98],"primitive":[99],"while":[105],"not":[106],"structure.":[110],"It":[111],"further":[112],"proposes":[113],"new":[115],"supporting":[120],"directly":[121],"which":[126],"constructed":[128],"by":[129],"FPE":[130],"universal":[132],"hash":[133],"function":[134],"(UHF).":[135],"The":[136],"security":[137],"proposed":[140],"analyzed":[143],"well.":[145],"In":[146],"end,":[148],"makes":[150],"extensive":[151],"experiments":[152],"on":[153],"demonstrate":[157],"its":[158],"practical":[159],"performance.":[160]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":4}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}