Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms

Data and Knowledge Engineering

Volumn 63, Issue 3, 2007, Pages 725-751

  Mazón, Jose Norberto ^a   Trujillo, Juan ^a   Lechtenbörger, Jens ^b  

^a UNIVERSITY OF ALICANTE   (Spain)

^b UNIVERSITY OF MÜNSTER   (Germany)

Author keywords

Conceptual modeling; Data warehousing; Multidimensional normal forms; QVT; Requirements

Indexed keywords

COMPUTER AIDED SOFTWARE ENGINEERING; MATHEMATICAL MODELS; REQUIREMENTS ENGINEERING; USER INTERFACES;

CONCEPTUAL MODELING; DATA SOURCES; MULTIDIMENSIONAL NORMAL FORMS; QVT;

DATA WAREHOUSES;

EID: 34548664603     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2007.04.005     Document Type: Editorial

References (36)

1. Bernstein P.A. Synthesizing third normal form relations from functional dependencies. ACM Trans. Database Syst. 1 4 (1976) 277-298
2. Borland Together, http://www.borland.com/together.
3. Cabibbo L., and Torlone R. A logical approach to multidimensional databases. In: Schek H.-J., Saltor F., Ramos I., and Alonso G. (Eds). EDBT. Lecture Notes in Computer Science vol. 1377 (1998), Springer
4. Eclipse, http://www.eclipse.org.
5. P. Giorgini, S. Rizzi, M. Garzetti, Goal-oriented requirement analysis for data warehouse design, in: DOLAP, 2005.
6. Golfarelli M., Maio D., and Rizzi S. The dimensional fact model: a conceptual model for data warehouses. Int. J. Cooper. Inf. Syst. 7 2-3 (1998) 215-247
7. B. Hüsemann, J. Lechtenbörger, G. Vossen, Conceptual data warehouse modeling, in: M.A. Jeusfeld, H. Shu, M. Staudt, G. Vossen (Eds.), DMDW, CEUR Workshop Proceedings, vol. 28, CEUR-WS.org, 2000.
8. Inmon W. Building the Data Warehouse (2002), Wiley & Sons
9. Kimball R., and Ross M. The Data Warehouse Toolkit (2002), Wiley & Sons
10. J. Lechtenbörger, Data warehouse schema design, Ph.D. Thesis, University of Münster, Germany, 2001.
11. Lechtenbörger J., and Vossen G. Multidimensional normal forms for data warehouse design. Inf. Syst. 28 5 (2003) 415-434
12. Lehner W., Albrecht J., and Wedekind H. Normal forms for multidimensional databases. In: Rafanelli M., and Jarke M. (Eds). SSDBM (1998), IEEE Computer Society
13. Luján-Mora S., Trujillo J., and Song I.-Y. A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59 3 (2006) 725-769
14. Mazón J.-N., Pardillo J., and Trujillo J. Applying transformations to model driven data warehouses. In: Tjoa A.M., and Trujillo J. (Eds). DaWaK. Lecture Notes in Computer Science vol. 4081 (2006), Springer
15. J.-N. Mazón, J. Trujillo, An MDA approach for the development of data warehouses, Decis. Support Syst., in press, doi:10.1016/j.dss.2006.12.003.
16. Mazón J.-N., Trujillo J., and Lechtenbörger J. A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: Embley D.W., Olivé A., and Ram S. (Eds). ER. Lecture Notes in Computer Science vol. 4215 (2006), Springer
17. J.-N. Mazón, J. Trujillo, M. Serrano, M. Piattini, Applying MDA to the development of data warehouses, in: DOLAP, 2005.
18. Mazón J.-N., Trujillo J., Serrano M., and Piattini M. Designing data warehouses: from business requirement analysis to multidimensional modeling. In: Cox K., Dubois E., Pigneur Y., Bleistein S.J., Verner J., Davis A.M., and Wieringa R. (Eds). REBNITA (2005), University of New South Wales Press
19. Meliá S., Kraus A., and Koch N. MDA transformations applied to web application development. In: Lowe D., and Gaedke M. (Eds). ICWE. Lecture Notes in Computer Science vol. 3579 (2005), Springer
20. Mellor S., Scott K., Uhl A., and Weise D. MDA Distilled: principles of model-driven architecture (2004), Addison Wesley
21. Object Management Group, Architecture Driven Modernization (ADM) http://adm.omg.org/ (visited January 2006).
22. Object Management Group, Common Warehouse Metamodel Specification 1.1. http://www.omg.org/cgi-bin/doc?formal/03-03-02 (visited January 2006).
23. Object Management Group, MDA Guide 1.0.1. http://www.omg.org/cgi-bin/doc?omg/03-06-01 (visited January 2006).
24. Object Management Group, MOF 2.0 Query/View/Transformation. http://www.omg.org/cgi-bin/doc?ptc/2005-11-01 (visited January 2006).
25. Object Management Group, Object Constraint Language (OCL) specification 2.0 http://www.omg.org/cgi-bin/doc?ptc/03-10-14 (visited January 2006).
26. Object Management Group, Unified Modeling Language Specification 2.0. http://www.omg.org/cgi-bin/doc?formal/05-07-04 (visited January 2006).
27. Prakash N., Singh Y., and Gosain A. Informational scenarios for data warehouse requirements elicitation. In: Atzeni P., et al. (Ed). ER. Lecture Notes in Computer Science vol. 3288 (2004), Springer
28. Rahm E., and Bernstein P.A. A survey of approaches to automatic schema matching. VLDB J. 10 4 (2001) 334-350
29. J. Schiefer, B. List, R. Bruckner, A holistic approach for managing requirements of data warehouse systems, in: Eighth Americas Conference on Information Systems, 2002.
30. SmartQVT. An open source model transformation tool implementing the MOF 2.0 QVT-Operational language, http://smartqvt.elibel.tm.fr/.
31. N. Tryfona, F. Busborg, J.G.B. Christiansen, starER: A conceptual model for data warehouse design, in: DOLAP, ACM, 1999.
32. A. van Lamsweerde, Requirements engineering in the year 00: a research perspective, in: ICSE, 2000.
33. R. Winter, B. Strauch, A method for demand-driven information irequirements analysis in data warehousing projects, in: HICSS, 2003.
34. Winter R., and Strauch B. Information requirements engineering for data warehouse systems. In: Haddad H., Omicini A., Wainwright R.L., and Liebrock L.M. (Eds). SAC (2004), ACM
35. E. Yu, Modelling strategic relationships for process reenginering, Ph.D. thesis, University of Toronto, Canada, 1995.
36. Yu E. Towards modeling and reasoning support for early-phase requirements engineering. RE (1997), IEEE Computer Society