A Set of QVT Relations to Assure the Correctness of Data Warehouses by Using Multidimensional Normal Forms

  • Jose-Norberto Mazón
  • Juan Trujillo
  • Jens Lechtenbörger
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4215)


It is widely accepted that a requirement analysis phase is necessary to develop data warehouses (DWs) which adequately represent the information needs of DW users. Moreover, since the DW integrates the information provided by data sources, it is also crucial to take these sources into account throughout the development process to obtain a consistent representation. In this paper, we use multidimensional normal forms to define a set of Query/View/Transformation (QVT) relations to assure that the DW designed from user requirements agrees with the available data sources that will populate the DW. Thus, we propose a hybrid approach to develop DWs, i.e., we firstly obtain the conceptual schema of the DW from user requirements and then we verify and enforce its correctness against data sources by using a set of QVT relations based on multidimensional normal forms.


User Requirement Data Warehouse Dimension Level Object Management Group Source Database 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Inmon, W.: Building the Data Warehouse. Wiley, Chichester (2002)Google Scholar
  2. 2.
    Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley & Sons, Chichester (2002)Google Scholar
  3. 3.
    Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A conceptual model for data warehouses. Int. J. Cooperative Inf. Syst. 7(2-3), 215–247 (1998)CrossRefGoogle Scholar
  4. 4.
    Cabibbo, L., Torlone, R.: A logical approach to multidimensional databases. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 183–197. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  5. 5.
    Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse modeling. In: Jeusfeld, M.A., Shu, H., Staudt, M., Vossen, G. (eds.) DMDW, CEUR Workshop Proceedings, CEUR-WS.org., vol. 28, p. 6 (2000)Google Scholar
  6. 6.
    Lechtenbörger, J., Vossen, G.: Multidimensional normal forms for data warehouse design. Inf. Syst. 28(5), 415–434 (2003)MATHCrossRefGoogle Scholar
  7. 7.
    Winter, R., Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: HICSS, p. 231 (2003)Google Scholar
  8. 8.
    Prakash, N., Singh, Y., Gosain, A.: Informational scenarios for data warehouse requirements elicitation. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 205–216. Springer, Heidelberg (2004)CrossRefGoogle Scholar
  9. 9.
    Mazón, J.N., Trujillo, J., Serrano, M., 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., Wieringa, R. (eds.) REBNITA, pp. 44–53. University of New South Wales Press (2005)Google Scholar
  10. 10.
    Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: DOLAP, pp. 47–56 (2005)Google Scholar
  11. 11.
    Object Management Group: MDA Guide 1.0.1, http://www.omg.org/cgi-bin/doc?omg/03-06-01 (visited January 2006)
  12. 12.
    Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: DOLAP, pp. 57–66 (2005)Google Scholar
  13. 13.
    Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering (in press, 2006)Google Scholar
  14. 14.
    Lehner, W., Albrecht, J., Wedekind, H.: Normal forms for multidimensional databases. In: Rafanelli, M., Jarke, M. (eds.) SSDBM, pp. 63–72. IEEE Computer Society, Los Alamitos (1998)Google Scholar
  15. 15.
    Tryfona, N., Busborg, F., Christiansen, J.G.B.: starER: A conceptual model for data warehouse design. In: DOLAP, pp. 3–8. ACM, New York (1999)Google Scholar
  16. 16.
    Object Management Group: MOF 2.0 Query/View/Transformation, http://www.omg.org/cgi-bin/doc?ptc/2005-11-01 (visited January 2006)
  17. 17.
    Bernstein, P.A.: Synthesizing third normal form relations from functional dependencies. ACM Trans. Database Syst. 1(4), 277–298 (1976)CrossRefGoogle Scholar
  18. 18.
    Object Management Group: Common Warehouse Metamodel Specification 1.1., http://www.omg.org/cgi-bin/doc?formal/03-03-02 (visited January 2006)
  19. 19.
    Mellor, S., Scott, K., Uhl, A., Weise, D.: MDA distilled: principles of Model-Driven Architecture. Addison-Wesley, Reading (2004)Google Scholar
  20. 20.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J 10(4), 334–350 (2001)MATHCrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Jose-Norberto Mazón
    • 1
  • Juan Trujillo
    • 1
  • Jens Lechtenbörger
    • 2
  1. 1.Dept. of Software and Computing SystemsUniversity of AlicanteSpain
  2. 2.Dept. of Information SystemsUniversity of MünsterGermany

Personalised recommendations