数据仓库技术架构及方案.pptx

SPDBProjectTraining数据仓库技术架构及方案

AgendaTeradata简介架构设计原理整体架构说明ETL架构说明

Teradata公司概况TeradataCorporation–2007年10月1日纽交所上市企业级数据仓库全球领导者EDW/ADW数据库技术分析型解决方案咨询服务自1999年开始，连续9年被Gartner评为数据仓库第一名美国前10大上市软件公司SP500标准普尔500成员纽交所上市代码:“TDC”NYSEArcaTech100世界级的客户遍布全球超过850个世界级客户超过2000个安装系统全球员工超过5,500名

Teradata市场份额90%ofTop10GlobalTelcoFirms70%ofTop10GlobalAirlines60%oftheTop10TransportationLogisticFirms50%ofTop10GlobalRetailers40%ofTop10GlobalCommercialSavingsBanksFORTUNEGlobalRankings,July2006TeradataTop10LeadingindustriesBanking/FinancialServicesGovernmentInsuranceHealthcareManufacturingRetailTelecommunicationsTransportationLogisticsTravelWorldclasscustomerlistMorethan850customersMorethan2,000installationsGlobalpresenceOver100countries

Teradata驱动世界级企业的可持续发展RetailFinancialTravelAoyamaShojiCommunicationsInsuranceManufacturingPost

Teradata数据仓库技术的领导者TheMagicQuadrantiscopyrighted9/12/06byGartner,Inc.andisreusedwithpermission.TheMagicQuadrantisagraphicalrepresentationofamarketplaceatandforaspecifictimeperiod.ItdepictsGartnersanalysisofhowcertainvendorsmeasureagainstcriteriaforthatmarketplace,asdefinedbyGartner.Gartnerdoesnotendorseanyvendor,productorservicedepictedintheMagicQuadrant,anddoesnotadvisetechnologyuserstoselectonlythosevendorsplacedintheLeadersquadrant.TheMagicQuadrantisintendedsolelyasaresearchtool,andisnotmeanttobeaspecificguidetoaction.Gartnerdisclaimsallwarranties,expressorimplied,withrespecttothisresearch,includinganywarrantiesofmerchantabilityorfitnessforaparticularpurpose.GartnerMagicQuadrantforDataWarehouseDBMSServers,2006Feinberg,Hardcastle,Butler,Dawson(8/25/2006)GartnerMagicQuadrantforDataWarehouseDBMS,2006FeinbergBeyer(9/2006)软件硬件

Teradata系统扩展能力10TB15TBDataStorage(raw,userdata)20TBWorkloadMixQueryComplexityActiveDataWarehousing3-5Way