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.

Marwa S Farhan, Mohamed E. Marie, Laila M. El-Fangary and Yehia K. Helmy, “Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study” International Journal of Advanced Computer Science and Applications(IJACSA), 3(3), 2012. http://dx.doi.org/10.14569/IJACSA.2012.030320

@article{Farhan2012,
title = {Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2012.030320},
url = {http://dx.doi.org/10.14569/IJACSA.2012.030320},
year = {2012},
publisher = {The Science and Information Organization},
volume = {3},
number = {3},
author = {Marwa S Farhan and Mohamed E. Marie and Laila M. El-Fangary and Yehia K. Helmy}
}