期刊文献+

数据仓库的可扩展性研究与设计 被引量:2

Research and Design on Scalability of Data Warehouse
下载PDF
导出
摘要 随着海量异构的数据不断进入数据仓库和系统用户的大量增加,在数据质量、可用性和查询等方面的因素将严重影响数据仓库的性能,所以数据仓库必须设计成可扩展的体系结构。文中采用可扩展的软件并行和硬件并行相结合的方法进行数据仓库的性能扩展,在数据仓库初建时采用SMP结构,当数据仓库增长到一定的时候采用高速缓存相关的非一致性内存访问结构,并且较好地利用I/O并行性,取得较好效果。使得当大量异构数据涌入可扩展数据仓库中时系统性能不会下降,很好地满足决策支持。 Along with mass heterogeneous data and system users getting into data warehouse, its performance begins to decline on data quality, usability and query aspects, thus data warehouse should be designed with scalable architecture. Sealable software and hardware technologies are used to extend test data warehouse in this paper, and in the beginning SMP is used in data warehouse. CC - NUMA is employed for extending data warehouse when it increases to a certain scale that SMP can not satisfy system performance need, and at the same time I/O parallel is used fully. In this case, a good effect on system performance is obtained when a great deal of heterogeneous data swarming into data warehouse, and meets the needs of decision support better.
作者 秦学勇 刘栋
出处 《计算机技术与发展》 2009年第5期65-67,71,共4页 Computer Technology and Development
基金 安徽省自然科学基金项目(2006KJ066B)
关键词 可扩展性 数据仓库 并行 NUMA scalability data warehouse parallel NUMA
  • 相关文献

参考文献8

  • 1STRUM J.Microsoft SQL Server7数据仓库技术指南[M].北京:机械工业出版社,2000:23-54.
  • 2秦学勇,姚燕生.可扩展数据仓库若干关键问题研究与分析[J].计算机技术与发展,2006,16(12):136-138. 被引量:4
  • 3Inmon W H. Building the Data Warehouse[ M].王志海,等译.北京:机械工业出版社,2000.
  • 4Widom J. Research Problems in Data Warehousing [ C ]//In Proceedings of the 4th Int'l Conference oil Information and Knowledge Management ( CIKM ). Baltimore, Maryland, USA: [s. n. ], 1995.
  • 5Tamura T, Nakamura M, Kitsuregawa M, et al. Imploementation and performance evaluation of the parallel relational database server SDC-Ⅱ[ C]//In Proceedings of International Conference on Parallel Processing. Ithaca, NY, USA: [ s. n. ], 1996:212 - 221.
  • 6Inmon W H, Rudin K, Buss C K, et al. 数据仓库管理[M].王天佑,等泽.北京:电子工业出版社,2000.
  • 7Shapiro JR.SQL SERVER 2000参考大全[M].北京:清华大学出版社,2002.
  • 8吴少刚,章隆兵,蔡飞,顾丽红,唐志敏.机群Open MP系统的设计与实现[J].计算机学报,2004,27(7):904-912. 被引量:8

二级参考文献8

  • 1InmonWH.Building the data warehouse[M].北京:机械工业出版社,2000..
  • 2InmonWH RudinK BussCK 王天佑译.数据仓库管理[M].北京:电子工业出版社,2000..
  • 3Strum J.Microsoft SQL Server7数据仓库技术指南[M].刘汉宇等译.北京:机械工业出版社,2000.
  • 4Bergamaschi S,Castano S,Vincini M.Semantic Integration of Semistructured and Structured Data Sources[J].SIGMOD Record,1999,28 (1):54-59.
  • 5Bitton D,Dewitt D J.Duplicate Record Elimination in Large Data Files[J].ACM Transactions on Database Systems,1983,8(2):255-265.
  • 6Kukich K.Techniques for Automatically Correcting Words in Text[J].ACM Computing Surveys,1992,24(4):377-:39.
  • 7Chan C Y,Ioannidis Y E.Bitmap Index Design and Evaluation[R].Computer Sciences Dept.,University of Wisconsin -Madison,1997.
  • 8胡伟武,施巍松,唐志敏.基于新型Cache一致性协议的共享虚拟存储系统[J].计算机学报,1999,22(5):467-475. 被引量:15

共引文献14

同被引文献20

引证文献2

二级引证文献8

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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