Representing security and audit rules for data warehouses at the logical level by using the common warehouse metamodel

Soler, Emilio Carlos López; Villarroel, Rodolfo; Trujillo, Juan; Fernandez-Medina, E.; Piattini, Mario

doi:10.1109/ares.2006.110

Cited by 16 publications

(13 citation statements)

References 10 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Specifically, in this paper we have focused on security. Until now, we have proposed a general framework based on MDA [20], [21] in which we use our approaches for designing secure DWs at both conceptual [4], [5] and logical levels [19]. In this paper, we have focused on defining security requirements for DWs and the process for modeling security requirements, both introduced in Section IV.…”

Section: Discussionmentioning

confidence: 99%

Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements

Soler

Stefanov

Mazón

et al. 2008

2008 Third International Conference on Availability, Reliability and Security

View full text Add to dashboard Cite

Abstract-Data warehouse (DW) systems integrate data from heterogeneous sources and are used by decision makers to analyze the status and the development of an organization. Traditionally, requirement analysis approaches for DWs have focused purely on information needs of decision makers, without considering other kinds of requirements such as security or performance. But modeling these issues in the early stages of the development is a cornerstone for building a DW that satisfies user expectations. In this paper, we define the two kinds of requirements for data warehousing as information and quality-of-service requirements and combine them in a comprehensive approach based on MDA (Model Driven Architecture). This allows a separation of concerns to model requirements without losing the connection between information and quality-of-service, also in the following conceptual or logical design stages. Finally, in this paper, we introduce a security requirement model for data warehousing, and a three-step process for modeling security requirements, thus illustrating the applicability of our approach with an example.

show abstract

Section: Discussionmentioning

confidence: 99%

Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements

Soler

Stefanov

Mazón

et al. 2008

2008 Third International Conference on Availability, Reliability and Security

View full text Add to dashboard Cite

show abstract

“…Sin embargo ninguna de las propuestas anteriores extiende el metamodelo relacional de CWM con aspectos de seguridad. Solo el trabajo presentado en [24] muestra cómo CWM puede ser adecuado para representar medidas de seguridad a nivel lógico, aunque no es formalmente extendido a través de los mecanismos de extensión que ofrece CWM.…”

Section: Introductionunclassified

An extension of the Relational Metamodel of CWM to represent Secure Data Warehouses at the Logical Level

Soler

Trujillo

Fernandez-Medina

et al. 2008

IEEE Latin Am. Trans.

Self Cite

View full text Add to dashboard Cite

Abstract-Generally, security and audit measures for Data Warehouses (DWs) are defined in the final implementation on top of commercial systems because there is not a standard for the exchange and the operability of metadata. The Common Warehouse Metamodel (CWM) proposal is broadly accepted as the standard for the interchange and the interoperability of metadata. Nevertheless, it does not allow us to specify security measures. In this paper, we make use of the extension mechanisms provided by the CWM to extend the relational package to specify, at the logical level, the security and audit rules captured during the conceptual modeling phase of the DWs design. Moreover, in order to show the benefits of our extension, we apply it to a case study related to the management of the pharmacies consortium businesses.

show abstract

“…Identified object are shown in each table and condition table is 4. Meta data of DWH for objects using case study [15] IV. CONCLUSION AND FUTURE WORK Overcoming the Grant Read problem i.e.…”

Section: : Creating Of Cubes With Tagsmentioning

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

Representing security and audit rules for data warehouses at the logical level by using the common warehouse metamodel

Cited by 16 publications

References 10 publications

Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements

Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements

An extension of the Relational Metamodel of CWM to represent Secure Data Warehouses at the Logical Level

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

Contact Info

Product

Resources

About