An MDA approach for the development of data warehouses

被引：96

作者：

Mazon, Jose-Norberto ^{[1
]}

Trujillo, Juan ^{[1
]}

机构：

[1] Univ Alicante, Dept Software & Comp Syst, Sch Comp Sci, Alicante, Spain

来源：

DECISION SUPPORT SYSTEMS | 2008年 / 45卷 / 01期

关键词：

data warehouse; multidimensional modeling; MDA; QVT;

D O I：

10.1016/j.dss.2006.12.003

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

Different modeling approaches have been proposed to overcome every design pitfall of different data warehouse (DW) components. However, most of them offer partial solutions that deal only with isolated aspects of the DW and do not provide developers with an integrated and standard framework for designing all DW relevant components, such as ETL processes, data sources, DW repository and so on. To overcome this problem, this paper describes how to align the whole DW development process with a Model Driven Architecture (MDA) framework. We then focus on describing one part of it: an MDA approach for the development of the DW repository, because it is the cornerstone of any DW system. Therefore, we describe how to build the different MDA models for the DW repository by using an extension of the Unified Modeling Language (UML) and the Common Warehouse Metamodel (CWM). Transformations between models are also clearly and formally established by using the Query/ View/Transformation (QVT) language. Finally, a case study is provided to exemplify the benefits of our MDA framework. (C) 2006 Elsevier B.V. All rights reserved.

引用

页码：41 / 58

页数：18

共 35 条

[1] YAM2:: a multidimensional conceptual model extending UML [J].

Abello, Alberto ;

Samos, Jose ;

Saltor, Felix .

INFORMATION SYSTEMS, 2006, 31 (06) :541-567

[2]

CZARNECKI K, 2003, P 2 OOPSLA WORKSH GE

[3]

Frankel DS., 2003, Model Driven Architecture: Applying MDA to Enterprise Computing

[4]

Gerber A, 2002, LECT NOTES COMPUT SC, V2505, P90

[5]

Giorgini P., 2005, 8 ACM INT WORKSHOP D, P47

[6]

Giovinazzo W.A., 2000, OBJECT ORIENTED DATA

[7] The dimensional fact model: A conceptual model for data warehouses [J].

Golfarelli, M ;

Maio, D ;

Rizzi, S .

INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS, 1998, 7 (2-3) :215-247

[8]

Inmon WilliamH., 2002, BUILDING DATA WAREHO, V4th

[9]

Jacobson I., 1999, AW OBJ TECHNOL S, V1

[10]

Jarke Matthias., 2000, FUNDAMENTALS DATA WA

← 1 2 3 4 →