基于oraclerac的数据仓库系统的开发

《基于oraclerac的数据仓库系统的开发》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、JDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ淘宝数据仓库环境介绍陈吉平淘宝网首席DBA，资深技术专家OracleACE《搭建Oracle高可用环境》一书作者DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ淘宝介绍•淘宝网（www.taobao.com）是国内领先的个人交易网上平台

2、，由全球最佳B2B公司阿里巴巴公司投资4.5亿创办，致力于成就全球最大的个人交易网站。自2003年5月10日成立以来，淘宝网基于诚信为本的准则，从零做起，在短短的半年时间，迅速占领了国内个人交易市场的领先位置...DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJDFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHD

3、SKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ¾淘宝数据仓库的发展历史¾淘宝数据仓库的现状¾淘宝数据仓库的维护¾淘宝数据仓库的未来发展DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJDFSGSJDFKGHERUHJKDHKLSHDKJHKSHK

4、FHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ单机-DELL6650IBM-P5504节点RAC环境12节点RAC环境计划扩展到20节点DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ20042006200720

5、08DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ¾当时的可选方案zTeradata，在ebay有成功案例zOracleRac，对淘宝来说，技术比较成熟¾主要考虑的问题：z1.效率，是否能快速的满足日常需求z2．开放性，开放系统还是选择封闭系统z3.可扩展性，包括线性扩展能力，对外接口等z4.成本因素DFSGSJDFKGHERUHJKDHKLSH

6、DKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ¾OracleRAC优点zOracle是一个相对开放的系统，文档很多zTaobao本身对Oracle的技术比较了解z在实际的测试中，Oracle表现比较优越z可以做到线性的扩展能力z成本不会高于Teradata¾OracleRAC缺点z对技术的要求相对比较高，需要DBA深入的优化DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHL

7、KGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJ数据源ODS计算展示DFSGSJDFKGHERUHJKDHKLSHDKJHKSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJOracle4节点RACODS层12节点RAC计算层DFSGSJDFKGHERUHJKDHKLSHDKJH

8、KSHKFHLKGHDLSFGHDSKLFHGLDKSFHGLKFGDSJDFJKDHFKAHGJHLKFHJHAKHFLJKDHFKLJASHDFKJHAKLDFHDLSFHKLDSJRealTime同步