Cubing web data based on multidimensional arrays

  • Authors:
  • Yan Zhu;Alejandro P. Buchmann

  • Affiliations:
  • School of Information Science and Technology, Southwest Jiaotong University, Chengdu, China;Department of Computer Science, Darmstadt University of Technology, Darmstadt, Germany

  • Venue:
  • ASIAN'05 Proceedings of the 10th Asian Computing Science conference on Advances in computer science: data management on the web
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data Warehousing and OLAP technologies enable enterprises to achieve Business Intelligence (BI). Since the Web is the largest independent information repository, systematically integrating suitable Web data into a data warehouse will benefit the enterprise. This paper introduces a Web data warehousing system in the MOLAP environment. A transformation approach is proposed to construct a base cube and then aggregates are precomputed over the base cube. To specify the aggregation rules we have developed a SQL style language that uses external functions for retrieving array data, computing aggregates, populating aggregated cubes.