Query/View/Transformation Research Articles

Modeling and automatic generation of data warehouse using model-driven transformation in business intelligence process

The work presented in this paper focuses on the modeling and implementation of business intelligence processes, specifically how to apply model-driven architecture (MDA) throughout the entire development process of a data warehouse to automatically generate the multidimensional schema. As a result, this work specifies different rules for automating the process of obtaining an online analytical processing (OLAP) cube and implementing it using a collection of metamodels and automatic transformations. The data warehouse relational and OLAP cube models are then created using a model transformation from the conceptual model (class diagram). Finally, the XML file and SQL code are generated for creating the OLAP cubes and relational data warehouse, respectively. Using transformation languages like query-view-transformation (QVT) and Acceleo, all model transformations are performed.

A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses

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.

Toward Automatic Generation of Column-Oriented NoSQL Databases in Big Data Context

The growth of application architectures in all areas (e.g. Astrology, Meteorology, E-commerce, social network, etc.) has resulted in an exponential increase in data volumes, now measured in Petabytes. Managing these volumes of data has become a problem that relational databases are no longer able to handle because of the acidity properties. In response to this scaling up, new concepts have emerged such as NoSQL. In this paper, we show how to design and apply transformation rules to migrate from an SQL relational database to a Big Data solution within NoSQL. For this, we use the Model Driven Architecture (MDA) and the transformation languages like as MOF 2.0 QVT (Meta-Object Facility 2.0 Query-View-Transformation) and Acceleo which define the meta-models for the development of transformation model. The transformation rules defined in this work can generate, from the class diagram, a CQL code for creation column-oriented NoSQL database.

Applying a Model Driven Architecture Approach: Transforming CIM to PIM Using UML

Over the last few years, as they evolve with business needs and technology, enterprises are faced with the need to adapt their business processes to work in open settings. In such settings, the automation and the interoperability of business process and applications become a key concern. The Model Driven Architecture (MDA) is introduced as an approach to cope with this challenge. MDA specifies four levels of abstraction, most of the existing studies focus on modeling and transforming the Platform-Independent Model (PIM) to Platform-Specific Model (PSM) levels, while the more conceptual level, the Computation-Independent Model (CIM) is often presumed as present and is not further studied. In this paper, we propose an approach for transforming a CIM into a PIM using the core modeling concepts of the Unified Modeling Language (UML). One important characteristic of this approach is that it provides a method to capture and describe the requirements of the business process using a use cases model. The other important characteristic is proposing an architecture of the PIM based on the classes model. The execution of the transformation is programmed by the Query View Transformation (QVT) language.

Generated PSM Web Model for E-learning Platform Respecting n-tiers Architecture

E-learning, or learning via a computer or mobile device, is growing. It can take many forms, such as an annotated PowerPoint presentation, a tutorial, or an interactive role-playing game .The possibilities are endless.
 Today, 80% of companies and communities have done a number of interesting and effective e-learning solutions, and 30% of all professional training are e-learning courses. The development of these platforms is based mainly on different technologies. This technological diversity can make comparing or managing E-learning platforms difficult, and the choice of a given platform will be also complex. Therefore, to address this problem, this paper proposes a solution to generate a PSM model based on n-tier architecture from a PIM model. The language used is the QVT (Query View Transformation) transformation language.

A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses

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 execution of the transformation, programmed by the Query View Transformation (QVT) language, takes as input an instance of the UML Meta-Model to generate an instance of the Dimensional Meta-Model as output.

Design pattern-based model transformation supported by QVT

Defining a design pattern at the metamodel level.Defining the notion of pattern consistency.Defining the notion of pattern conformance.Describing transformation rules in QVT.Transforming an application model using a design pattern. A design pattern helps to improve the quality of a software system by providing a proven solution for recurring design problems. However, the abstract and informal nature of prevailing pattern descriptions makes it difficult to use design patterns. There have been significant works on formalizing design patterns which found a base for systematic application of a design pattern. Pattern-based model transformation has emerged as an approach for incorporating pattern properties into a design model. However, the existing work mostly focuses on the solution domain of a pattern while leaving out the problem domain, structural pattern aspects with little attention to behavioral aspects, and general methodologies without concrete implementations. In this work, we present an approach for transforming an application model using both the structural and behavioral properties of a design pattern defined in terms of the problem and solution domain and its implementation using Query/View/Transformation (QVT). In the approach, we define pattern consistency for structural and behavioral pattern properties and pattern conformance for pattern applicability before transformation solution conformance after transformation. We demonstrate the approach using the Observer pattern applied to a graph application. Besides the Observer pattern, we also define transformation rules for the Visitor and Adapter patterns.

A Model Driven Approach based on Interaction Flow Modeling Language to Generate Rich Internet Applications

