|
>Home>Learn XQuery>White Papers>XQuery Myths>On-Line Analytical Processing
Print
Misunderstanding: XQuery offers nothing to On-Line Analytical Processing (OLAP) and data warehousing applications
XQuery does provide needed linking capabilities to OLAP and data warehousing applications. For instance, the average enterprise commonly has more than one data warehouse to track and analyze company data. These warehouses act like data silos and require effort, money, and expertise to mine for business knowledge. Linking one silo to another is usually a huge and expensive effort. XQuery offers a solution to assist OLAP by providing a query-based link between multiple data warehouses. For example, one data warehouse stores products shipped for a home supply retail chain, and a second data warehouse stores product support call logs for the products offered in the retail chain. XQuery bridges these data warehouses by showing which products cause the most unresolved support calls. This illustrates the XQuery advantage in logical data warehousing, analytics, extract/transform/load (ETL), and enterprise application integration (EAI).
|