Multidimensional Design by Examples

  • Oscar Romero
  • Alberto Abelló
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4081)


In this paper we present a method to validate user multidimensional requirements expressed in terms of SQL queries. Furthermore, our approach automatically generates and proposes the set of multidimensional schemas satisfying the user requirements, from the organizational operational schemas. If no multidimensional schema is generated for a query, we can state that requirement is not multidimensional.


Multidimensional Design Design by Examples DW 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An extension of UML. Information Systems 31(6), 541–567 (2006)CrossRefGoogle Scholar
  2. 2.
    Böhnlein, M., vom Ende, A.U.: Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. In: Proc. of 2nd Int. Workshop on Data Warehousing and OLAP (DOLAP 1999), pp. 15–21. ACM Press, New York (1999)CrossRefGoogle Scholar
  3. 3.
    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
  4. 4.
    Calvanese, D., Dragone, L., Nardi, D., Rosati, R., Trisolini, S.: Enterprise Modeling and Data Warehousing in TELECOM ITALIA. Information Systems (2006)Google Scholar
  5. 5.
    Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Proc. of 8th Int. Workshop on Data Warehousing and OLAP (DOLAP 2005), pp. 47–56. ACM Press, New York (2005)CrossRefGoogle Scholar
  6. 6.
    Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. Journals of Cooperative Information Systems (IJCIS) 7(2-3), 215–247 (1998)CrossRefGoogle Scholar
  7. 7.
    Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual Data Warehouse Modeling. In: Proc. of DMDW (2000),
  8. 8.
    Kimball, R., Reeves, L., Thornthwaite, W., Ross, M.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, Inc., Chichester (1998)Google Scholar
  9. 9.
    Lenz, H.J., Shoshani, A.: Summarizability in OLAP and Statistical Data Bases. In: Proc. of SSDBM 1997, IEEE, Los Alamitos (1997)Google Scholar
  10. 10.
    Luján-Mora, S., Trujillo, J.: A comprehensive method for data warehouse design. In: Proc. of DMDW 2003, vol. 77 (2003),
  11. 11.
    Moody, D.L., Kortink, M.A.: From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. In: Proc. of DMDW (2000),
  12. 12.
    Winter, R., Strauch, B.: A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects. In: Proc. of HICSS 2003, pp. 231–239. IEEE, Los Alamitos (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Oscar Romero
    • 1
  • Alberto Abelló
    • 1
  1. 1.Universitat Politècnica de CatalunyaBarcelonaSpain

Personalised recommendations