Advertisement

A Web-Oriented Approach to Manage Multidimensional Models through XML Schemas and XSLT

  • Sergio Luján-Mora
  • Enrique Medina
  • Juan Trujillo
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2490)

Abstract

Multidimensional (MD) modeling is the foundation of data warehouses, MD databases, and OLAP applications. In the last years, there have been some proposals to represent MD properties at the conceptual level. In this paper, we present how to manage the representation, manipulation, and presentation of MD models on the web by means of eXtensible Stylesheet Language Transformations (XSLT). First, we use eXtensible Markup Language (XML) to consider main MD modeling properties at the conceptual level. Next, an XML Schema allows us to generate valid XML documents that represent MD models. Finally, we provide XSLT stylesheets that allow us to automatically generate HTML pages from XML documents, thereby supporting different presentations of the same MD model easily. A CASE tool that gives support to all theoretical issues presented in the paper has been developed.

Keywords

Multidimensional modeling UML XML XML Schema XSLT 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Golfarelli, M., Rizzi, S.: A methodological Framework for Data Warehouse Design. In: Proc. of the ACM 1st Intl. Workshop on Data warehousing and OLAP (DOLAP’98), Washington D.C., USA (1998) 3–9Google Scholar
  2. 2.
    Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. In: Proc. of the 1st Intl. Workshop on Data Warehouse and Data Mining (DWDM’98). Volume 1552 of LNCS., Springer-Verlag (1998) 105–116Google Scholar
  3. 3.
    Trujillo, J., Gómez, J., Palomar, M.: Modeling the Behavior of OLAP Applications Using an UML Compilant Approach. In: Proc. of the 1st Intl. Conf. On Advances in Information Systems (ADVIS’00). Volume 1909 of LNCS., Springer-Verlag (2000) 14–23Google Scholar
  4. 4.
    Trujillo, J., Palomar, M., Gómez, J., Song, I.Y.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses 34 (2001) 66–75Google Scholar
  5. 5.
    Tryfona, N., Busborg, F., Christiansen, J.: starER: A Conceptual Model for Data Warehouse Design. In: Proc. of the ACM 2nd Intl. Workshop on Data warehousing and OLAP (DOLAP’99), Kansas City, Missouri, USA (1999)Google Scholar
  6. 6.
    Abelló, A., Samos, J., Saltor, F.: A Framework for the Classification and Description of Multidimensional Data Models. In: Proc. of the 12th Intl. Conference on Database and Expert Systems Applications (DEXA’01), Munich, Germany (2001) 668–677Google Scholar
  7. 7.
    World Wide Web Consortium (W3C): eXtensible Markup Language (XML) 1.0 (SE). Internet: http://www.w3.org/TR/2000/REC-xml-20001006 (2000)
  8. 8.
    World Wide Web Consortium (W3C): XML Schema. Internet: http://www.w3.org/TR/2001/REC-xmlschema-0-20010502/ (2001)
  9. 9.
    World Wide Web Consortium (W3C): XSL Transformations (XSLT) Version 1.0. Internet: http://www.w3.org/TR/1999/REC-xslt-19991116 (1999)
  10. 10.
    Object Management Group (OMG): Unified Modeling Language (UML). Internet: http://www.omg.org/cgi-bin/doc?formal/01-09-67 (2001)
  11. 11.
    Pokorný, J.: Modelling Stars Using XML. In: Proc. of the ACM 4th Intl. Workshop on Data warehousing and OLAP (DOLAP’01), Atlanta, GA USA (2001)Google Scholar
  12. 12.
    Golfarelli, M., Rizzi, S., Vrdoljak, B.: Data warehouse design from XML sources. In: Proc. of the ACM 4th Intl. Workshop on Data warehousing and OLAP (DOLAP’01), Atlanta, GA USA (2001)Google Scholar
  13. 13.
    Gergatsoulis, M., Stavrakas, Y., Karteris, D.: A Web-Based System for Handling Multidimensional Information through MXML. In Albertas Caplinskas and Johann Eder, ed.: Proc. of the 5th East European Conference on Advances in Databases and Information Systems (ADBIS’01). Volume 2151 of LNCS., Vilnius, Lithuania, Springer-Verlag (2001)Google Scholar
  14. 14.
    Giovinazzo, W.: Object-Oriented Data Warehouse Design. Building a star schema. Prentice-Hall, New Jersey, USA (2000)Google Scholar
  15. 15.
    Kimball, R.: The data warehousing toolkit. 2 edn. John Wiley (1996)Google Scholar
  16. 16.
    Luján-Mora, S., Medina, E., Trujillo, J.: From Object-Oriented Conceptual Multidimensional Modeling into XML. Technical report, DLSI-Univ. of Alicante (2001) Internet: http://gplsi.dlsi.ua.es/almacenes/files/oomd-mm-dtd.pdf.
  17. 17.
    World Wide Web Consortium (W3C): Extensible Stylesheet Language (XSL) 1.0. Internet: http://www.w3.org/TR/2001/REC-xsl-20011015/ (2001)
  18. 18.
    Object Management Group (OMG): Common Warehouse Metamodel (CWM). Internet: http://www.omg.org/cgi-bin/doc?ad/2001-02-01 (2000)

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Sergio Luján-Mora
    • 1
  • Enrique Medina
    • 1
  • Juan Trujillo
    • 1
  1. 1.Departamento de Lenguajes y Sistemas InformáticosUniversidad de AlicanteSPAIN

Personalised recommendations