Data warehousing technology aims at providing support for decision making for operational data. Defining a data warehouse for data stored in XML (Extensible Markup Language) format should be addressed as various organizations use XML to facilitate the promotion of their businesses. In this paper we describe a semi-automated approach for designing multiple Cubes of multidimensional model from XML schema. In our approach an attribute tree is arrived at by parsing the XML schema. Pruning and grafting are used to remove unnecessary nodes in the attribute tree. Facts, dimensions and measures, which are used to describe the multidimensional cube, are identified. Single or multiple facts can be chosen giving rise to multiple cubes. The choice construct of the XML schema is shown to give rise to multiple Cubes in both the cases.
Author:- Parimala N. and Payal Pahwa