Designing Web Warehouses from XML Schemas

  • Boris Vrdoljak
  • Marko Banek
  • Stefano Rizzi
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2737)


Web warehousing plays a key role in providing the managers with up-to-date and comprehensive information about their business domain. On the other hand, since XML is now a standard de facto for the exchange of semi-structured data, integrating XML data into web warehouses is a hot topic. In this paper we propose a semi-automated methodology for designing web warehouses from XML sources modeled by XML Schemas. In the proposed methodology, design is carried out by first creating a schema graph, then navigating its arcs in order to derive a correct multidimensional representation. Differently from previous approaches in the literature, particular relevance is given to the problem of detecting shared hierarchies and convergence of dependencies, and of modeling many-to-many relationships. The approach is implemented in a prototype that reads an XML Schema and produces in output the logical schema of the warehouse.


Dependency Graph Logical Schema Schema Graph Purchase Order Business Domain 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bhowmick, S.S., Madria, S.K., Ng, W.-K., Lim, E.P.: Web Warehousing: Design and Issues. In: Proc. DWDM 1998, Singapore (1998)Google Scholar
  2. 2.
    Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proc. HICSS 1931, Kona, Hawaii, vol. VII, pp. 334–343 (1998)Google Scholar
  3. 3.
    Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: a Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems 7(2&3), 215–247 (1998)CrossRefGoogle Scholar
  4. 4.
    Golfarelli, M., Rizzi, S., Vrdoljak, B.: Data warehouse design from XML sources. In: Proc. DOLAP 2001, Atlanta, pp. 40–47 (2001)Google Scholar
  5. 5.
    Jensen, M., Møller, T., Pedersen, T.B.: Specifying OLAP Cubes On XML Data. Journal of Intelligent Information Systems (2001)Google Scholar
  6. 6.
    Jensen, M., Møller, T., Pedersen, T.B.: Converting XML Data To UML Diagrams For Conceptual Data Integration. In: Proc. DIWeb 2001, Interlaken (2001)Google Scholar
  7. 7.
    Kimball, R.: The data warehouse toolkit. John Wiley & Sons, Chichester (1996)Google Scholar
  8. 8.
    Niemi, T., Niinimäki, M., Nummenmaa, J., Thanisch, P.: Constructing an OLAP cube from distributed XML data. In: Proc. DOLAP 2002, McLean (2002)Google Scholar
  9. 9.
    Pokorny, J.: Modeling stars using XML. In: Proc. DOLAP 2001 (2001)Google Scholar
  10. 10.
    Shanmugasundaram, J., et al.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: Proc. 25th VLDB (1999)Google Scholar
  11. 11.
    Song, I.Y., Rowen, W., Medsker, C., Ewen, E.: An analysis of many-to-many relationships between fact and dimension tables in dimensional modeling. In: Proc. DMDW, Interlaken, Switzerland, pp. 6.1–6.13 (2001)Google Scholar
  12. 12.
    World Wide Web Consortium (W3C), XML 1.0 Specification,
  13. 13.
    World Wide Web Consortium (W3C), XML Schema,
  14. 14.
    World Wide Web Consortium (W3C), XML Schema Part 0: Primer,
  15. 15.
    World Wide Web Consortium (W3C), XQuery 1.0: An XML Query Language (Working Draft),

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Boris Vrdoljak
    • 1
  • Marko Banek
    • 1
  • Stefano Rizzi
    • 2
  1. 1.FER – University of ZagrebZagrebCroatia
  2. 2.DEIS – University of BolognaBolognaItaly

Personalised recommendations