期刊名称：International Journal of Software Engineering & Applications (IJSEA)
印刷版ISSN：0976-2221
电子版ISSN：0975-9018
出版年度：2012
卷号：3
期号：1
页码：197
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：Data Warehouse is one of the most common ways for analyzing large data for decision based system. Thesedata are often sourced from online transactional system. The transactional data are represented indifferent formats. XML is one of the worldwide standards to represent data in web based system. Numbersof organizations use XML for e-commerce and internet based applications. Integration of XML and datawarehouse for the innovation of business logic and to enhance decision making has therefore emerged as ademanding area of research interest. This paper focuses on integrating XML data based on multiple relatedXML schemas, to an equivalent data warehouse schemas based on relational online analytical processing(ROLAP). This work bears a high relevance towards standardizing of the ETL phase (Extraction,Transformation, and Loading) of the OLAP projects. The novelty of the work is that more than one datawarehouse schemas could be identified from a single related XML schema and each of them could becategorized as star schema or snowflake schema. Moreover if the individual schemas are found to berelated according to the analysis, fact constellation could be identified. A new data structure, SchemaGraph has been proposed in the process.
关键词：XML; Data Warehouse; Fact Constellation Schema; Star Schema; Snowflake Schema; Schema Graph
