Abstract
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.
Chapter PDF
Similar content being viewed by others
References
Aizenbud-Reshef, N., Nolan, B., Rubin, J., Shaham-Gafni, Y.: Model traceability. IBM Systems Journal 45(3), 515–526 (2006)
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)
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)
Ballou, D., Tayi, G.: Enhancing data quality in data warehouse environments. Communications of the ACM 42(1), 73–78 (1999)
Barbero, M., Del Fabro, M., Bézivin, J.: Traceability and provenance issues in global model management. In: ECMDA-TW, pp. 47–56 (2007)
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)
Franch, X.: Incorporating Modules into the i* Framework. In: Pernici, B. (ed.) CAiSE 2010. LNCS, vol. 6051, pp. 439–454. Springer, Heidelberg (2010)
Gotel, O., Finkelstein, A.: An analysis of the requirements traceability problem. In: ICRE, pp. 94–101. IEEE, Los Alamitos (1994)
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)
Inmon, W.H.: Building the data warehouse. Wiley-India, Chichester (2009)
Jouault, F.: Loosely coupled traceability for atl. In: ECMDA-TW, Nuremberg, Germany, pp. 29–37 (2005)
Kimball, R.: The data warehouse toolkit. Wiley-India, Chichester (2009)
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)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses. DKE 59(3), 725–769 (2006)
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)
Mazon, J.N., Pardillo, J., Trujillo, J.: An MDA approach for the development of data warehouses. DSS 45(1), 41–58 (2008)
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)
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)
OMG: A Proposal for an MDA Foundation Model (2005)
OMG: The Meta-Object Facility 2.0 Query/View/Transformation. Final Adopted Specification (2005)
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A goal-oriented approach to requirement analysis in data warehouses. DSS 45(1), 4–21 (2008)
Paige, R., Olsen, G., Kolovos, D., Zschaler, S., Power, C.: Building model-driven engineering traceability classifications. In: ECMDA-TW, pp. 49–58 (2008)
Ramesh, B., Jarke, M.: Toward reference models for requirements traceability. IEEE Transactions on Software Engineering 27(1), 58–93 (2001)
Ramesh, B., Stubbs, C., Powers, T., Edwards, M.: Requirements traceability: Theory and practice. Annals of Software Engineering 3(1), 397–415 (1997)
Samia Kaabi, R., Souveyet, C., Rolland, C.: Eliciting service composition in a goal driven manner. In: ICSOC, pp. 308–315 (2004)
Spanoudakis, G., Zisman, A.: Software traceability: a roadmap. Handbook of Software Engineering and Knowledge Engineering (2005)
Vassiliadis, P.: Data Warehouse Modeling and Quality Issues. Ph.D. thesis, Athens (2000)
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)
Winkler, S., von Pilgrim, J.: A survey of traceability in requirements engineering and model-driven development. Software and Systems Modeling 9, 529–565 (2010)
Yu, E.S.K.: Modelling strategic relationships for process reengineering. Ph.D. thesis, Toronto, Ont., Canada (1995)
Yu, Y., Jurjens, J., Mylopoulos, J.: Traceability for the maintenance of secure software. In: ICSM 2008, pp. 297–306. IEEE, Los Alamitos (2008)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Maté, A., Trujillo, J. (2011). A Trace Metamodel Proposal Based on the Model Driven Architecture Framework for the Traceability of User Requirements in Data Warehouses. In: Mouratidis, H., Rolland, C. (eds) Advanced Information Systems Engineering. CAiSE 2011. Lecture Notes in Computer Science, vol 6741. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-21640-4_11
Download citation
DOI: https://doi.org/10.1007/978-3-642-21640-4_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-21639-8
Online ISBN: 978-3-642-21640-4
eBook Packages: Computer ScienceComputer Science (R0)