<p><span lang="EN-US">A Rich Internet Applications (RIAs) combine the simplicity of the hypertext paradigm with the flexibility of desktop interfaces. These appliations were proposed as a solution to follow the rapid growth and evolution of the Graphical User Interfaces. However, RIAs are complex applications and their development requires designing and implementation which are time-consuming and the available tools are specialized in manual design. In this paper, we present a model driven approach to generat GUI for Rich Internet Application. The approach exploits the new language IFML recently adopted by the Object Management Group. We used frameworks and technologies known to Model-Driven Engineering, such as Eclipse Modeling Framework (EMF) for Meta-modeling, Query View Transformation (QVT) for model transformations and Acceleo for code generation. The approach allows to quickly and efficiently generating a RIA focusing on the graphical aspect of the application.</span></p>

Harmonizing IEC 61850 and CIM for connectivity of substation automation

A smart grid is an electrical power grid infrastructure for improving efficiency and reliability of power systems. CIM and IEC 61850 are major standards in the smart grid domain for modeling substations and their management. Due to heavy data exchanges between CIM and IEC 61850, the need for harmonizing the standards has emerged as a high priority issue to improve interoperability of involved systems in a smart grid. Among many aspects involved in the harmonization, connectivity, which is concerned with physical connections of equipment, forms the base. In this work, we present an approach for harmonizing the connectivity aspects of CIM and IEC 61850. In the approach, we analyze the models in the standards that are relevant to connectivity and define harmonization principles based upon the analysis. We then build a harmonized model by applying the principles and define transformation algorithms to support automatic transformation of CIM and IEC 61850 to the harmonized model and vice versa. We implemented the transformation using Query/View/Transformation (QVT). To aid application development, we also developed a profiling tool for tailoring the harmonized model to develop a specific energy management system. We demonstrate use of a profiled model by developing a simple SCADA application.

Model transformation between OPC UA and UML

OPC Unified Architecture (UA) is a platform-independent standard for message-based communication between clients and servers on various types of network to facilitate information exchange. OPC UA has been adopted in various domains such as power grids, building automation, and smart devices to support interoperability of involved systems. These domains also use Unified Modeling Language (UML) as the standard notation for data modeling or system modeling. Use of two different notations in the same domain causes compatibility issues. To address this, we present an approach for transforming OPC UA to UML to improve their compatibility and integration. In the approach, we rigorously analyze the semantics of OPC UA elements and establish a mapping between OPC UA elements and UML elements based on the analysis. Based on the mapping, we define transformation algorithms using Query/View/Transformation (QVT) which is a standard model transformation language by OMG. We demonstrate the approach using case examples in the power grid, building automation, and smart device domains.

A Model Driven Approach for generating Graphical User Interface for MVC Rich Internet Application

<p><span style="font-size: 10.5pt; font-family: 'Times New Roman','serif'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;" lang="EN-US">Web applications have witnessed a significant improvement that exhibit advanced user interface behaviors and functionalities. Along with this evolution, Rich Internet Applications (RIAs) were proposed as a response to these necessities and have combined the richness and interactivity of desktop interfaces into the web distribution model. However, RIAs are complex applications and their development requires designing and implementation which are time-consuming and the available tools are specialized in manual design. In this paper, we present a new model driven approach in which we used well known Model-Driven Engineering (MDE) frameworks and technologies, such as Eclipse Modeling Framework (EMF), Graphical Modeling Framework (GMF), Query View Transformation (QVTo) and Acceleo to enable the design and the code automatic generation of the RIA. The method focus on simplifying the task for the designer and not necessary be aware of the implementation specification.</span></p>

Unifying Data Types of IEC 61850 and CIM

IEC 61850 and IEC 61970-301 (CIM) are core standards in the electrical power domain. IEC 61850 is concerned with control and protection in a substation, while CIM addresses power management. There has been a great attention to unifying these standards to support interoperability in smart grids. However, due to their difference natures and independent evolution, the unification of IEC 61850 and CIM has been a great challenge. A prerequisite to their unification is unifying data types. In this paper, we present an approach for unifying data types of IEC 61850 and CIM. In the approach, the semantics of all the data types in the standards are analyzed to identify matching and non-matching types. Based on the analysis, data types are unified by applying a set of unification principles. We demonstrate tool support for transforming IEC 61850 and CIM data types to unified data types using Query/View/Transformation (QVT).

Model-Driven Transformation for GWT with Approach by Modeling: from UML Model to MVP Web Applications

The continuing evolution of business needs and technology makes Web applications more demanding in terms of development, usability and interactivity of their user interfaces. To cope with this complexity, several frameworks have emerged and a new type of Web applications called RIA (Rich Internet Applications) has recently appeared providing richer and more efficient graphical components similar to desktop applications. Given this diversity of solutions, the generation of a code based on UML models has become important. This paper presents the application of the MDA (Model Driven Architecture) to generate, from the UML model, the Code following the MVP pattern (Model-View-Presenter) for a RIA using the standard MOF 2.0 QVT (Meta-Object Facility 2.0 Query-View-Transformation) as a transformation language. We adopt GWT (Google web Toolkit) for creating a target meta-model to generate an entire GWT-based web application. The transformation rules defined in this paper can generate, from the class diagram, an XML file containing the Views, the Models, and the Presenter. This file can be used to generate the necessary code of a RIA.

English

