期刊文献+

基于维层次的OLAP变粒度存储策略

A Hierarchy-Based OLAP Varied-Granularity Storage Strategy
下载PDF
导出
摘要 目前的决策支持体系结构中都是采用数据仓库来存储系统中的分析数据,应用OLAP技术实现系统中的分析功能。但是,数据量的增长也使得DataCube不断增大,因而影响到了OLAP的效率。本文提出了一种基于层次的OLAP变粒度存储策略,根据实际情况灵活地调整需要进行聚集的粒度与数据集,从而更好地满足数据分析的需要。 The current decision-support architectures all adopt data warehousing to store the analysis data in the system,and apply OLAP to realize the system analytical functions. The efficiency of OLAP is affected because of the growth of Data Cube. This article provides a hierarchy-based OLAP varied-granularity storage strategy. In Data Cube,the strategy adjusts the granularity and datasets to fit analysis more effectively.
作者 杨科华
出处 《计算机工程与科学》 CSCD 2007年第6期68-70,92,共4页 Computer Engineering & Science
关键词 维层次 联机分析处理 变粒度存储 hierarchy on-line analysis process varied granularity storage
  • 相关文献

参考文献10

  • 1Harinarayan V,Rajaraman A,UIIMan J D.Implementing Data Cubes Efficiently[A].Proc of ACM SIGMOD'96[C].1996.205-216.
  • 2Chun S J,Chung C W,Lee J H,et al.Dynamic Update Cube for Range-Sum Queries[A].Proc of the 27th VLDB Conf[C].2001.521-530.
  • 3Liang W,Wang H,Orlowska M E.Range Queries in Dynamic OLAP Data Cubes[J].Data and Knowledge Engineering,2000,34(1):21-38.
  • 4Li H G,Ling T W,Lee S Y.Range Sum Queries in Dynamic OLAP Data Cubes[A].Proc of the 3th Int'l Symp on Cooperative Database Systems for Advanced Applications[C].2001.74-81.
  • 5Ho C T,Agrawal R,Megiddo R,et al.Range Queries in OLAP Cubes[A].Proc of ACM SIGMOD '97[C].1997.73-88.
  • 6Geffner S,Agrawal D,Abbadi A,et al.Relative Prefix Sums:An Efficient Approach for Querying Dynamic OLAP Data Cubes[A].Proc of the 15th Int'l Conf on Data Engineering[C].1999.328-325.
  • 7李睿,王加阳,李超良.多维数据模型的变粒度存储策略研究[J].微机发展,2003,13(10):23-25. 被引量:2
  • 8Beyer K,RamaKrishnan R.Bottom-Up Computation of Sparse and Ice-Berg Cubes[A].Proc of ACM SIGMOD'99[C].1999.359-370.
  • 9O'Neil P,Quass D.Improved Query Performance with Variant Indexes[A].Proc of ACM SIGMOD Int'l Conf on Management of Data[C].1997.38-49.
  • 10Kemper A,Wiesner C.HyperQueries:Dynamic Distributed Query Processing on the Internet[R].Technical Report,Universitat Passau,Fakultat fur Mathematik und Informatik,2001.

二级参考文献9

  • 1Hafinarayan V, Rajaraman A, Ullman J D. Implementing Data Cubes Efficiently[J]. SIGMOD, 1996, 25(2) : 205 -216.
  • 2Baralis E, Paralmschi S, Teniente E. Materialized view selection in a multidimensional database[A]. In: Proceedings of the 23rd VLDB Conference[C]. Athens, Greece: [s. n. ],1997. 156- 165.
  • 3Zaharioudakis M, Cochrane R, Lapis G, et al. Answering Complex SOL Queries Using Automatic Sunmmary, Tables[ J ].SIGMOD, 2000, 29(2). 105 - 116.
  • 4Mumiek I, Quass D, Mumick B. Maintenance of Data Cubes and Summary Tables in a Warehouse[J]. SIGMOD, 1997,26(2): 100- 111.
  • 5Chen Y, Dong G, Hart J, et al. Online Analytical Processing Stream Data: Is It Feasible? [A]. In: Proc 2002 ACM-SIGMOD Int Workshop on Research Issues on Data Mining and Knowledge Discovery (DMKD'02)[C]. Madison, Wisconsin, USA: [s. n. ], 2002.
  • 6Tansel A, Clifford J. Temporal Database Theory, Design and Implementation[M]. Redwccxt, CA: Benjamin/Camanings Publishing Company, 1993. 418-455.
  • 7Codd E F, Codd S B, Salley C T. Beyond decision support[J].Computer World, 1993, 27(30): 87- 89.
  • 8王腾蛟,王海洋,洪晓光,董继润.多物化视图并行增量保持三阶段模式[J].软件学报,1999,10(11):1138-1141. 被引量:2
  • 9李建中,hlju.edu.cn,高宏.一种数据仓库的多维数据模型[J].软件学报,2000,11(7):908-917. 被引量:75

共引文献1

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部