Soumya Sen¹, Ranak Ghosh², Debanjali Paul² and Nabendu Chaki¹, ¹University of Calcutta Kolkata, India and ²Barrackpore Rastraguru Surendranath College, India

XML is a worldwide standard to represent data in web based system. Numbers of organizations use XML for e-commerce and internet based applications. On the other hand, data warehouse is used by most of the organizations for making decisions on their business by analyzing operational data. Integration of business logic based on data warehouse and XML based system has therefore emerged as a demanding area of research interest. This paper illustrates an approach to integrate XML data based on multiple related XML Schemas, to its compatible data warehouse schemas based on relational online analytical processing (ROLAP). The novelty of the work is that more than one type of data warehouse schemas could be identified from a single related XML schema. A new data structure, Schema Graph has been proposed in the process.

XML, XML Schema, Data Warehouse, Fact Constellation Schema, Star Schema, Snowflake Schema, Schema Graph