Model-driven multidimensional modeling of secure data warehouses

2007 ◽  
Vol 16 (4) ◽  
pp. 374-389 ◽  
Author(s):  
Eduardo Fernández-Medina ◽  
Juan Trujillo ◽  
Mario Piattini
Keyword(s):  
Data Warehouses ◽  
Model Driven ◽  
Multidimensional Modeling ◽  
Secure Data

An MDA Compliant Approach for Designing Secure Data Warehouses

2009 ◽  
pp. 495-503
Author(s):  
Rodolfo Villarroel ◽  
Eduardo Fernández-Medina ◽  
Juan Trujillo ◽  
Mario Piattini
Keyword(s):  
Real World ◽  
Conceptual Modeling ◽  
Security Requirements ◽  
Data Warehouses ◽  
Model Driven ◽  
Secure Data ◽  
Security Information ◽  
Target Platform ◽  
Compliant Approach ◽  
User Security

This chapter presents an approach for designing secure Data Warehouses (DWs) that accomplish the conceptual modeling of secure DWs independently from the target platform where the DW has to be implemented, because our complete approach follows the Model Driven Architecture (MDA) and the Model Driven Security (MDS). In most of real world DW projects, the security aspects are issues that usually rely on the DBMS administrators. We argue that the design of these security aspects should be considered together with the conceptual modeling of DWs from the early stages of a DW project, and being able to attach user security information to the basic structures of a Multidimensional (MD) model. In this way, we would be able to generate this information in a semi or automatic way into a target platform and the final DW will better suits the user security requirements.

An MDA Compliant Approach for Designing Secure Data Warehouses

2011 ◽  
pp. 261-272
Author(s):  
Villarroel Rodolfo ◽  
Fernández-Medina Eduardo ◽  
Trujillo Juan ◽  
Piattini Mario
Keyword(s):  
Real World ◽  
Conceptual Modeling ◽  
Security Requirements ◽  
Data Warehouses ◽  
Model Driven ◽  
Secure Data ◽  
Security Information ◽  
Target Platform ◽  
Compliant Approach ◽  
User Security

This chapter presents an approach for designing secure Data Warehouses (DWs) that accomplish the conceptual modeling of secure DWs independently from the target platform where the DW has to be implemented, because our complete approach follows the Model Driven Architecture (MDA) and the Model Driven Security (MDS). In most of real world DW projects, the security aspects are issues that usually rely on the DBMS administrators. We argue that the design of these security aspects should be considered together with the conceptual modeling of DWs from the early stages of a DW project, and being able to attach user security information to the basic structures of a Multidimensional (MD) model. In this way, we would be able to generate this information in a semi or automatic way into a target platform and the final DW will better suits the user security requirements.

An MDA Compliant Approach for Designing Secure Data Warehouses

2009 ◽  
pp. 637-647
Author(s):  
Rodolfo Villarroel ◽  
Eduardo Fernández-Medina ◽  
Juan Trujillo ◽  
Mario Piattini
Keyword(s):  
Real World ◽  
Conceptual Modeling ◽  
Security Requirements ◽  
Data Warehouses ◽  
Model Driven ◽  
Secure Data ◽  
Security Information ◽  
Target Platform ◽  
Compliant Approach ◽  
User Security

This chapter presents an approach for designing secure Data Warehouses (DWs) that accomplish the conceptual modeling of secure DWs independently from the target platform where the DW has to be implemented, because our complete approach follows the Model Driven Architecture (MDA) and the Model Driven Security (MDS). In most of real world DW projects, the security aspects are issues that usually rely on the DBMS administrators. We argue that the design of these security aspects should be considered together with the conceptual modeling of DWs from the early stages of a DW project, and being able to attach user security information to the basic structures of a Multidimensional (MD) model. In this way, we would be able to generate this information in a semi or automatic way into a target platform and the final DW will better suits the user security requirements.

An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

2013 ◽  
pp. 44-71
Author(s):  
Jesús Pardillo ◽  
Jose-Norberto Mazón ◽  
Juan Trujillo
Keyword(s):  
Data Warehousing ◽  
Complete Solution ◽  
Requirement Engineering ◽  
User Requirements ◽  
Data Warehouses ◽  
Integrated Development ◽  
Model Driven ◽  
Organizational Challenges ◽  
Uml Profiles ◽  
Data Marts

