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

2008 ◽  
Vol 38 (11) ◽  
pp. 1183-1213 ◽  
Author(s):  
Joseph Fong ◽  
Herbert Shiu ◽  
Davy Cheung
Author(s):  
Xinjian Lu

A data warehouse stores and manages historical data for on-line analytical processing, rather than for on-line transactional processing. Data warehouses with sizes ranging from gigabytes to terabytes are common, and they are much larger than operational databases. Data warehouse users tend to be more interested in identifying business trends rather than individual values. Queries for identifying business trends are called analytical queries. These queries invariably require data aggregation, usually according to many different groupings. Analytical queries are thus much more complex than transactional ones. The complexity of analytical queries combined with the immense size of data can easily result in unacceptably long response times. Effective approaches to improving query performance are crucial to a proper physical design of data warehouses.


Author(s):  
Hadj Mahboubi

With the eXtensible Markup Language (XML) becoming a standard for representing business data (Beyer et al., 2005), a new trend toward XML data warehousing has been emerging for a couple of years, as well as efforts for extending the XQuery language with near On-Line Analytical Processing (OLAP) capabilities (grouping, aggregation, etc.). Though this is not an easy task, these new approaches, techniques and architectures aim at taking specificities of XML into account (e.g., heterogeneous number and order of dimensions or complex measures in facts, ragged dimension hierarchies…) that would be intricate to handle in a relational environment. The aim of this article is to present an overview of the major XML warehousing approaches from the literature, as well as the existing approaches for performing OLAP analyses over XML data (which is termed XML-OLAP or XOLAP; Wang et al., 2005). We also discuss the issues and future trends in this area and illustrate this topic by presenting the design of a unified, XML data warehouse architecture and a set of XOLAP operators expressed in an XML algebra.


2020 ◽  
Vol 309 ◽  
pp. 05010
Author(s):  
Songhe Mu ◽  
Qing Zhu ◽  
Yue Zhang ◽  
Yeteng An

The daily traffic volume of the State Grid 95598 Customer Service Center exceeds 800,000. In order to manage and store these massive data, we must carefully handle it. The call from electric customers implement the business philosophy of “Quality service is the lifeline of electric power enterprise”, and carry out related data aggregation, processing, statistics, conversion and analysis based on data warehouse, and fully explore and analyze these with big data analysis technology. The potential value in the data guides the optimization of business processes and improves the service quality and efficiency of the business center.


Sign in / Sign up

Export Citation Format

Share Document