Abstract
Over the past decade, the concept of data warehousing has been widely accepted. The main reason for building data warehouses is to improve the quality of information in order to achieve specific business objectives such as competitive advantage or improved decision-making. However, there is no formal method for deriving a multidimensional schema from heterogeneous databases that is recognized as a standard by the OMG and the professionals of the field. Which is why, in this paper, we present a model-driven approach (MDA) for the design of data warehouses. To apply the MDA approach to the Data warehouse construction process, we describe a multidimensional meta-model and specify a set of transformations from a UML meta-model which is mapped to a multidimensional meta-model. The transformation rules are programmed by the Query View Transformation (QVT) language. A case study illustrates our approach. It demonstrates how it reinforces the components traceability and reusability and how it globally improves the modeler’s efficiency. Furthermore, the use of the UML, as a technique to build data warehouses, is an important facilitator which prepares our further work to automate this approach.
Highlights
The decision-making systems are defined by information systems that can help companies in their decision making process
We focused on the Platform Independent Model (PIM) to PIM transformation using an approach by modeling, we will automatically generate Data Warehouse (DW) schema by using several Unified Modeling Language (UML) profiles
PIM Target Meta Model: Based on the approach described in [18], and inspired by this UML profile for the data warehouse, the target meta-model that we have proposed for the transformation, is a simplified meta-model containing Facts and Dimensions
Summary
The decision-making systems are defined by information systems that can help companies in their decision making process. Because it consists of several interrelated components with different functions, different design pitfalls, and different technologies [2] To overcome this problem, we decided to use the Model Driven Architecture (MDA) approach in building the DW which is developed by Object Management Group (OMG), supports evolving standards in application domains. MDA provides an open, vendor-neutral approach to the challenge of interoperability, building upon and leveraging the value of OMG's established modeling standards: Unified Modeling Language (UML); Meta-Object Facility (MOF) [3] This framework separates the specification of system functionality in a Platform Independent Model (PIM) from the specification of the implementation of that functionality on a specific technology in a Platform Specific Model (PSM).
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