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.
Highlights
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 order to overcome this limitation, in previous proposals, we have described a model driven framework for the development of Data Warehouses (DWs), based on the Model Driven Architecture (MDA) standards
Transformation from Platform-Independent Model (PIM) model to Platform Specific Models (PSM) model. This sections explains the proposed rules to transform from PIM model to PSM, we will base on the approaches which was presented in [29, 30].Fig.3 illustrates the Secure Multidimensional MDA architecture [1]
Summary
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 work we apply a set of QVT [2] relations to the development of a secure DW. Various approaches for the conceptual design of the DW repository have been proposed in [4, 5, 6, 7] These proposals are twofold; on the one hand they try to represent the main MD properties at the conceptual level by abstracting away details of the target database platform where the DW will be implemented. They define how to derive a logical representation tailored to a specific database technology (relational or multidimensional). These approaches are lacking in formal mechanisms to univocally and automatically obtain the logical representation of the conceptual model [3].
Sign-in/Register to view highlights & summary 
Published Version (
Free)
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call