Skip to main navigation Skip to search Skip to main content

视图增量计算的延迟部分补偿算法

Translated title of the contribution: Deferred partial compensation algorithm for view increment computing

邹先霞, 潘久辉*, 贾维嘉

*Corresponding author for this work

Research output: Journal Publications and ReviewsRGC 21 - Publication in refereed journalpeer-review

Abstract

The asynchronous propagation algorithms for view increment computing took quite a long time and consumed a lot of computer's system resources, and the result of the partial compensation might be even wrong sometimes. To solve these problems of compensation algorithms, a deferred partial compensation algorithm in data sources was proposed. In this algorithm, the transaction commit timestamp of table changes was kept in data sources, and the latest transaction commit timestamp which was computed for view change was stored. If the table changed between the timestamp which maintained sub-query and the latest transaction commit timestamp, compensation query had to be enforced. Because compensation process referred to the time of single information source, this algorithm avoided the problems of global time and possible errors. Additionally, this algorithm took advantage of the primary and foreign keys to reduce computational cost. Experimental results showed that the proposed algorithm exhibited improvements over the traditional ones.
Translated title of the contributionDeferred partial compensation algorithm for view increment computing
Original languageChinese (Simplified)
Pages (from-to)1024-1031
Journal计算机集成制造系统
Volume17
Issue number5
DOIs
Publication statusPublished - May 2011

Research Keywords

  • 实化视图
  • 异步传播
  • 增量计算
  • 部分补偿
  • 数据仓库
  • 算法
  • Materialized view
  • Asynchronous propagation
  • Increment computing
  • Partial compensation
  • Data warehouses
  • Algorithms

Fingerprint

Dive into the research topics of 'Deferred partial compensation algorithm for view increment computing'. Together they form a unique fingerprint.

Cite this