article

Tracing conceptual models' evolution in data warehouses by using the model driven architecture

Authors:

Alejandro Maté,

Juan TrujilloAuthors Info & Claims

Computer Standards & Interfaces, Volume 36, Issue 5

Pages 831 - 843

https://doi.org/10.1016/j.csi.2014.01.004

Published: 01 September 2014 Publication History

Abstract

Developing a data warehouse is an ongoing task where new requirements are constantly being added. A widely accepted approach for developing data warehouses is the hybrid approach, where requirements and data sources must be accommodated to a reconciliated data warehouse model. During this process, relationships between conceptual elements specified by user requirements and those supplied by the data sources are lost, since no traceability mechanisms are included. As a result, the designer wastes additional time and effort to update the data warehouse whenever user requirements or data sources change. In this paper, we propose an approach to preserve traceability at conceptual level for data warehouses. Our approach includes a set of traces and their formalization, in order to relate the multidimensional elements specified by user requirements with the concepts extracted from data sources. Therefore, we can easily identify how changes should be incorporated into the data warehouse, and derive it according to the new configuration. In order to minimize the effort required, we define a set of general Query/View/Transformation rules to automate the derivation of traces along with data warehouse elements. Finally, we describe a CASE tool that supports our approach and provide a detailed case study to show the applicability of the proposal.

References

[1]

The Data Warehouse Lifecycle Toolkit. 2011. Wiley.

[2]

Giorgini, P., Rizzi, S. and Garzetti, M., GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis. Support. Syst. v45 i1. 4-21.

[3]

Mazón, J.-N. and Trujillo, J., An MDA approach for the development of data warehouses. Decis. Support. Syst. v45 i1. 41-58.

[4]

http://www.gartner.com/DisplayDocument?ref=clientFriendlyUrl

[5]

Winkler, S. and von Pilgrim, J., A survey of traceability in requirements engineering and model-driven development. Softw. Syst. Model. v9. 529-565.

Digital Library

[6]

Luján-Mora, S., Trujillo, J. and Song, I.-Y., A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. v59 i3. 725-769.

[7]

A model-driven goal-oriented requirement engineering approach for data warehouses. 2007.

[8]

Mazón, J.-N. and Trujillo, J., A hybrid model driven development framework for the multidimensional modeling of data warehouses. SIGMOD Rec. v38 i2. 12-17.

[9]

http://www.omg.org/cgi-bin/doc?ormsc/05-04-01

[10]

http://www.omg.org/spec/QVT/

[11]

Maté, A. and Trujillo, J., Incorporating traceability in conceptual models for data warehouses by using MDA. 2011.

[12]

Gotel, O. and Morris, S., Macro-level Traceability Via Media Transformations. 2008.

[13]

Ramesh, B. and Jarke, M., Toward reference models for requirements traceability. IEEE Trans. Softw. Eng. v27 i1. 58-93.

[14]

Spanoudakis, G. and Zisman, A., Software traceability: a roadmap, Handbook of Software Engineering and Knowledge Engineering. 2004.

[15]

Yu, Y., Jurjens, J. and Mylopoulos, J., Traceability for the maintenance of secure software. In: IEEE International Conference on Software Maintenance, pp. 297-306.

[16]

Aizenbud-Reshef, N., Nolan, B., Rubin, J. and Shaham-Gafni, Y., Model traceability. IBM Syst. J. v45 i3. 515-526.

[17]

Jouault, F., Loosely coupled traceability for atl. In: Proceedings of the European Conference on Model Driven Architecture (ECMDA) workshop on traceability, pp. 29-37.

[18]

Paige, R., Olsen, G., Kolovos, D., Zschaler, S. and Power, C., Building model-driven engineering traceability classifications. In: Proceedings of the European Conference on Model Driven Architecture (ECMDA) workshop on traceability, pp. 49-58.

[19]

Antoniol, G., Canfora, G., Casazza, G., De Lucia, A. and Merlo, E., Recovering traceability links between code and documentation. IEEE Trans. Softw. Eng. v28 i10. 970-983.

[20]

Asuncion, H., Asuncion, A. and Taylor, R., Software traceability with topic modeling. In: Proceedings of the 32nd ACM/IEEE International Conference on Software Engineering, pp. 95-104.

[21]

Vranesic, H. and Rovan, L., Ontology-based data warehouse development process. In: Proceedings of the 31st International Conference on Information Technology, Interfaces (ITI'09), pp. 205-210.

[22]

Maté, A. and Trujillo, J., A trace metamodel proposal based on the model driven architecture framework for the traceability of user requirements in data warehouses. Inf. Syst. v37 i8. 753-766.

[23]

Vassiliadis, P., Data Warehouse Modeling and Quality Issues. 2000. National Technical University of Athens, Athens.

[24]

Cui, Y. and Widom, J., Lineage tracing in a data warehousing system. In: Proceedings of the 16th International Conference on Data Engineering, pp. 683-684.

[25]

Abelló, A., Samos, J. and Saltor, F., YAM2: a multidimensional conceptual model extending UML. Inf. Syst. v31 i6. 541-567.

[26]

Golfarelli, M., Maio, D. and Rizzi, S., The dimensional fact model: a conceptual model for data warehouses. Int. J. Coop. Inf. Syst. v7 i2. 215-247.

[27]

Neil, C., Irazábal, J., De Vincenzi, M. and Pons, C., Graphical query mechanism for historical data warehouse within MDD. In: Proceedings of the XXIX International Conference of the Chilean Computer Science Society (SCCC), pp. 183-192.

Digital Library

[28]

Neil, C.G. and Pons, C., Aplicando MDA al Diseño de un Datawarehouse Temporal. In: Jornadas Iberoamericanas de Ingeniería del Software e Ingeniería del Conocimiento (JIISIC), pp. 181-189.

[29]

Mazón, J.-N., Trujillo, J. and Lechtenbörger, J., Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng. v63 i3. 725-751.

[30]

Del Fabro, M., Bézivin, J. and Valduriez, P., Weaving models with the eclipse AMW plugin. In: Eclipse Modeling Symposium, Eclipse Summit Europe,

[31]

http://www.omg.org/spec/CWM/1.1/

[32]

Jouault, F. and Kurtev, I., Transforming models with ATL. In: Satellite Events at the MoDELS 2005 Conference, pp. 128-138.

Cited By

Kuznetcov YFomin MVinogradov A(2019)Multidimensional Information Systems Metadata Repository Development with a Data Warehouse Structure Using "Data Vault" MethodologyProceedings of the XI International Scientific Conference Communicative Strategies of the Information Society10.1145/3373722.3373777(1-5)Online publication date: 25-Oct-2019
https://dl.acm.org/doi/10.1145/3373722.3373777
(2019)Research on conceptual modelingData & Knowledge Engineering10.1016/j.datak.2015.07.00298:C(1-7)Online publication date: 1-Jan-2019
https://dl.acm.org/doi/10.1016/j.datak.2015.07.002
Bimonte SSautot LJournaux LFaivre B(2017)Multidimensional Model Design using Data MiningInternational Journal of Data Warehousing and Mining10.5555/3077757.307775813:1(1-35)Online publication date: 1-Jan-2017
https://dl.acm.org/doi/10.5555/3077757.3077758
Show More Cited By

Recommendations

Incorporating traceability in conceptual models for data warehouses by using MDA
ER'11: Proceedings of the 30th international conference on Conceptual modeling

The complexity of the Data Warehouse (DW) development process requires to follow a methodological approach in order to be successful. A widely accepted approach for this development is the hybrid one, in which requirements and data sources must be ...
An MDA approach for the development of data warehouses

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 ...
A trace metamodel proposal based on the model driven architecture framework for the traceability of user requirements in data warehouses

The complexity of the data warehouse (DW) development process requires to follow a methodological approach in order to be successful. A widely accepted approach for this development is the hybrid one, in which requirements and data sources must be ...

Comments

Information & Contributors

Information

Published In

cover image Computer Standards & Interfaces

Computer Standards & Interfaces Volume 36, Issue 5

September, 2014

89 pages

ISSN:0920-5489

Issue’s Table of Contents

Copyright © Elsevier B.V. © 2014.

Publisher

Elsevier Science Publishers B. V.

Netherlands

Publication History

Published: 01 September 2014

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

5
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 01 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

Kuznetcov YFomin MVinogradov A(2019)Multidimensional Information Systems Metadata Repository Development with a Data Warehouse Structure Using "Data Vault" MethodologyProceedings of the XI International Scientific Conference Communicative Strategies of the Information Society10.1145/3373722.3373777(1-5)Online publication date: 25-Oct-2019
https://dl.acm.org/doi/10.1145/3373722.3373777
(2019)Research on conceptual modelingData & Knowledge Engineering10.1016/j.datak.2015.07.00298:C(1-7)Online publication date: 1-Jan-2019
https://dl.acm.org/doi/10.1016/j.datak.2015.07.002
Bimonte SSautot LJournaux LFaivre B(2017)Multidimensional Model Design using Data MiningInternational Journal of Data Warehousing and Mining10.5555/3077757.307775813:1(1-35)Online publication date: 1-Jan-2017
https://dl.acm.org/doi/10.5555/3077757.3077758
Khouri SBerkani NBellatreche L(2017)Tracing data warehouse design lifecycle semanticallyComputer Standards & Interfaces10.1016/j.csi.2016.12.00251:C(132-151)Online publication date: 1-Mar-2017
https://dl.acm.org/doi/10.1016/j.csi.2016.12.002
Khouri SBellatreche L(2015)Traceability of Tightly Coupled Phases of Semantic Data Warehouse DesignProceedings of the Confederated International Conferences on On the Move to Meaningful Internet Systems: OTM 2015 Conferences - Volume 941510.1007/978-3-319-26148-5_33(483-500)Online publication date: 26-Oct-2015
https://dl.acm.org/doi/10.1007/978-3-319-26148-5_33

View Options

View options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents