用多用户多窗口方法处理多维视图动态选择  

Dynamic Selection of Materialized Views of Multi Dimensional Data with a Multi-Users and Multi Windows Method

作　　者：薛永生[1] 林子雨[1] 段江娇[1] 吕晓华[1] 张伟[1] 

机构地区：[1]厦门大学计算机科学系,厦门361005

出　　处：《计算机研究与发展》2004年第10期1703-1711,共9页Journal of Computer Research and Development

基　　金：福建省自然科学基金项目 (A0 3 10 0 0 8);福建省高新技术研究开放计划重点项目 ( 2 0 0 3H0 43 )

摘　　要：多维视图动态维护是数据仓库领域当前研究的一个热点 随着数据仓库的普及 ,将有越来越多的各种类型的用户使用OLAP工具满足各自特定的分析需求 现有的各种视图选择方法没有考虑不同类型用户的特点 ,从而存在一些缺陷 提出多用户多窗口方法 ,充分考虑用户的差异 ,利用单个用户在查询时的相对有规律性 ,为用户划分级别 ,并为每个用户设置相应级别的用户视图窗口 ,从而合理地利用了系统有限的资源 ,提高了查询响应速度 ,也保证了特殊用户对查询性能的特殊需求 ;给出了相关的定义和MUMW算法 。Dynamic selection of materialized views of multi dimensional data is one of the most researched aspects in the field of data warehouse; With the increasing use of data warehouse, there will be accordingly more and more different kinds of users making use of OLAP tools to complete their analytical work; The existing methods being used to select views do not take into account the characteristic of various kinds of users, and therefore have some defects; A multi users and multi windows method is presented here, which considers the disparity among various users and makes use of the rule of the users' queries In the method, all users are divided into three groups with different grade and each user is accordingly endowed with user view window of certain grade Such method leads to the reasonable use of the limited space resource and also speeds up the response of query, which stipulates satisfying some special needs of certain user; Some related conceptions and MUMW algorithm are also put forward here, and at the same time, the advantages of this method are described

关 键 词：多用户多窗口 IVIUMW 实视图 OLAP 多维数据 数据仓库 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]