摘要
研究了通过对数据仓库视图进行水平分割来建立数据集市系统 ,提高OLAP查询效率的方法和技术 .提出了根据OLAP查询中的选择谓词构造其最小项谓词 ,选择数据仓库立方体视图进行水平分割 ,利用视图分割后的裂片建立的数据集市来回答查询 ,达到减少访问的视图元组数和加快查询响应时间 ,从而提高OLAP查询效率 。
The method and technology to improve the efficiency of the OLAP queries with data mart system by horizontally partitioning the data warehouse views are studied. A method is proposed for selecting and efficiently horizontally partitioning warehouse cube views based on the minterm predicates of selection predicates in OLAP queries. the queries can be answered with those data marts by these fragments of partitioned warehouse views to reduce the visited rows and query response time. The efficiency of the OLAP queries is also improved and the maintenance cost reduced.
出处
《东南大学学报（自然科学版）》
EI
CAS
CSCD
北大核心
2002年第6期875-878,共4页
Journal of Southeast University：Natural Science Edition
基金
江苏省"九五"重点攻关课题资助项目 (BG980 17-1)
江苏省"十五"高科技资助项目 (BG2 0 0 10 13)
