Abstract—Data warehousing technology aims at providing support for decision making for operational data. Defining adata 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.
Index Terms—Data warehouse, XML schema, OLAP, Multidimensional Cubes, Attribute tree, Data Warehouse design
Prof. Parimala N. is Dean (School of computer and system sciences), Jawaharlal Nehru University, Delhi, India.
Prof. Payal Pahwa is professor in Guru Premsukh Memorial College of Engineering, I.P. university, Delhi.
Cite: Parimala N. and Payal Pahwa, "From XML Schema to Cube," International Journal of Computer Theory and Engineering vol. 1, no. 3, pp. 236-243, 2009.