A relational-XML data warehouse for data aggregation with SQL and XQuery

Joseph Fong, Herbert Shiu, Davy Cheung
2008 Software, Practice & Experience  
Integration of multiple data sources is becoming increasingly important for enterprises that cooperate closely with their partners for e-commerce. OLAP enables analysts and decision makers fast access to various materialized views from data warehouses. However, many corporations have internal business applications deployed on different platforms. No standard solution for integration exists, except to develop an autonomous system for large enterprises. To enable business intelligence query
more » ... ties, a corporation needs to build a data warehouse on top of a middleware to aggregate summarized data from various heterogeneous database systems. Since XML documents are a common data representation standard on the Internet -and relational tables are traditional production data -OLAP must handle both relational and XML data on the World Wide Web. SQL and XQuery can be used to process the materialized relational and XML data cubes of aggregated data. This paper aims to facilitate handling these two data cubes from a Relational-XML data warehouse with ETL (Extract, Transformation and Loading).
doi:10.1002/spe.868 fatcat:tuq6y5atajb5rghbhlibld5hdi