资源描述：
《数据仓库技术架构及方案.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、数据仓库技术架构及方案SPDBProjectTraining黄予辉2008年12月13日Agenda•Teradata简介•架构设计原理•整体架构说明•ETL架构说明Teradata公司概况•TeradataCorporation–2007年10月1日纽交所上市>企业级数据仓库全球领导者•EDW/ADW数据库技术•分析型解决方案•咨询服务>自1999年开始，连续9年被Gartner评为数据仓库第一名•美国前10大上市软件公司>S&P500标准普尔500成员>纽交所上市代码:“TDC”>NYSEArcaTech100•世界级的客户遍布全球>超过850个世界级客户>
2、超过2000个安装系统•全球员工超过5,500名Teradata市场份额TeradataTop10•Leadingindustries>Banking/FinancialServices90%ofTop10>GovernmentGlobalTelcoFirms>Insurance&Healthcare>Manufacturing70%ofTop10>RetailGlobalAirlines>Telecommunications>TransportationLogistics60%oftheTop10>TravelTransportation•Worldclass
3、customerlistLogisticFirms>Morethan850customers>Morethan2,00050%ofTop10installationsGlobalRetailers•Globalpresence40%ofTop10>Over100countriesGlobalCommercial&SavingsBanksFORTUNEGlobalRankings,July2006Teradata驱动世界级企业的可持续发展PostCommunicationsFinancialTravelRetailInsuranceManufacturingAoy
4、amaShojiTeradata数据仓库技术的领导者软件硬件GartnerMagicQuadrantforDataWarehouseGartnerMagicQuadrantforDataWarehouseDBMS,2006DBMSServers,2006Feinberg&Beyer(9/2006)Feinberg,Hardcastle,Butler,Dawson(8/25/2006)TheMagicQuadrantiscopyrighted9/12/06byGartner,Inc.andisreusedwithpermission.TheMagicQuadran
5、tisagraphicalrepresentationofamarketplaceatandforaspecifictimeperiod.ItdepictsGartner'sanalysisofhowcertainvendorsmeasureagainstcriteriaforthatmarketplace,asdefinedbyGartner.Gartnerdoesnotendorseanyvendor,productorservicedepictedintheMagicQuadrant,anddoesnotadvisetechnologyuserstosel
6、ectonlythosevendorsplacedinthe"Leaders"quadrant.TheMagicQuadrantisintendedsolelyasaresearchtool,andisnotmeanttobeaspecificguidetoaction.Gartnerdisclaimsallwarranties,expressorimplied,withrespecttothisresearch,includinganywarrantiesofmerchantabilityorfitnessforaparticularpurpose.Terad
7、ata系统扩展能力DataStorage(raw,userdata)20TBMultiple,IntegratedStarsandNormalized15TB1,000#ofDataModelNormalized10TBConcurrentSophisticationQueriesMultiple,IntegratedStars5TBSimpleStarBatchReporting,RepetitiveQueries3-5WayJoins“Iterative”,AdHocQueriesDataAnalysis/Mining5-10WayMB’s15+wayJoi
8、ns+JoinsNear
