English

应用科学学报 ›› 2003, Vol. 21 ›› Issue (4): 362-366.

• 论文 • 上一篇    下一篇

基于OLAP查询的数据仓库视图的水平分割

胡孔法1, 董逸生1, 徐立臻1, 赵庆建2   

  1. 1 东南大学计算机科学与工程系 江苏 南京 210096;
    2 东南大学经济管理学院 江苏 南京 210096
  • 收稿日期:2002-10-11 修回日期:2002-12-31 出版日期:2003-12-10 发布日期:2003-12-10
  • 作者简介:胡孔法(1970-),男,安徽安庆人,工程师,博士生;董逸生(1940-),男,江苏启东人,教授,博导.
  • 基金资助:
    国家863/CIMS基金(6409002012);江苏省九五重点攻关课题(BG980171);江苏省十五高科技(BG2001013)资助项目

Horizontally Partitioning the Data Warehouse Views Based on OLAP Queries

HU Kong-fa1, DONG Yi-sheng1, XU Li-zhen1, ZHAO Qing-jian2   

  1. 1. Department of Computer Science and Engineering, Southeast Universtity, Nanjing 210096, China;
    2. School of Economics & Management, Southeast University, Nanjing 210096, China
  • Received:2002-10-11 Revised:2002-12-31 Online:2003-12-10 Published:2003-12-10

PDF

102

被引次数

13

摘要： 选择数据仓库视图进行有效的水平分割,使OLAP查询通过访问较少的分割裂片以及较少的元组就可以完成,从而加快查询响应时间,削减维护费用.提出根据OLAP查询中的选择谓词构造其最小项谓词,选择数据仓库立方体视图,进行水平分割和实体化,来提高OLAP查询效率.

关键词: OLAP查询, 实视图, 数据仓库, 元数据

Abstract: OLAP querying is a complex process and the volume of data involved is so large that query response time has become an important warehousing issue. We can select data warehouse views to parttion horizontally in an efficient manner so that OLAP queries will scan fewer fragments and in turn scan fewer rows in the original view. Based on the minterm predicates of OLAP queries, the paper proposes a method for selecting and efficient horizontal partitioning of warehouse cube views in order to improve the efficiency of the OLAP queries.

Key words: data warehouse, materialized views, OLAP queries, metadata

中图分类号: