A Trace Metamodel Proposal Based on the Model Driven Architecture Framework for the Traceability of User Requirements in Data Warehouses

  • Alejandro Maté
  • Juan Trujillo
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6741)


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 accommodated to a new DW model. The main problem is that we lose the relationships between requirements, elements in the conceptual models and data sources in the process, since no traceability is explicitly specified. Therefore, this hurts requirements validation capability and increases the complexity of Extraction, Transformation and Load processes. In this paper, we propose the first trace metamodel for DWs and focus on the relationships between requirements and conceptual models. We propose a set of Query/View/Transformation rules to include traceability in DWs in an automatic way, allowing us to trace every requirement to the conceptual model and further increasing user satisfaction.


Data Warehouses traceability user requirements MDA 


  1. 1.
    Aizenbud-Reshef, N., Nolan, B., Rubin, J., Shaham-Gafni, Y.: Model traceability. IBM Systems Journal 45(3), 515–526 (2006)Google Scholar
  2. 2.
    Antoniol, G., Canfora, G., Casazza, G., De Lucia, A., Merlo, E.: Recovering traceability links between code and documentation. IEEE Transactions on Software Engineering 28(10), 970–983 (2002)CrossRefGoogle Scholar
  3. 3.
    Arkley, P., Mason, P., Riddle, S.: Position paper: Enabling traceability. In: Proceedings of the 1st International Workshop on Traceability in Emerging Forms of Software Engineering, Edinburgh, Scotland, pp. 61–65 (2002)Google Scholar
  4. 4.
    Ballou, D., Tayi, G.: Enhancing data quality in data warehouse environments. Communications of the ACM 42(1), 73–78 (1999)CrossRefGoogle Scholar
  5. 5.
    Barbero, M., Del Fabro, M., Bézivin, J.: Traceability and provenance issues in global model management. In: ECMDA-TW, pp. 47–56 (2007)Google Scholar
  6. 6.
    Del Fabro, M., Bézivin, J., Valduriez, P.: Weaving Models with the Eclipse AMW plugin. In: Eclipse Modeling Symposium, Eclipse Summit Europe 2006, Esslingen, Germany (2006)Google Scholar
  7. 7.
    Franch, X.: Incorporating Modules into the i* Framework. In: Pernici, B. (ed.) CAiSE 2010. LNCS, vol. 6051, pp. 439–454. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  8. 8.
    Gotel, O., Finkelstein, A.: An analysis of the requirements traceability problem. In: ICRE, pp. 94–101. IEEE, Los Alamitos (1994)Google Scholar
  9. 9.
    Gotel, O.C.Z., Morris, S.J.: Macro-level Traceability Via Media Transformations. In: Rolland, C. (ed.) REFSQ 2008. LNCS, vol. 5025, pp. 129–134. Springer, Heidelberg (2008)CrossRefGoogle Scholar
  10. 10.
    Inmon, W.H.: Building the data warehouse. Wiley-India, Chichester (2009)Google Scholar
  11. 11.
    Jouault, F.: Loosely coupled traceability for atl. In: ECMDA-TW, Nuremberg, Germany, pp. 29–37 (2005)Google Scholar
  12. 12.
    Kimball, R.: The data warehouse toolkit. Wiley-India, Chichester (2009)Google Scholar
  13. 13.
    Kolp, M., Giorgini, P., Mylopoulos, J.: Organizational Patterns for Early Requirements Analysis. In: Advanced Information Systems Engineering (CAiSE), LNCS, vol. 2681, pp. 617–633. Springer Berlin (2003)CrossRefGoogle Scholar
  14. 14.
    Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses. DKE 59(3), 725–769 (2006)CrossRefGoogle Scholar
  15. 15.
    Mazón, J.-N., Trujillo, J.: A model driven modernization approach for automatically deriving multidimensional models in data warehouses. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 56–71. Springer, Heidelberg (2007)CrossRefGoogle Scholar
  16. 16.
    Mazon, J.N., Pardillo, J., Trujillo, J.: An MDA approach for the development of data warehouses. DSS 45(1), 41–58 (2008)Google Scholar
  17. 17.
    Mazón, J.-N., Trujillo, J., Lechtenbörger, J.: Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. DKE 63(3), 725–751 (2007)CrossRefGoogle Scholar
  18. 18.
    Mouratidis, H., Giorgini, P., Manson, G.: Integrating Security and Systems Engineering: Towards the Modelling of Secure Information Systems. In: Eder, J., Missikoff, M. (eds.) CAiSE 2003. LNCS, vol. 2681, pp. 63–78. Springer, Heidelberg (2003)CrossRefGoogle Scholar
  19. 19.
    OMG: A Proposal for an MDA Foundation Model (2005)Google Scholar
  20. 20.
    OMG: The Meta-Object Facility 2.0 Query/View/Transformation. Final Adopted Specification (2005)Google Scholar
  21. 21.
    Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A goal-oriented approach to requirement analysis in data warehouses. DSS 45(1), 4–21 (2008)Google Scholar
  22. 22.
    Paige, R., Olsen, G., Kolovos, D., Zschaler, S., Power, C.: Building model-driven engineering traceability classifications. In: ECMDA-TW, pp. 49–58 (2008)Google Scholar
  23. 23.
    Ramesh, B., Jarke, M.: Toward reference models for requirements traceability. IEEE Transactions on Software Engineering 27(1), 58–93 (2001)CrossRefGoogle Scholar
  24. 24.
    Ramesh, B., Stubbs, C., Powers, T., Edwards, M.: Requirements traceability: Theory and practice. Annals of Software Engineering 3(1), 397–415 (1997)CrossRefGoogle Scholar
  25. 25.
    Samia Kaabi, R., Souveyet, C., Rolland, C.: Eliciting service composition in a goal driven manner. In: ICSOC, pp. 308–315 (2004)Google Scholar
  26. 26.
    Spanoudakis, G., Zisman, A.: Software traceability: a roadmap. Handbook of Software Engineering and Knowledge Engineering (2005)Google Scholar
  27. 27.
    Vassiliadis, P.: Data Warehouse Modeling and Quality Issues. Ph.D. thesis, Athens (2000)Google Scholar
  28. 28.
    Walderhaug, S., Stav, E., Johansen, U., Olsen, G.K.: Traceability in Model-Driven Software Development. Designing Software-Intensive Systems: Methods and Principle, 133–159 (2008)Google Scholar
  29. 29.
    Winkler, S., von Pilgrim, J.: A survey of traceability in requirements engineering and model-driven development. Software and Systems Modeling 9, 529–565 (2010)CrossRefGoogle Scholar
  30. 30.
    Yu, E.S.K.: Modelling strategic relationships for process reengineering. Ph.D. thesis, Toronto, Ont., Canada (1995)Google Scholar
  31. 31.
    Yu, Y., Jurjens, J., Mylopoulos, J.: Traceability for the maintenance of secure software. In: ICSM 2008, pp. 297–306. IEEE, Los Alamitos (2008)Google Scholar
  32. 32.
    Yu, Y., Niu, N., Gonzalez-Baixauli, B., Candillon, W., Mylopoulos, J., Easterbrook, S., do Leite, J., Vanwormhoudt, G.: Tracing and validating goal aspects. In: RE 2007, pp. 53–56. IEEE, Los Alamitos (2007)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Alejandro Maté
    • 1
  • Juan Trujillo
    • 1
  1. 1.Lucentia Research Group Department of Software and Computing SystemsUniversity of AlicanteSpain

Personalised recommendations