摘要
应用系统随着用户数和业务量的增长,数据规模会变得越来越大,数据仓库面临的存储压力和性能压力都与日俱增。为了满足业务系统发展的需要,数据仓库面临的主要问题就是如何持续的提升处理分析能力,仓库的物理拆分便成了一种首要的选择方案。针对不同的应用场景拟定合理的数据仓库分库策略显得越发重要,该文结合数据仓库建设项目中分库实施遇到的问题,对各种不同的分库策略和场景进行分析和探讨。
Along with the increasing of application system users and business growth,the data scale is getting larger and larger.The requirements of the storage capability and performance for the data warehouse is becoming higher and higher.Regarding the developing application system business,the foremost problem faced with the data warehouse is how to continuously improving the data analyzing ability.Under such a situation,the physical separation of the data warehouse is the principle solution.It is very important to set up a reasonable data warehouse separation strategy for different systems.Based on real project experiences of data warehouse separation,the paper analyzed several different data separation strategies and scenarios.
出处
《电脑知识与技术》
2012年第9X期6441-6443,共3页
Computer Knowledge and Technology
基金
南京财经大学科研基金项目资助(项目编号:G2010009)
关键词
数据仓库
物理拆分
分库策略
应用场景
data warehouse
physical separation
sub-warehouse strategy
scenarios