To customize a data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, the integrated development of these data marts is an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. In this article, the authors present a design approach that employs user requirements to build both corporate data warehouses and data marts in an integrated manner. The approach links information requirements to specific data marts elicited by using goal-oriented requirement engineering, which are automatically translated into the implementation of corresponding data repositories by means of model-driven engineering techniques. The authors provide two UML profiles that integrate the design of both data warehouses and data marts and a set of QVT transformations with which to automate this process. The advantage of this approach is that user requirements are captured from the early development stages of a data-warehousing project to automatically translate them into the entire data-warehousing platform, considering the different data marts. Finally, the authors provide screenshots of the CASE tools that support the approach, and a case study to show its benefits.

Using UML Packages for Designing Secure Data Warehouses

2006 ◽  
pp. 1024-1034 ◽  
Author(s):  
Rodolfo Villarroel ◽  
Emilio Soler ◽  
Eduardo Fernández-Medina ◽  
Juan Trujillo ◽  
Mario Piattini
Keyword(s):  
Data Warehouses ◽  
Secure Data

Developing secure data warehouses with a UML extension

2007 ◽  
Vol 32 (6) ◽  
pp. 826-856 ◽  
Author(s):  
Eduardo Fernández-Medina ◽  
Juan Trujillo ◽  
Rodolfo Villarroel ◽  
Mario Piattini
Keyword(s):  
Data Warehouses ◽  
Secure Data ◽  
Uml Extension

Multidimensional Modeling of Complex Data

2011 ◽  
pp. 1358-1364 ◽  
Author(s):  
Omar Boussaid ◽  
Doulkifli Boukraa
Keyword(s):  
Data Warehouse ◽  
Numerical Data ◽  
Current Data ◽  
Structured Data ◽  
Complex Data ◽  
Conceptual Level ◽  
Data Warehouses ◽  
Multidimensional Modeling ◽  
Complex Relationships ◽  
Scientific Challenge

While the classical databases aimed in data managing within enterprises, data warehouses help them to analyze data in order to drive their activities (Inmon, 2005). The data warehouses have proven their usefulness in the decision making process by presenting valuable data to the user and allowing him/her to analyze them online (Rafanelli, 2003). Current data warehouse and OLAP tools deal, for their most part, with numerical data which is structured usually using the relational model. Therefore, considerable amounts of unstructured or semi-structured data are left unexploited. We qualify such data as “complex data” because they originate in different sources; have multiple forms, and have complex relationships amongst them. Warehousing and exploiting such data raise many issues. In particular, modeling a complex data warehouse using the traditional star schema is no longer adequate because of many reasons (Boussaïd, Ben Messaoud, Choquet, & Anthoard, 2006; Ravat, Teste, Tournier, & Zurfluh, 2007b). First, the complex structure of data needs to be preserved rather than to be structured linearly as a set of attributes. Secondly, we need to preserve and exploit the relationships that exist between data when performing the analysis. Finally, a need may occur to operate new aggregation modes (Ben Messaoud, Boussaïd, & Loudcher, 2006; Ravat, Teste, Tournier, & Zurfluh, 2007a) that are based on textual rather than on numerical data. The design and modeling of decision support systems based on complex data is a very exciting scientific challenge (Pedersen & Jensen, 1999; Jones & Song, 2005; Luján-Mora, Trujillo, & Song; 2006). Particularly, modeling a complex data warehouse at the conceptual level then at a logical level are not straightforward activities. Little work has been done regarding these activities. At the conceptual level, most of the proposed models are object-oriented (Ravat et al, 2007a; Nassis, Rajugan, Dillon, & Rahayu 2004) and some of them make use of UML as a notation language. At the logical level, XML has been used in many models because of its adequacy for modeling both structured and semi structured data (Pokorný, 2001; Baril & Bellahsène, 2003; Boussaïd et al., 2006). In this chapter, we propose an approach of multidimensional modeling of complex data at both the conceptual and logical levels. Our conceptual model answers some modeling requirements that we believe not fulfilled by the current models. These modeling requirements are exemplified by the Digital Bibliography & Library Project case study (DBLP).

Sign in / Sign up

Export Citation Format

Share Document