期刊文献+

星型模型在复杂数据仓库环境中应用研究

Application Research of the Star Model in the Complex Data Warehouse Environment
下载PDF
导出
摘要 针对数据仓库中分散数据的整合问题,本文基于商用BI工具COGNOS对星型结构数据模型进行优化,创建底层模型和数据立方体。运行结果显示,数据模型易于整合分散事实数据,性能优越。 As to the integration of the scattered data in data warehouse, in this paper, we optimized the model of star structure, and create the underlying model and data cube based on the commercial BI tool COGNOS. The running results show that the data model is easy to integrate the dispersed data, and the performance is superior.
出处 《价值工程》 2015年第31期77-79,共3页 Value Engineering
基金 中国石油天然气集团公司十二规划项目(名称:中国石油节能节水管理信息系统项目)
关键词 星型模型 数据整合 位图索引 计算量 数据仓库 Star Model data integration bitmap index computational quantity data warehouse
  • 相关文献

参考文献4

二级参考文献15

  • 1高亮.高校数据仓库建设研究[J].武汉大学学报(理学版),2012,58(S1):179-184. 被引量:7
  • 2罗永辉,陈明亮.商业智能哲学思索——BI框架体系的另一种视角[J].软件世界,2007(7):68-71. 被引量:1
  • 3Jensen C, Pedersen T, Thomsen C. Multidimensional databases and dsata warehousing [M/OL]. San Rafael: Morgan & Claypool Publishers, 2010: 1-6, 73-75. [2011- 06-20]. http://www. Morganelaypool. com/ doi/abs/10. 2200/ S00299ED1V01 Y201009DTM009.
  • 4TPC. TPC-H Benchmark standard specification, Version 2.14.2 [S/OL]. San Francisco: Transaction Processing Performance Council, 2011. [2011-06-20 ]. http://www. tpc. org/tpch.
  • 5TPC. TPC-DS Benchmark, Version 1. 0. 0d [S/OL]. San Francisco: Transaction Processing Performance Council, 2007. [2011-06-20]. http://www, tpe. org/ tpcds/tpcds, asp.
  • 6Vassiliadis P, Sellis T. A survey on logical models for OLAP database[J]. ACM SIGMOD Record, 1999, 28(4): 64-69.
  • 7APB-1 OLAP Benchmark, Release II [S/OL]. OLAP Council, 1998. [2011-06-20]. http://www, olapcouncil, org/ research/resrchly, htm.
  • 8Bischoff J, Alexander T. Data watehouse: Practical advice from the experts [M]. Upper Saddle River, New Jersey: Prentice Hall, 1997: 199-205.
  • 9Colliat G, OLAP, Relational, and Multidimensional DataBase System [J]. ACM SIGMOD Record, 1996, 25(3) 64-69.
  • 10Dittrich J P, Kossmann D, Kreutz A. Bridging the Gap between OLAP and SQL [C] //Proc of the 31st Int Conf on Very Large Data Bases. New York: ACM, 2005:1031-1042.

共引文献16

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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