{"id":"https://openalex.org/W4401621125","doi":"https://doi.org/10.1186/s13677-024-00692-y","title":"SSF-CDW: achieving scalable, secure, and fast OLAP query for encrypted cloud data warehouse","display_name":"SSF-CDW: achieving scalable, secure, and fast OLAP query for encrypted cloud data warehouse","publication_year":2024,"publication_date":"2024-08-15","ids":{"openalex":"https://openalex.org/W4401621125","doi":"https://doi.org/10.1186/s13677-024-00692-y"},"language":"en","primary_location":{"id":"doi:10.1186/s13677-024-00692-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-024-00692-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-024-00692-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-024-00692-y","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5082587353","display_name":"Somchart Fugkeaw","orcid":"https://orcid.org/0000-0001-7156-184X"},"institutions":[{"id":"https://openalex.org/I108108428","display_name":"Thammasat University","ror":"https://ror.org/002yp7f20","country_code":"TH","type":"education","lineage":["https://openalex.org/I108108428"]}],"countries":["TH"],"is_corresponding":true,"raw_author_name":"Somchart Fugkeaw","raw_affiliation_strings":["School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand"],"affiliations":[{"raw_affiliation_string":"School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand","institution_ids":["https://openalex.org/I108108428"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106535130","display_name":"Phatwasin Suksai","orcid":null},"institutions":[{"id":"https://openalex.org/I108108428","display_name":"Thammasat University","ror":"https://ror.org/002yp7f20","country_code":"TH","type":"education","lineage":["https://openalex.org/I108108428"]}],"countries":["TH"],"is_corresponding":false,"raw_author_name":"Phatwasin Suksai","raw_affiliation_strings":["School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand"],"affiliations":[{"raw_affiliation_string":"School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand","institution_ids":["https://openalex.org/I108108428"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008501314","display_name":"Lyhour Hak","orcid":"https://orcid.org/0009-0003-2247-555X"},"institutions":[{"id":"https://openalex.org/I108108428","display_name":"Thammasat University","ror":"https://ror.org/002yp7f20","country_code":"TH","type":"education","lineage":["https://openalex.org/I108108428"]}],"countries":["TH"],"is_corresponding":false,"raw_author_name":"Lyhour Hak","raw_affiliation_strings":["School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand"],"affiliations":[{"raw_affiliation_string":"School of ICT, Sirindhorn International Institute of Technology, Thammasat University, Pathum Thani, Thailand","institution_ids":["https://openalex.org/I108108428"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5082587353"],"corresponding_institution_ids":["https://openalex.org/I108108428"],"apc_list":{"value":990,"currency":"GBP","value_usd":1214},"apc_paid":{"value":990,"currency":"GBP","value_usd":1214},"fwci":2.044,"has_fulltext":true,"cited_by_count":6,"citation_normalized_percentile":{"value":0.88607553,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":98},"biblio":{"volume":"13","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":0.9997000098228455,"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.9997000098228455,"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.9995999932289124,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.998199999332428,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8610326051712036},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7655153274536133},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6996561884880066},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6885311603546143},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.648975133895874},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5136916041374207},{"id":"https://openalex.org/keywords/encryption","display_name":"Encryption","score":0.5000436305999756},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3224688768386841},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1373479664325714}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8610326051712036},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7655153274536133},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6996561884880066},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6885311603546143},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.648975133895874},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5136916041374207},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.5000436305999756},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3224688768386841},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1373479664325714}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1186/s13677-024-00692-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-024-00692-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-024-00692-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:9bc4d3aaf50a409ba1ebe4acb0305621","is_oa":true,"landing_page_url":"https://doaj.org/article/9bc4d3aaf50a409ba1ebe4acb0305621","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Cloud Computing: Advances, Systems and Applications, Vol 13, Iss 1, Pp 1-18 (2024)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1186/s13677-024-00692-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-024-00692-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-024-00692-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4412108025","display_name":null,"funder_award_id":"RGNS 65-110","funder_id":"https://openalex.org/F8970386038","funder_display_name":"Office of the Permanent Secretary, Ministry of Higher Education, Science, Research and Innovation, Thailand"},{"id":"https://openalex.org/G4697410336","display_name":null,"funder_award_id":"RGNS 65-110","funder_id":"https://openalex.org/F4320329432","funder_display_name":"Ministry of Higher Education, Science, Research and Innovation, Thailand"}],"funders":[{"id":"https://openalex.org/F4320323439","display_name":"Thammasat University","ror":"https://ror.org/002yp7f20"},{"id":"https://openalex.org/F4320329432","display_name":"Ministry of Higher Education, Science, Research and Innovation, Thailand","ror":null},{"id":"https://openalex.org/F4320329659","display_name":"Thailand Science Research and Innovation","ror":null},{"id":"https://openalex.org/F8970386038","display_name":"Office of the Permanent Secretary, Ministry of Higher Education, Science, Research and Innovation, Thailand","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4401621125.pdf","grobid_xml":"https://content.openalex.org/works/W4401621125.grobid-xml"},"referenced_works_count":23,"referenced_works":["https://openalex.org/W86391034","https://openalex.org/W151278352","https://openalex.org/W1971286892","https://openalex.org/W2075662269","https://openalex.org/W2086143755","https://openalex.org/W2111709307","https://openalex.org/W2292639983","https://openalex.org/W2315527922","https://openalex.org/W2365029783","https://openalex.org/W2781027040","https://openalex.org/W2803597621","https://openalex.org/W2949204976","https://openalex.org/W3087938787","https://openalex.org/W3189365666","https://openalex.org/W3201358629","https://openalex.org/W4212797794","https://openalex.org/W4318148206","https://openalex.org/W4320527391","https://openalex.org/W4385485232","https://openalex.org/W4386204703","https://openalex.org/W4391557759","https://openalex.org/W4393305191","https://openalex.org/W4399310961"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"Implementing":[0],"a":[1,38,95,106,178,185],"cloud-based":[2],"data":[3,11,61,89,99,115,164,180,214,222],"warehouse":[4,100],"to":[5,16,47,125,139,155,210,231],"store":[6],"sensitive":[7],"or":[8],"critical":[9],"strategic":[10],"presents":[12],"challenges":[13],"primarily":[14],"related":[15],"the":[17,20,24,30,77,120,131,157,160,207,211,225,233,273,276],"security":[18],"of":[19,26,79,159,218,235,260,275],"stored":[21],"information":[22],"and":[23,33,54,87,91,108,149,162,205,220,247,266],"exchange":[25],"OLAP":[27,48,121,141,168,173,268],"queries":[28,49,122,197],"between":[29,241],"cloud":[31,98,114],"server":[32],"users.":[34],"Although":[35],"encryption":[36,66,148],"is":[37,189,228],"viable":[39],"solution":[40,110],"for":[41,70,111,263],"safeguarding":[42],"outsourced":[43],"data,":[44,52],"applying":[45],"it":[46],"involving":[50],"multidimensional":[51],"measures,":[53],"Multidimensional":[55,167],"Expressions":[56],"(MDX)":[57],"operations":[58],"on":[59,85],"encrypted":[60,113,213,226],"poses":[62],"difficulties.":[63],"Existing":[64],"searchable":[65],"solutions":[67],"are":[68],"inadequate":[69],"handling":[71],"such":[72],"complex":[73],"queries,":[74,269],"which":[75,104,188],"complicates":[76],"use":[78],"business":[80],"intelligence":[81],"tools":[82],"that":[83,252],"rely":[84],"efficient":[86,172],"secure":[88,107],"processing":[90],"analysis.This":[92],"paper":[93],"proposes":[94],"new":[96,179],"privacy-preserving":[97],"scheme":[101],"called":[102],"SSF-CDW":[103,118],"facilitates":[105],"scalable":[109],"an":[112,190],"warehouse.":[116],"Our":[117],"improves":[119],"accessible":[123],"only":[124],"authorized":[126],"users":[127],"who":[128],"can":[129],"decrypt":[130],"query":[132,136,174,277],"results":[133,208],"with":[134,224],"improved":[135],"performance":[137],"compared":[138],"traditional":[140],"tools.":[142],"The":[143,216],"approach":[144,254],"involves":[145],"utilizing":[146],"symmetric":[147],"Ciphertext":[150],"Policy":[151],"Attribute-Based":[152],"Encryption":[153],"(CP-ABE)":[154],"protect":[156],"privacy":[158,274],"dimension":[161],"fact":[163,221],"modeled":[165],"in":[166,258],"(MOLAP).":[169],"To":[170],"support":[171],"execution,":[175],"we":[176],"proposed":[177,243],"cube":[181,227],"retrieval":[182],"mechanism":[183],"using":[184],"Redis":[186],"schema":[187],"in-memory":[191],"database.":[192],"This":[193],"technique":[194],"dynamically":[195],"compiles":[196],"by":[198],"disassembling":[199],"them":[200],"down":[201],"into":[202],"multiple":[203],"levels":[204],"consolidates":[206],"mapped":[209],"corresponding":[212],"cube.":[215],"caching":[217],"dimensional":[219],"associated":[223],"also":[229],"implemented":[230],"improve":[232],"speed":[234,262],"frequently":[236],"queried":[237],"data.":[238],"Experimental":[239],"comparisons":[240],"our":[242,253],"indexed":[244],"search":[245,261],"strategy":[246],"other":[248],"indexing":[249],"schemes":[250],"demonstrate":[251],"surpasses":[255],"alternative":[256],"techniques":[257],"terms":[259],"both":[264],"ad-hoc":[265],"repeated":[267],"all":[270],"while":[271],"preserving":[272],"results.":[278]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":5}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}