A Pragmatic Approach to Conceptual Modeling of OLAP Security

Priebe, Torsten; Pernul, Günther

doi:10.1007/3-540-45581-7_24

Cited by 43 publications

(34 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…In this sense, we find the work of [2], which proposed the use of the permits schema de-fined for federated databases without any modification to build a secure Data Warehouse, and [3] that propose revising requests in order to verify that they comply with the limitations determined in the sources.  Some writers [19] [20] aimed to make the access assure model in the Data Warehouse, from data beginnings, while others [16] [26] have conceived this suggestion as difficult since the source data arise from unlike systems (with different policies). And functional systems use the relational model while the OLAP organizations use the multidimensional example.…”

Section: Synthesismentioning

confidence: 99%

“… The circumspection of the Data Warehouse has traditionally been conceived in the authoritative carrying out of a Data Warehouse [16] [17], nevertheless the latest works [14] [18] believe its inclusion body in the growth levels which can develop more full-bodied lineament results, and the system can adapt these security demands in a more innate way.  In the explore work [5], the authors aimed an reflex MDA architecture established on the UML denotation to assure a Data Warehouse, but the doubtfulness that develops in this case is: What is the use of précising the protection level in the user visibility as well as for the elements of the Data Warehouse since the licenses are defined.…”

Section: Synthesismentioning

confidence: 99%

See 1 more Smart Citation

Active Categorization of Sensibility Degrees of Datawarehouse Established on User Visibilities

Siddiqua

Sabeer

Soni³

2017

IJARCSSE

View full text Add to dashboard Cite

A data warehouse arsenals confidential information about the privateness of someone and significant commercial activity. This builds admittance to this origin a risk of revelation of information. Therefore the importances of enforcing security which ensure the data discretion by demonstrating an accession control policy. In this centering, several suggestions were made, but none are conceived as a standard for access direction to data warehouses. In this paper, we will demonstrate our advance that appropriates first to exploit the permits determined in the data sources in order to help the executive to define access licenses to the data warehouse, and then our system will automatically give the sensitivity level of each data warehouse component according to the permits granted to an object in the data warehouse.

show abstract

Section: Synthesismentioning

confidence: 99%

Section: Synthesismentioning

confidence: 99%

Active Categorization of Sensibility Degrees of Datawarehouse Established on User Visibilities

Siddiqua

Sabeer

Soni³

2017

IJARCSSE

View full text Add to dashboard Cite

show abstract

“…The authors in [10] proposed a set of security policies which are based on the UML (Unified Modeling Language). According to the authors, UML (Unified Modeling Language) is not appropriate for modeling security constraints in data warehouse [11]- [13].…”

Section: Existing Models and Their Limitationsmentioning

confidence: 99%

Sub Table Based Access Security Model (STBAM) for OLAP Tools

Sohail¹,

Hassain²

2013

IJCCE

View full text Add to dashboard Cite

Data Warehouses are used to maintain and manage the historical information that is very vital and confidential. Keeping in view the significance of data various data security techniques have been introduced. Most of them consider data security requirements from the early developmental stage of Data Warehouse. In this paper, specific problems related to the existing data security techniques are discussed and a new data security model which is suitable for already developed data warehouses is presented. We implemented this model by using web based application and verified it through different case studies. Key advantages of our approach are reduction of number of access checks that leads to improved data retrieval and reduced analysis time in a secure environment

show abstract

“…In [13,14] the authors focus on the dynamic [13] and static [14] modeling of the ETL processes. There are few research papers on DW security and OLAP (Online Analytical Processing) security [15,16,17,18]. But none of the above mentioned papers discuss an integrated security model for ETL processes.…”

Section: A Etl Modelingmentioning

confidence: 99%

Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study

Salah¹,

Marie²,

El-Fangary³

et al. 2012

IJACSA

View full text Add to dashboard Cite

Abstract-Extraction-transformation-loading (ETL) processes are responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. Data warehouse often store historical information which is extracted from multiple, heterogeneous, autonomous and distributed data sources, thereby, the survival of the organizations depends on the correct management, security and confidentiality of the information. In this paper, we are using the Model Driven Architecture (MDA) approach to represent logical model requirements for secure Temporal Data Warehouses (TDW). We use the Platform-Independent Model (PIM) which does not include information about specific platforms and technologies. Nowadays, the most crucial issue in MDA is the transformation between a PIM and Platform Specific Models PSM. Thus, OMG defines use the Query/View/Transformation (QVT) language, an approach for expressing these MDA transformations. This paper proposes a set of rules to transform PIM model for secure temporal data warehouse (TDW) to PSM model, we apply the QVT language to the development of a secure data warehouse by means of a case study.

show abstract

A Pragmatic Approach to Conceptual Modeling of OLAP Security

Cited by 43 publications

References 4 publications

Active Categorization of Sensibility Degrees of Datawarehouse Established on User Visibilities

Active Categorization of Sensibility Degrees of Datawarehouse Established on User Visibilities

Sub Table Based Access Security Model (STBAM) for OLAP Tools

Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study

Contact Info

Product

Resources

About