ROLAP based data warehouse schema to XML schema conversion

Data Warehouse is one of the powerful tools for analytical processing. XML on the other hand is widely used to handle data in web environment. XML to data warehouse integration is a subject of interest for the business organization to use the semi-structured XML for analytical processing. However, in this research work we approached the problem in reverse direction. Here we generate equivalent XML schema from the existing data warehouse schema for an organization which does not has the XML platform to manage the web data. The proposed reverse engineering framework uses one of the existing methodologies of converting the XML schema to data warehouse schema. However, we have applied it in a reverse approach. Moreover we have established a formalism to prove the soundness and correctness of both the conversion mechanisms.

[1]  Hexin Chen,et al.  Multi-dimension Multimedia Retrieval Model Implementation Based on XML Database , 2009, 2009 International Conference on Signal Processing Systems.

[2]  Tharam S. Dillon,et al.  Conceptual Design of an XML FACT Repository for Dispersed XML Document Warehouses and XML Marts , 2005, The Fifth International Conference on Computer and Information Technology (CIT'05).

[3]  N. Parimala,et al.  From XML Schema to Cube , 2009 .

[4]  Torben Bach Pedersen,et al.  Converting XML DTDs to UML diagrams for conceptual data integration , 2001, Data Knowl. Eng..

[5]  Eduardo Fernández-Medina,et al.  Model driven development of secure XML data warehouses: a case study , 2010, EDBT '10.

[6]  Maya Ramanath,et al.  A rank-rewrite framework for summarizing XML documents , 2008, 2008 IEEE 24th International Conference on Data Engineering Workshop.

[7]  Rachid Chalal,et al.  Towards the automation of XML data warehouse logical design , 2014, Ninth International Conference on Digital Information Management (ICDIM 2014).

[8]  Omar Boussaïd,et al.  X-Warehousing: An XML-Based Approach for Warehousing Complex Data , 2006, ADBIS.

[9]  Soumya Sen,et al.  INTEGRATING XML DATA INTO MULTIPLE ROLAP DATA WAREHOUSE SCHEMAS , 2012 .

[10]  Boris Vrdoljak,et al.  Data warehouse design from XML sources , 2001, DOLAP '01.

[11]  Soumya Sen,et al.  A Framework to Convert XML Schema to ROLAP , 2011, 2011 Second International Conference on Emerging Applications of Information Technology.

[12]  Torben Bach Pedersen,et al.  Specifying OLAP Cubes on XML Data , 2001, Proceedings Thirteenth International Conference on Scientific and Statistical Database Management. SSDBM 2001.

[13]  Rachid Chalal,et al.  A global and comprehensive approach for XML data warehouse design , 2014, 2014 IEEE/ACS 11th International Conference on Computer Systems and Applications (AICCSA).

[14]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.