Information Mediation Using Metamodels

To customize a data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, the integrated development of these data marts is an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. In this article, the authors present a design approach that employs user requirements to build both corporate data warehouses and data marts in an integrated manner. The approach links information requirements to specific data marts elicited by using goal-oriented requirement engineering, which are automatically translated into the implementation of corresponding data repositories by means of model-driven engineering techniques. The authors provide two UML profiles that integrate the design of both data warehouses and data marts and a set of QVT transformations with which to automate this process. The advantage of this approach is that user requirements are captured from the early development stages of a data-warehousing project to automatically translate them into the entire data-warehousing platform, considering the different data marts. Finally, the authors provide screenshots of the CASE tools that support the approach, and a case study to show its benefits.

Section: Development Platform and Implementationmentioning

confidence: 99%

An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

Trujillo

Pardillo

Mazón

2011

“…Data Integration. In data integration, a set of heterogeneous data sources are queried and accessed through a unified global and virtual view (Lenzerini, 2002;Zhao & Siau, 2007). There are many ontologybased data integration applications which use ontologies as their global views.…”

Section: Database Design a Typical Database Designmentioning

confidence: 99%

Maintaining Mappings between Conceptual Models and Relational Schemas

Song

2010

This paper describes a round-trip engineering approach for incrementally maintaining mappings between conceptual models and relational schemas. When either schema or conceptual model evolves to accommodate new information needs, the existing mapping must be maintained accordingly to continuously provide valid services. In this paper, the authors examine the mappings specifying “consistent” relationships between models. First, they define the consistency of a conceptual-relational mapping through “semantically compatible” instances. Next, the authors analyze the knowledge encoded in the standard database design process and develop round-trip algorithms for incrementally maintaining the consistency of conceptual-relational mappings under evolution. Finally, they conduct a set of comprehensive experiments. The results show that the proposed solution is efficient and provides significant benefits in comparison to the mapping reconstructing approach.

“…This would present an advantage over traditional development approaches as the solution would be created using the organization's terms instead of using implementation terms; we later present a more detailed view of how software development can be done combining metamodeling and model transformations. An example of the need of using metamodeling and metamodels can be found in Zhao and Siau (2007), which uses metamodels to handle the mediation of information sources.…”

Section: Figure 5 Using the Expertise Of Some Developers To Orient Ot...mentioning

confidence: 99%

Evaluation of MDE Tools from a Metamodeling Perspective

Saraiva

Silva

2008

Ever since the introduction of computers into society, researchers have been trying to raise the abstraction level at which we build software programs. We are currently adopting an abstraction level based on graphical models instead of source code: MDE. MDE is the driving force for some recent modeling languages and approaches, such as OMG’s UML or Domain-Specific Modeling. All these approaches are founded on metamodeling: defining languages that represent a problem-domain. A key factor for the success of any approach is appropriate tool support. However, only recently have tool creators started considering metamodeling as an important issue in their list of concerns. In this paper, we evaluate a small set of MDE tools from the perspective of the metamodeling activity, focusing on both architectural and practical aspects. Then, using the results of this evaluation, we discuss open research issues for MDE-based software development tools.