Exploiting the multi-append-only-trend property of historical data in data warehouses

Hua Gang Li, Divyakant Agrawal, Amr El Abbadi, Mirek Riedewald

Research output: Contribution to journalArticle

2 Citations (Scopus)


Data warehouses maintain historical information to enable the discovery of trends and developments over time. Hence data items usually contain time-related attributes like the time of a sales transaction or the order and shipping date of a product. Furthermore the values of these time-related attributes have a tendency to increase over time. We refer to this as the Multi-Append-Only-Trend (MAOT) property. In this paper we formalize the notion of MAOT and show how taking advantage of this property can improve query performance considerably. We focus on range aggregate queries which are essential for summarizing large data sets. Compared to MOLAP data cubes the amount of pre-computation and hence additional storage in the proposed technique is dramatically reduced.

Original languageEnglish
Pages (from-to)179-198
Number of pages20
JournalLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Publication statusPublished - 1 Dec 2003

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Fingerprint Dive into the research topics of 'Exploiting the multi-append-only-trend property of historical data in data warehouses'. Together they form a unique fingerprint.

  • Cite this