Designing Web Warehouses from XML Schemas

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.

• Type: Conference
• Year: 2003
• Where: DAWAK
• Authors: Boris Vrdoljak, Marko Banek, Stefano Rizzi
• Keywords: Data Mining, DAWAK 2003, Web Warehouses, XML Data, Xml Schema