Notification: Our email services are now fully restored after a brief, temporary outage caused by a denial-of-service (DoS) attack. If you sent an email on Dec 6 and haven't received a response, please resend your email.
CFP last date
20 December 2024
Reseach Article

Conversion of XML Schema to Data Warehouse Schema using Automatic Approach

by Thidar Win
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

@article{ 10.5120/18986-0424,
author = { Thidar Win },
title = { Conversion of XML Schema to Data Warehouse Schema using Automatic Approach },
journal = { International Journal of Computer Applications },
issue_date = { December 2014 },
volume = { 108 },
number = { 15 },
month = { December },
year = { 2014 },
issn = { 0975-8887 },
pages = { 12-18 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume108/number15/18986-0424/ },
doi = { 10.5120/18986-0424 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:43:03.441880+05:30
%A Thidar Win
%T Conversion of XML Schema to Data Warehouse Schema using Automatic Approach
%J International Journal of Computer Applications
%@ 0975-8887
%V 108
%N 15
%P 12-18
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
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
  1. Arijit, S. and Erik,W. 2006. "The case for conceptual modeling for xml", Technical report, Computer Engineering and Networks Laboratory, ETH Zurich.
  2. 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.
  3. M. Jensen, T. Miller, and T. B. Pedersen, "Specifying OLAP Cubes on XML Data", Journal of Intelligent Information Systems, 2001.
  4. Parimala N and Payel, P. , "From XML schema to cube" International Journal of Computer Theory and Engineering; Vol. 1, No 3 August 2009.
  5. 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.
  6. 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.
  7. 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).
  8. Gunjan, C. , "Designing of Star Schemas from XML Document", International Journal of Multidisciplinary and Current Research,2014.
  9. Matteo, G. , Stefano, R. and Boris, V. ,"Data warehouse design from XML sources", Proceedings of the 4th ACM international workshop, 2001.
Index Terms

Computer Science
Information Sciences

Keywords

XML XML Schema Data Warehouse Star Schema Snowflake Schema Fact Constellation Schema ROLAP Schema Graph.