{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:03:19Z","timestamp":1781107399692,"version":"3.54.1"},"reference-count":35,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018,10]]},"abstract":"<jats:p>A cloud data warehouse (cloud DW) is a subject-oriented, integrated, time-variant, voluminous, nonvolatile and multidimensional distributed database that is hosted in a cloud. A solution to ensure data confidentiality for a cloud DW is cryptography. In this article, the authors propose an encryption methodology for a cloud DW stored according to the star schema, considering both the data confidentiality maintenance of the DW and the capability of processing analytical queries directly over the encrypted DW. The proposed encryption methodology comprises an encryption strategy for DW called MV-HO (MultiValued and HOmomorphic) for the definition of how the different types of DW's attributes must be encrypted. The proposed MV-HO encryption strategy was compared with encryption strategies based on symmetric encryption, order preserving symmetric encryption and homomorphic encryption. Results indicated that MV-HO is the best solution found, as MV-HO is pareto-optimal with respect to other strategies investigated.<\/jats:p>","DOI":"10.4018\/ijdwm.2018100103","type":"journal-article","created":{"date-parts":[[2018,9,26]],"date-time":"2018-09-26T13:08:09Z","timestamp":1537967289000},"page":"38-66","source":"Crossref","is-referenced-by-count":1,"title":["An Encryption Methodology for Enabling the Use of Data Warehouses on the Cloud"],"prefix":"10.4018","volume":"14","author":[{"given":"Claudivan Cruz","family":"Lopes","sequence":"first","affiliation":[{"name":"Federal Institute of Education, Science and Technology of Para\u00edba, Patos, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Val\u00e9ria","family":"Ces\u00e1rio-Times","sequence":"additional","affiliation":[{"name":"Federal University of Pernambuco, Recife, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Stan","family":"Matwin","sequence":"additional","affiliation":[{"name":"Dalhousie University, Nova Scotia, Canada & Institute of Computer Science, Polish Academy of Sciences, Warsaw, Poland"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Cristina Dutra de Aguiar","family":"Ciferri","sequence":"additional","affiliation":[{"name":"University of S\u00e3o Paulo, S\u00e3o Paulo, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ricardo Rodrigues","family":"Ciferri","sequence":"additional","affiliation":[{"name":"Federal University of S\u00e3o Carlos, S\u00e3o Carlos, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"IJDWM.2018100103-0","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007632"},{"key":"IJDWM.2018100103-1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066187"},{"key":"IJDWM.2018100103-2","doi-asserted-by":"publisher","DOI":"10.4018\/ijdwm.2015040102"},{"key":"IJDWM.2018100103-3","first-page":"224","article-title":"Order-preserving symmetric encryption.","author":"A.Boldyreva","year":"2009","journal-title":"28th Annual International Conference on the Theory and Applications of Cryptographic Techniques (EUROCRYPT\u201909)"},{"key":"IJDWM.2018100103-4","doi-asserted-by":"crossref","unstructured":"Castelluccia, C., Chan, A. C. F., Mykletun, E., & Tsudik, G. (2009). Efficient and provably secure aggregation of encrypted data in wireless sensor networks. ACM Transactions on Sensor Networks, 5(3). 2036.","DOI":"10.1145\/1525856.1525858"},{"key":"IJDWM.2018100103-5","first-page":"47","article-title":"A distance function-based multi-objective evolutionary algorithm.","author":"W. C.Chang","year":"2003","journal-title":"2003 Genetic and Evolutionary Computation Conference (GECCO\u201903)"},{"key":"IJDWM.2018100103-6","doi-asserted-by":"publisher","DOI":"10.1145\/1943513.1943547"},{"key":"IJDWM.2018100103-7","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2006.30"},{"key":"IJDWM.2018100103-8","doi-asserted-by":"crossref","unstructured":"Fuller, B., Varia, M., Yerukhimovich, A., Shen, E., & Hamlin, A. (2017). SoK: cryptographically protected database search.","DOI":"10.1109\/SP.2017.10"},{"key":"IJDWM.2018100103-9","doi-asserted-by":"publisher","DOI":"10.1109\/ICIS.2015.7166672"},{"key":"IJDWM.2018100103-10","doi-asserted-by":"publisher","DOI":"10.1109\/ICIW.2009.31"},{"key":"IJDWM.2018100103-11","doi-asserted-by":"crossref","unstructured":"Kadhem, H., Amagasa, T., & Kitagawa H. (2010). MV-OPES: Multivalued-order preserving encryption scheme: a novel scheme for encrypting integer value to many different values. IEICE Transactions on Information and Systems, 93(9), 2520-2533.","DOI":"10.1587\/transinf.E93.D.2520"},{"key":"IJDWM.2018100103-12","doi-asserted-by":"crossref","first-page":"338","DOI":"10.1007\/978-3-642-29764-9_23","article-title":"Optimization techniques for range queries in the multivalued-partial order preserving encryption scheme.","author":"H.Kadhem","year":"2013","journal-title":"International Joint Conference on Knowledge Discovery, Knowledge Engineering, and Knowledge Management"},{"key":"IJDWM.2018100103-13","doi-asserted-by":"publisher","DOI":"10.1109\/NSysS.2016.7400708"},{"key":"IJDWM.2018100103-14","author":"R.Kimball","year":"2002","journal-title":"The data warehouse toolkit: the definitive guide to dimensional modeling"},{"key":"IJDWM.2018100103-15","doi-asserted-by":"crossref","unstructured":"Liu, D. (2014). Securing outsourced databases in the cloud. Security, Privacy and Trust in Cloud Systems. 259-282.","DOI":"10.1007\/978-3-642-38586-5_9"},{"key":"IJDWM.2018100103-16","doi-asserted-by":"crossref","first-page":"1049","DOI":"10.1145\/2382196.2382321","article-title":"Query encrypted databases practically.","author":"D.Liu","year":"2012","journal-title":"19th ACM Conference on Computer and Communications Security (CCS\u201912)"},{"key":"IJDWM.2018100103-17","doi-asserted-by":"publisher","DOI":"10.1002\/cpe.2992"},{"key":"IJDWM.2018100103-18","doi-asserted-by":"publisher","DOI":"10.1145\/2695664.2695805"},{"key":"IJDWM.2018100103-19","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-10160-6_18"},{"key":"IJDWM.2018100103-20","doi-asserted-by":"publisher","DOI":"10.1007\/s10619-015-7176-z"},{"key":"IJDWM.2018100103-21","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-10424-4_17"},{"key":"IJDWM.2018100103-22","doi-asserted-by":"publisher","DOI":"10.1145\/2330667.2330691"},{"key":"IJDWM.2018100103-23","doi-asserted-by":"publisher","DOI":"10.1109\/BHI.2016.7455821"},{"key":"IJDWM.2018100103-24","first-page":"293","article-title":"On building XML data warehouses.","author":"L. I.Rusu","year":"2004","journal-title":"5th International Conference on Intelligent Data Engineering and Automated Learning (IDEAL\u201904)"},{"key":"IJDWM.2018100103-25","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2005040102"},{"key":"IJDWM.2018100103-26","doi-asserted-by":"publisher","DOI":"10.1109\/EUROCON.2011.5929314"},{"key":"IJDWM.2018100103-27","first-page":"191","article-title":"Description of a new variable-length key, 64-bit block cipher (blowfish).","author":"B.Schneier","year":"1993","journal-title":"International Workshop on Fast Software Encryption (FSE\u20191993)"},{"key":"IJDWM.2018100103-28","doi-asserted-by":"publisher","DOI":"10.1145\/359168.359176"},{"key":"IJDWM.2018100103-29","doi-asserted-by":"crossref","unstructured":"Shmueli, E., Waisenberg, R., Elovici, Y., & Gudes, E. (2005). Designing secure indexes for encrypted databases. In 19th Annual IFIP WG 11.3 Working Conference on Data and Applications Security (IFIP WG11.3\u201905), Storrs, CT (pp. 54-68).","DOI":"10.1007\/11535706_5"},{"key":"IJDWM.2018100103-30","doi-asserted-by":"publisher","DOI":"10.1145\/2330667.2330690"},{"key":"IJDWM.2018100103-31","first-page":"289","article-title":"Processing analytical queries over encrypted data.","author":"S.Tu","year":"2013","journal-title":"39th International Conference on Very Large Data Bases (VLDB\u201913)"},{"key":"IJDWM.2018100103-32","doi-asserted-by":"crossref","unstructured":"Vimercati, S. D. C. D., Foresti, S., Jajodia, S., Paraboschi, S., & Samarati P. (2010). Encryption policies for regulating access to outsourced data. ACM Transactions on Database Systems, 35(2), 12:1-12:46.","DOI":"10.1145\/1735886.1735891"},{"key":"IJDWM.2018100103-33","first-page":"150","article-title":"Implementation of encrypted data for outsourced satabase.","author":"Z. F.Wang","year":"2010","journal-title":"2nd International Conference on Computational Intelligence and Natural Computing (CINC\u201910)"},{"key":"IJDWM.2018100103-34","doi-asserted-by":"publisher","DOI":"10.1109\/TIFS.2016.2527620"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=215005","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,9,5]],"date-time":"2023-09-05T07:56:10Z","timestamp":1693900570000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJDWM.2018100103"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2018,10]]},"references-count":35,"journal-issue":{"issue":"4"},"URL":"https:\/\/doi.org\/10.4018\/ijdwm.2018100103","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,10]]}}}