Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bhowmick, S.S., Madria, S.K., Ng, W.-K., Lim, E.P.: Web Warehousing: Design and Issues. In: Proc. DWDM 1998, Singapore (1998)
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)
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)
Golfarelli, M., Rizzi, S., Vrdoljak, B.: Data warehouse design from XML sources. In: Proc. DOLAP 2001, Atlanta, pp. 40–47 (2001)
Jensen, M., Møller, T., Pedersen, T.B.: Specifying OLAP Cubes On XML Data. Journal of Intelligent Information Systems (2001)
Jensen, M., Møller, T., Pedersen, T.B.: Converting XML Data To UML Diagrams For Conceptual Data Integration. In: Proc. DIWeb 2001, Interlaken (2001)
Kimball, R.: The data warehouse toolkit. John Wiley & Sons, Chichester (1996)
Niemi, T., Niinimäki, M., Nummenmaa, J., Thanisch, P.: Constructing an OLAP cube from distributed XML data. In: Proc. DOLAP 2002, McLean (2002)
Pokorny, J.: Modeling stars using XML. In: Proc. DOLAP 2001 (2001)
Shanmugasundaram, J., et al.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: Proc. 25th VLDB (1999)
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)
World Wide Web Consortium (W3C), XML 1.0 Specification, http://www.w3.org/TR/2000/REC-xml-20001006
World Wide Web Consortium (W3C), XML Schema, http://www.w3.org/XML/Schema
World Wide Web Consortium (W3C), XML Schema Part 0: Primer, http://www.w3.org/TR/xmlschema-0/
World Wide Web Consortium (W3C), XQuery 1.0: An XML Query Language (Working Draft), http://www.w3.org/TR/xquery/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vrdoljak, B., Banek, M., Rizzi, S. (2003). Designing Web Warehouses from XML Schemas. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2003. Lecture Notes in Computer Science, vol 2737. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45228-7_10
Download citation
DOI: https://doi.org/10.1007/978-3-540-45228-7_10
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40807-9
Online ISBN: 978-3-540-45228-7
eBook Packages: Springer Book Archive