{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,3,13]],"date-time":"2024-03-13T12:23:29Z","timestamp":1710332609301},"reference-count":27,"publisher":"IGI Global","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2014,10,1]]},"abstract":"<p>With the development of cloud computing and big data, data privacy protection has become an urgent problem to solve. Data encryption is the most effective way to protect privacy; however, it will change the data format and result in: 1. database structure and application software will be changed; 2. structured query language (SQL) operations cannot work properly, especially in SQL-based fuzzy query. As a result, it is necessary to provide an SQL-based fuzzy query mechanism over encrypted databases, including traditional databases and cloud outsourced databases. This paper establishes a secure database system using format-preserving encryption (FPE) as the underlying primitive to protect the data privacy while not change the database structure. It further proposes a new SQL-based fuzzy query mechanism supporting directly query over encrypted data, which is constructed by FPE and universal hash function (UHF). The security of the proposed mechanism is analyzed as well. In the end, it makes extensive experiments on the system to demonstrate its practical performance.<\/p>","DOI":"10.4018\/ijdwm.2014100104","type":"journal-article","created":{"date-parts":[[2014,10,20]],"date-time":"2014-10-20T16:05:21Z","timestamp":1413821121000},"page":"71-87","source":"Crossref","is-referenced-by-count":11,"title":["SQL-Based Fuzzy Query Mechanism Over Encrypted Database"],"prefix":"10.4018","volume":"10","author":[{"given":"Zheli","family":"Liu","sequence":"first","affiliation":[{"name":"College of Computer and Control Engineering, Nankai University, Tianjin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jingwei","family":"Li","sequence":"additional","affiliation":[{"name":"College of Computer and Control Engineering, Nankai University, Tianjin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jin","family":"Li","sequence":"additional","affiliation":[{"name":"School of Computer Science, Guangzhou University, Guangzhou, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chunfu","family":"Jia","sequence":"additional","affiliation":[{"name":"College of Computer and Control Engineering, Nankai University, Tianjin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jun","family":"Yang","sequence":"additional","affiliation":[{"name":"College of Computer and Control Engineering, Nankai University, Tianjin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ke","family":"Yuan","sequence":"additional","affiliation":[{"name":"College of Computer and Control Engineering, Nankai University, Tianjin, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"2432","reference":[{"key":"ijdwm.2014100104-0","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007632"},{"key":"ijdwm.2014100104-1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-73538-0_2"},{"key":"ijdwm.2014100104-2","doi-asserted-by":"publisher","DOI":"10.1504\/IJBIDM.2007.012945"},{"key":"ijdwm.2014100104-3","unstructured":"Bellare, M., Rogaway, P., & Spies, T. (2010). The FFX mode of operation for format-preserving encryption. Unpublished NIST proposal."},{"key":"ijdwm.2014100104-4","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-45760-7_9"},{"key":"ijdwm.2014100104-5","doi-asserted-by":"crossref","unstructured":"Boldyreva, A., Chenette, N., Lee, Y., & O\u00a1\u00afneill, A. (2009). Order-preserving symmetric encryption. In Advances in Cryptology (EUROCRYPT 2009) (pp. 224-241). Springer Berlin Heidelberg.","DOI":"10.1007\/978-3-642-01001-9_13"},{"key":"ijdwm.2014100104-6","doi-asserted-by":"publisher","DOI":"10.1145\/800105.803400"},{"key":"ijdwm.2014100104-7","doi-asserted-by":"publisher","DOI":"10.1145\/1180405.1180417"},{"key":"ijdwm.2014100104-8","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-74835-9_22"},{"key":"ijdwm.2014100104-9","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564717"},{"key":"ijdwm.2014100104-10","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-45706-2_48"},{"key":"ijdwm.2014100104-11","doi-asserted-by":"publisher","DOI":"10.1109\/INFCOM.2010.5462196"},{"key":"ijdwm.2014100104-12","doi-asserted-by":"publisher","DOI":"10.4304\/jnw.7.8.1239-1244"},{"key":"ijdwm.2014100104-13","doi-asserted-by":"crossref","first-page":"201","DOI":"10.1109\/ICICISYS.2010.5658769","article-title":"Format-preserving encryption for datetime.","volume":"Vol. 2","author":"Z.Liu","year":"2010","journal-title":"Proceedings of the 2010 IEEE International Conference on Intelligent Computing and Intelligent Systems (ICIS)"},{"key":"ijdwm.2014100104-14","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-38631-2_32"},{"key":"ijdwm.2014100104-15","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-03356-8_17"},{"key":"ijdwm.2014100104-16","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-34047-5_19"},{"key":"ijdwm.2014100104-17","doi-asserted-by":"publisher","DOI":"10.1109\/SP.2013.38"},{"key":"ijdwm.2014100104-18","doi-asserted-by":"publisher","DOI":"10.1145\/2043556.2043566"},{"key":"ijdwm.2014100104-19","doi-asserted-by":"publisher","DOI":"10.1109\/SECPRI.2000.848445"},{"key":"ijdwm.2014100104-20","doi-asserted-by":"publisher","DOI":"10.1002\/9780470391365"},{"key":"ijdwm.2014100104-21","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-13190-5_2"},{"key":"ijdwm.2014100104-22","doi-asserted-by":"publisher","DOI":"10.1109\/INFCOM.2012.6195784"},{"key":"ijdwm.2014100104-23","doi-asserted-by":"publisher","DOI":"10.1109\/ICDCSW.2011.16"},{"key":"ijdwm.2014100104-24","first-page":"1027","article-title":"Fast query over encrypted character data in database","author":"Z. F.Wang","year":"2005","journal-title":"Computational and Information Science"},{"key":"ijdwm.2014100104-25","doi-asserted-by":"publisher","DOI":"10.1016\/0022-0000(81)90033-7"},{"key":"ijdwm.2014100104-26","doi-asserted-by":"crossref","unstructured":"Yang, Z., Zhong, S., & Wright, R. N. (2006). Privacy-preserving queries on encrypted data. In Computer Security (ESORICS 2006) (pp. 479-495). Springer Berlin Heidelberg.","DOI":"10.1007\/11863908_29"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=117159","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:48:23Z","timestamp":1654116503000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijdwm.2014100104"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2014,10,1]]},"references-count":27,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2014,10]]}},"URL":"https:\/\/doi.org\/10.4018\/ijdwm.2014100104","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2014,10,1]]}}}