A Relational-XML Data Warehouse for Data Aggregation With SQL and XQuery
Source: City University of Hong Kong
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.