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

Abstract

Integrating information from multiple data sources is becoming increasingly important for enterprises that partner with other companies for e‐commerce. However, companies have their internal business applications deployed on diverse platforms and no standard solution for integrating information from these sources exists. To support business intelligence query activities, it is useful to build a data warehouse on top of middleware that aggregates the data obtained from various heterogeneous database systems. Online analytical processing (OLAP) can then be used to provide fast access to materialized views from the data warehouse. Since extensible markup language (XML) documents are a common data representation standard on the Internet and relational tables are commonly used for production data, OLAP must handle both relational and XML data. SQL and XQuery can be used to process the materialized relational and XML data cubes created from the aggregated data. This paper shows how to handle the two kinds of data cubes from a relational–XML data warehouse using extract, transformation and loading. Copyright © 2008 John Wiley & Sons, Ltd.

Semantic similarity measurement using historical google search patterns

“…There are a lot of disciplines where we can benefit from these capabilities [18]. Within the most relevant areas is the data warehouse field where applications are characterized by heterogeneous models that have to be analyzed and matched either manually or semi-automatically at design time [14]. The main advantage of matching these models consists of enabling a broader knowledge base for decision-support systems, knowledge discovery and data mining than each of the independent warehouses could offer separately [3].…”

A heuristic approach to selecting views for materialization

“…When dealing with data harvested from web sources or online services, XML is generally the common format used , because of its highly interoperable nature. Even relational XML hybrid approaches show that there exists a requirement to manage XML data using XML specific languages such as XQuery. However, queries over XML data do not perform as well as data warehouse systems using a standard relational model.…”