This paper is about The conception and the realization of applications and Dashboard for the management of the spending and expenses of urban districts in Morocco. As so, we have chosen to use the N-tiers applications and the MDA (Model Driving Architecture) transformation. In this paper we are going to present a model-driven approach to the development of N-tiers web applications based on the UML class diagram. The transformation language is the MOF 2.0 QVT (Meta-Object Facility 2.0 Query-View-Transformation) standard which defines the meta-model for the development of model transformation. The transformation rules defined in this paper can generate, from the class diagram, an XML file containing the layers of N-tiers web application respecting a MVC2 (Model-View-Controller), DI (Dependency Injection) and DAO (Data Access Object) patterns. This file can be used to generate the end-to-end necessary code of a web application

QVT-Based Model Transformation to Support Unification of IEC 61850 and IEC 61970

A smart grid is an electrical power grid infrastructure for improved efficiency, reliability, and safety based on automated monitoring and control of data and communication. IEC 61850 and IEC 61970 are core standards in the smart-grid domain for substation automation and power operation management. There are significant data exchanges involved between the IEC 61850 level and the IEC 61970 level, which require high compatibility between the two standards. However, due to different perspectives and independent evolution, IEC 61850 and IEC 61870 are not compatible and practitioners have to come up with their own data mapping for the standards in an ad-hoc manner. This has led to significant issues on interoperability and data consistency in smart grids. An effective solution for this is to define a common semantic model of the standards and provide a systematic transformation method for transforming a model of the standards to a model of the common semantic model. In this paper, we present a metamodeling approach for unifying IEC 61850 and IEC 61970 and transforming models using query/view/transformation (QVT). We demonstrate the approach using a power transformer example.

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

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.

Extending QVT Relations for Business Process Model Transformation

QVT(Query/View/Transformation) Relations 无法描述包含嵌套模式,因此在描述流程模型的转换规则时存在一些困难.针对此问题,对QVT Relations 进行了扩展,引入了模式因子、嵌套关系表达式和关联端约束这3 个概念,并讨论了扩充之后匹配模型和创建模型的语义变化.并用一个例子展示,扩展之后的QVT Relations 可以解决流程模型转换的问题.;QVT (Query/View/Transformation) Relations cannot describe the pattern that includes other patterns, so it has some difficulties in defining the rules of a process model transformation. To solve this problem, the paper extends QVT Relations with three new concepts: Pattern Factor, Nested Relation Expression, and Relationship End Constraint. The paper also discusses the pattern matching and the model creating semantics after the extension. At Last, a case study is presented to show how the extension could deal with process model transformations.

A Proposed Compiler to Integrate Model Driven Architecture with Web Services Road Map

Model Driven Architecture (MDA) technique is mainly depend on two processes; mapping specification and transformation definition, this last one (sometimes called model transformation definition) has a tool to implement, which the most used one is Query/View/Transformation (QVT) Relational Language. This language sponsored by Object Management Group (OMG), and we found that it needs a repository for the both target model and source model, that mean these two models must be exist before execute the transformation definition (QVT Code). To eliminate this repository problem we propose in this paper a solution for this problem that we can compile the QVT code into Business Process Execution Language for Web Services (BPEL4WS). This solution will provide valuable contribution especially for MDA infrastructure, firstly to eliminate repository requirements for target model, secondly to make model transformation as web services. General Terms Model Driven Architecture; Model Transformation; Integration of Web Services with other Techniques.

QVT transformation by modelling - From UML Model to MD Model

To provide a complete analysis of the organization, its business and its needs, it is necessary for leaders to have data that help decision making. Data warehouses are designed to meet such needs; they are an analysis and data management technology. This article describes an MDA (Model Driven Architecture) process that we have used to automatically generate the multidimensional schema of data warehouse. This process uses model transformation using several standards such as Unified Modeling Language, Meta-Object Facility, Query View Transformation, Object Constraint Language, ... From the UML model, especially the class diagram, a multidimensional model is generated as an XML file, the transformation is carried out by the QVT (Query View Transformation) language and the OCL (Object Constraint Language) Language. To validate our approach a case study is presented at the end of this work.

A benchmark for OCL engine accuracy, determinateness, and efficiency

Since several years, the Object Constraint Language (OCL) is a central component in modeling and transformation languages like the Unified Modeling Language, the Meta Object Facility, and Query View Transformation. Consequently, approaches MDE (Model-Driven Engineering) depend on this language. OCL is present not only in areas influenced by the OMG but also in the Eclipse Modeling Framework (EMF). Thus the quality of OCL and its realization in tools seems to be crucial for the success of model-driven development. Surprisingly, up to now a benchmark for OCL to measure quality properties has not been proposed. This paper puts forward in the first part the concepts of a comprehensive OCL benchmark. Our benchmark covers (1) OCL engine accuracy (e.g., for the handling of the undefined value, the use of variables and the implementation of OCL standard operations), (2) OCL engine determinateness properties (e.g., for the collection operations `any' and `flatten'), and (3) OCL engine efficiency (for data type and user-defined operations). In the second part, this paper empirically evaluates the proposed benchmark concepts by examining several OCL tools. The paper clarifies a number of differences in handling particular language features and under specifications in the OCL standard.