The week's pick
Reseach Article
Conversion of XML Schema to Data Warehouse Schema using Automatic Approach
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 108 - Number 15 |
| Year of Publication: 2014 |
| Authors: Thidar Win |
10.5120/18986-0424
|
Thidar Win . Conversion of XML Schema to Data Warehouse Schema using Automatic Approach. International Journal of Computer Applications. 108, 15 ( December 2014), 12-18. DOI=10.5120/18986-0424
Abstract
eXtensible Markup Language (XML) is data exchange format for representation data in Web based system. XML is used by many organizations for e-commerce and internet based applications such as online shopping, digital library, and electronic devices and so on. XML data is not sufficient to analyze on the Web. So XML is required to systematically analyze by industrial organizations to enable enhanced decision making. On the other hand, Data Warehouses are used by the most of the organizations for analyzing large data on their business. Conversion of XML schema and Data Warehouse schema has emerged as a continuous research area. This paper proposes a hierarchical design framework conversion of XML schema into the various Data Warehouse schema based on ROLAP. In this paper, we describe an automatic approach to support this conversion process. Our approach is based on the source of data that are XML schema and conforming XML document for designing Data Warehouse. We define more than one Data Warehouse schemas from the given XML schema using the Schema Graph has been proposed in the conversion process.
References
- Arijit, S. and Erik,W. 2006. "The case for conceptual modeling for xml", Technical report, Computer Engineering and Networks Laboratory, ETH Zurich.
- Haitao, C. and Husheng, L. , "A Survey to Conceptual Modeling for XML", College of Computer Sciences Beijing University of Technology Beijing, China, 978-1-4244-5539-3/©2010 IEEE.
- M. Jensen, T. Miller, and T. B. Pedersen, "Specifying OLAP Cubes on XML Data", Journal of Intelligent Information Systems, 2001.
- Parimala N and Payel, P. , "From XML schema to cube" International Journal of Computer Theory and Engineering; Vol. 1, No 3 August 2009.
- S. Dasgupta, S. Sen and N. Chaki, "A Framework To Convert XML Schema to ROLAP"; Proc. of the Second International Conference on Emerging Applications of Information Technology (EAIT 2011), Kolkata, India, 2011 ISBN : 978-1-4244-9683-9.
- Soumya, S. , Ranak G. , Debanjali, P. and Nabendu, C. "Integrating Related XML Data into Multiple Data Warehouse Schemas" University of Calcutta Kolkata -700009 West Bengal, India, JSE-2012, CS & IT 04, pp. 357–367.
- Soumya, S. , Ranak G. , Debanjali, P. and Nabendu, C. 2012, "Integrating Related XML Data Into Multiple ROLAP Warehouse Schemas", International Journal of Software Engineering & Applications (IJSEA).
- Gunjan, C. , "Designing of Star Schemas from XML Document", International Journal of Multidisciplinary and Current Research,2014.
- Matteo, G. , Stefano, R. and Boris, V. ,"Data warehouse design from XML sources", Proceedings of the 4th ACM international workshop, 2001.
Index Terms
Keywords