Sciweavers

SPE
2008

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

13 years 3 months ago
A relational-XML data warehouse for data aggregation with SQL and XQuery
: 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 activities, 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 th...
Joseph Fong, Herbert Shiu, Davy Cheung
Added 15 Dec 2010
Updated 15 Dec 2010
Type Journal
Year 2008
Where SPE
Authors Joseph Fong, Herbert Shiu, Davy Cheung
Comments (0)