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

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

Authors and Affiliations

Marwa S. Farhan , Mohamed E. Marie , Laila M. El-Fangary , Yehia K. Helmy

Keywords

Related Articles

Location-based E-Commerce Services: (Re-) Designing using the ISO9126 Standard

E-commerce services based on user geographic location have emerged as a particularly important segment of modern information services. In these user-intensive applications, quality of service is important and design meth...

A Novel Adaptive Grey Verhulst Model for Network Security Situation Prediction

Recently, researchers have shown an increased interest in predicting the situation of incoming security situation for organization’s network. Many prediction models have been produced for this purpose, but many of these...

Simulation of Building Evacuation: Performance Analysis and Simplified Model

Crowd evacuation from industrial buildings, factories, theatres, protest areas, festivals, exhibitions and religious/sports gatherings is very crucial in many dangerous scenarios, such as fire, earthquakes, threat and at...

Defining Network Exposure Metrics in Security Risk Scoring Models

Organizations are exposed to cyber-attacks on a regular basis. Managers in these organizations are using scoring systems to evaluate the risks of the attacks they are exposed to. Information security methodologies define...

Instruction Design Model for Self-Paced ICT System E-Learning in an Organization

Adopting an Information Communication and Technology (ICT) system in an organization is somewhat challenging. User diversity, heavy workload, and different skill gap make the ICT adoption process slower. This research st...

Download PDF file
  • EP ID EP135089
  • DOI -
  • Views 97
  • Downloads 0

How To Cite

Marwa S. Farhan, Mohamed E. Marie, Laila M. El-Fangary, Yehia K. Helmy (2012).  Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study. International Journal of Advanced Computer Science & Applications, 3(3), 115-122. https://europub.co.uk/articles/-A-135089