期刊文献+

多维关系数据库的应用研究 被引量:2

RESEARCH ON APPLICATION OF MULTIDIMENSIONAL RELATION DATABASE
下载PDF
导出
摘要 针对传统的关系数据库技术在处理海量数据事务上存在的处理速度慢和存储冗余量大的问题,结合支持决策分析的数据仓库的多维思想,提出了一种多维关系数据库模型。对新旧模型从时间复杂度和空间复杂度两个方面分别进行了理论推导,证实了新的多维关系数据库模型较传统的关系模型在时间和空间上都有了很大的提高,并用实验对该理论结果进行了验证,证明了新模型的可行性和优越性。 To solve the problem of slow processing speed and great redundancy of traditional relation database in handling mass data, based on multidimensional thought of data warehouse supporting decision analysis, a multidimensional relation database model is put forward. The time complications and space complications of the two models are deduced, and the experimental result shows that the multidimensional relation database model is better than the traditional relation model. The feasibility and superiority of the new model is proved.
出处 《计算机应用与软件》 CSCD 北大核心 2008年第11期151-153,共3页 Computer Applications and Software
关键词 关系数据库 多维关系数据库 OLAP 数据仓库 Relation database Multidimensional relation database OLAP Data warehouse
  • 相关文献

参考文献5

二级参考文献29

  • 1RosenKH 袁崇义译.离散数学及其应用[M].北京:机械工业出版社,2002..
  • 2[1]J Gray,A Bosworth,A layman et al. Data Cube:A Relational Aggregation Operator Generalizing Group-By,Cross-Tab,and Sub-Totals[C].In:Proc of the 12th iht.cour. on Data Engg, 1996:152~159
  • 3[2]P J Haas,J F Nanghton,S Seshadri et al. Selectivity and Cost Estimation for Joins Based on Random Sampling[R].IBM Research Report RJ9577,IBM Almaden Research Centre,San Jose,Califomia,1993
  • 4[3]P J Haas,J F Naughton,S Seshadri.Sampling-Based Estimation of the Number of Distinct Values of an Attribute[C].In:Proc of the 21st Int VLDB Conf, 1995:311~322
  • 5[4]P Flajolet,G N Martin. Probabilistic Counting Algorithms for Database Applications[J].Journal of computer and System Sciences, 1985;31 (2): 182~209
  • 6[5]Elena Baralis,Stefano Paraboschi, Ernest Teniente. Materialized View Selection in a Multidimensional Database,D[C].In:Proeeedings of the 23rd VLDB conference Athens,Greece,1997
  • 7晓通网络数据库研究所.Sybase开发应用系统及相关的性能问题[M].内蒙古人民出版社,1998..
  • 8Michael Reilly, Michelle Poolet. SOL Server 2000 Design & T - SOL Programming Copyright @ 2001 by The McGraw-Hill Companies Inc.2001.
  • 9Michael Reilly, Michelle Poolet. SOL Server 2000 Design & T - SQL Programming Copyright @ 2001 by The McGraw-Hill Companies Inc.2001.
  • 10Lehner W.Modeling large scale OLAP scenarios.In:Schek Hans-Jorg,Saltor Fèlix,Ramos Isidro,Alonso Gustavo eds.Proceedings of the 6th International Conference on Extending Database Technology.Lecture Notes in Computer Science1377.Valencia,Spain:Springer,1998,23~27

共引文献26

同被引文献6

  • 1李盛恩,王珊.多维数据模型ER(■)[J].计算机学报,2005,28(12):2059-2067. 被引量:10
  • 2潘东静 王付山 赵华龙.OLAP技术研究及应用.数据库及信息管理,2007,(2):625-625.
  • 3徐俊杰,严厉,王琳.武警财务信息化建设研究[M].北京:人民武警出版社,2008:192-196.
  • 4程晓红.决策支持系统理论及运用[M].北京:清华大学出版社,2000.
  • 5严蔚敏 吴伟民.数据结构[M].北京:清华大学出版社,1997..
  • 6雷启明.关系型联机分析处理(ROLAP)应用研究[J].中国科技信息,2008(18):103-104. 被引量:3

引证文献2

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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