DOIONLINE 
DOIONLINE Publish In |
International Journal of Advances in Electronics and Computer Science-IJAECS |
 Journal Home Volume Issue |
||||||||
Issue |
Volume-3,Issue-2 ( Feb, 2016 ) | |||||||||
Paper Title |
Co-Xml/DW: Converting Xml Sources Into Data Warehouse Design | |||||||||
Author Name |
Thidar Win, Khin Nweni Tun | |||||||||
Affilition |
University of Computer Studies, Yangon | |||||||||
Pages |
1-6 | |||||||||
Abstract |
XML (eXtensible Markup Language) and schema language are data exchange format in web based system. Many organizations widely use XML for e-commerce and internet based applications. On the other hand, data warehouse maintains historical data and analyze data which is used by organizations to enhance decision making on the business process. XML data was insufficient to analyze on the Web. So it is required to convert a given XML schema into data warehouse schemas and to systematically analyze. This paper proposes a hierarchical design framework conversion of XML/DW to provide a suitable multidimensional data model for relational online analytical processing (ROLAP). We present an automatic approach to support this schema conversion process based on the source of data that are XML schema and conforming XML document. We get more than one data warehouse schemas from the given XML schema using Schema Graph and Extended Entity- Relationship Model. The conversion algorithm comes into being where both correct structures and hidden integrity constraints are translated. Index Terms- XML, XML Schema, Data Warehouse, Star, Snowflake, Fact Constellation Schema, ROLAP, Schema Graph, Extended Entity-Relationship. | |||||||||
| View Paper | ||||||||||
