• Home
  • Search
  • Mechanism for securing cloud based data warehouse schema
  • Cite Icon5
  • https://doi.org/10.1007/s41870-020-00546-1Copy DOI Icon

Mechanism for securing cloud based data warehouse schema

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Several studies have recommended encryption of data for securing Data Warehouse (DW) stored in hostile cloud networks. Most of the published work on encrypted DWs encrypts the DW data while DW Schema, i.e., Fact and Dimension table’s name and their attributes, remain unprotected. Unencrypted DW schema attributes may reveal critical information about the data contents to the cloud administrators or attackers. In this paper, we propose a novel mechanism for encrypting column names of DW’s fact and dimension tables, which in turn protect the revelation of details of interesting columns to the cloud network. For this, we have proposed a customized method for encryption of column names of facts and dimension tables and implemented it in MySQL’s column name restrictions to test its validity. This paper also introduces an Enhanced Encryption Model for Data Warehouse, which provides a complete solution for securing data warehouse. Here, the column name gets encrypted with the help of keys from a secure host without the revelation of security details to the cloud network. It reduces the attacker’s ability to target strategically important columns such as sales figures, cost, etc. As a result, it increases attacker effort by (n – k − W)/(n − k) in case of a weighted column scenario. Here, ‘n’ is the total number of columns, ‘k’, and ‘W’ is the number of unencrypted and encrypted columns, respectively. We have also conducted a performance analysis of the proposed mechanism on the standard TPC-H database for both encryption and decryption cycles.

Similar Papers
  • Research Article
  • Citations11

Multiversion join index for multiversion data warehouse

  • Jan 26, 2008
  • Information and Software Technology
  • Jan Chmiel +2
  • Research Article
  • Citations3

Data Warehouse Design for Firefighters Operational at the DKI Jakarta Fire Department

  • Feb 27, 2024
  • TEM Journal
  • Harco Leslie Hendric Spits Warnars +4
  • Research Article

Data warehouse model for population registration in Kerambitan village Tabanan Regency

  • Jan 25, 2020
  • JELIKU (Jurnal Elektronik Ilmu Komputer Udayana)
  • Fathiyarizq Mahendra Putra +1
  • Research Article
  • Citations1

Model data warehouse untuk Operasional petugas pemadam kebakaran Pada dinas pemadam kebakaran provinsi DKI Jakarta

  • Apr 09, 2019
  • Jurnal Ilmu Komputer
  • Kharis Munawar +1
  • Research Article
  • Citations33

Referential Horizontal Partitioning Selection Problem in Data Warehouses

  • Oct 01, 2009
  • International Journal of Data Warehousing and Mining
  • Ladjel Bellatreche +3
  • Conference Article
  • Citations18

Dimension table driven approach to referential partition relational data warehouses

  • Nov 06, 2009
  • Ladjel Bellatreche +1
  • Book Chapter
  • Citations7

Dimension Table Selection Strategies to Referential Partition a Fact Table of Relational Data Warehouses

  • Aug 20, 2011
  • Ladjel Bellatreche
  • Book Chapter
  • Citations1

Design and Implementation of an Improved Data Warehouse on Clinical Data

  • Jan 01, 2019
  • Nilkantha Garain +4
  • Conference Article
  • Citations17

Cache conscious star-join in MapReduce environments

  • Aug 26, 2013
  • Guoliang Zhou +2
  • Book Chapter
  • Citations4

Slowly Changing Dimension Handling in Data Warehouses Using Temporal Database Features

  • Jan 01, 2019
  • Thanapol Phungtua-Eng +1
  • Conference Article
  • Citations14

A Framework to Convert XML Schema to ROLAP

  • Feb 01, 2011
  • Sarbani Dasgupta +2
  • Research Article
  • Citations9

Handling measurement function changes with Slowly Changing Measures

  • Jan 07, 2015
  • Information Systems
  • Mathias Goller +1
  • Book Chapter

8 - Dimensions

  • Jan 01, 2005
  • Oracle 10g Data Warehousing
  • Lilian Hobbs +3
  • Conference Article
  • Citations4

Performance comparison slowly changing dimensions using model relational and object-relational

  • Nov 01, 2015
  • Angelica Urrutia Sepulveda +2
  • PDF
  • Research Article
  • Citations9

DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI

  • Oct 01, 2011
  • Jurnal Informatika
  • Spits Warnars
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.