您的位置: 专家智库 > 资助详情>国家自然科学基金(s60473069)

国家自然科学基金(s60473069)

作品数:1 被引量:2H指数:1
发文基金:国家自然科学基金更多>>
相关领域:自动化与计算机技术更多>>

文献类型

  • 1篇中文期刊文章

领域

  • 1篇自动化与计算...

主题

  • 1篇NO
  • 1篇OLAP
  • 1篇EFFICI...
  • 1篇N-
  • 1篇DISTRI...

传媒

  • 1篇Journa...

年份

  • 1篇2006
1 条 记 录,以下是 1-1
排序方式:
Efficient Incremental Maintenance for Distributive and Non-Distributive Aggregate Functions被引量:2
2006年
Data cube pre-computation is an important concept for supporting OLAP (Online Analytical Processing) and has been studied extensively. It is often not feasible to compute a complete data cube due to the huge storage requirement. Recently proposed quotient cube addressed this issue through a partitioning method that groups cube cells into equivalence partitions. Such an approach not only is useful for distributive aggregate functions such as SUM but also can be applied to the maintenance of holistic aggregate functions like MEDIAN which will require the storage of a set of tuples for each equivalence class. Unfortunately, as changes are made to the data sources, maintaining the quotient cube is non-trivial since the partitioning of the cube cells must also be updated. In this paper, the authors design incremental algorithms to update a quotient cube efficiently for both SUM and MEDIAN aggregate functions. For the aggregate function SUM, concepts are borrowed from the principle of Galois Lattice to develop CPU-efficient algorithms to update a quotient cube. For the aggregate function MEDIAN, the concept of a pseudo class is introduced to further reduce the size of the quotient cube, Coupled with a novel sliding window technique, an efficient algorithm is developed for maintaining a MEDIAN quotient cube that takes up reasonably small storage space. Performance study shows that the proposed algorithms are efficient and scalable over large databases.
李翠平王珊
关键词:OLAP
共1页<1>
聚类工具0