GoldenGate产品简介2

产品介绍阮蓉高级咨询顾问概要•GoldenGate公司简介•GoldenGate原理•GoldenGate主要应用•成功案例•GoldenGate相关产品GoldenGate公司简介•创建于1995年，总部在美国旧金山。•数据复制领域的专业公司。•全球超过4,000个安装许可，分布在政府、银行、制造、传媒、电信、证券、医疗和零售等各大行业，其中有多个全球财富500强企业。•与Oracle、IBM、HP、Microsoft、Sybase、Teradata等著名企业建立了紧密合作关系。•2009年被Oracle收购。AutoZoneBostonConsultingGroupCendant/TravelportDukeEnergyFederalAviationAdministrationFiservSolutionsGenuineAutoPartsCompanyHertzMGMGrandOfficeofMilitaryManpowerAdmin.OrbitzOverstock.comPartyCityPublixSuperMarketsAlliedIrishBanksANZBankBancaSellaBancodeCreditoeInversion(BCI)BancoInternacional,S.A.-BITALBancoNacionaldeMexicoBancoPopulardePuertoRicoBancoSantanderMexicanoBankGospodarkiZywnosciowejBankMandiriBankNegaraBankofAmerica（美国银行）BankofCentralAsiaBankofNovaScotiaBankUTIBankartd.o.o.BiKBoricaChinaTrustCommercialBankCitigroupOTPBankPKOBankPolskiPostbankRabobankShanghaiCommercial&SavingsSiamCityBankStateBankofIndiaStateBankofMauritiusTaitungBusinessBankTorontoDominionBankTransbankS.A.TwinsoftforDeutscheBahnUlsterBankU.S.BankUnibancoWachoviaWashingtonMutualBankWellsFargoWorldSavingsZionsBankCorporationComericaCommercialBankofGreeceConsorzioTrivenetoSpaEmiratesBankInternationalEurobankFleetFinancialServicesFSPAFoereningssparbankenHDFCBankHSBC（汇丰银行）HsinChuBank(HCBank)HuntingtonServicesCorp.ICBBankINGPostbankJPMorganChaseKasaiornBankKnetKoreanExchangeBankMuzoNationalAustraliaGroupNationalBankOfGreeceAllscriptsAntelopeValleyHospitalBaptistHealthBronxLebanonContinuumHealthPartnersGroupHealthCooperativeHealthAllianceofCincinnatiHuntsvilleHospitalINOVAHealthSystemsIowaHealthSystemKetteringMedicalCenterLegacyHealthSystemMayoClinicFoundationMontefioreMedicalCenterNebraskaHealthSystemsNorthCarolinaBaptistHealthOakwoodHealthcareSystemsOSFHealthcareParkNicolletHealthServicesParkviewHealthSystemsPeaceHealthSchering-PloughSharpHealthcareStanfordMedicalSt.FrancisHospitalSt.Joseph'sHospitalThomasJeffersonUniversityUniversityofChicagoHospitalsUniversityofCalif-SanFranPreHoldings(ITCFinancial)PromisantPulseEFTRetailDecisionsRaymondJamesRegionsykehusetiTromsoeSamsungCardSamsungSecuritiesSamsungWinnersSpeedwaySuperamericaT-ChekSystemsTotalSystemsTravelersExpressUBSVISAWesternUnionWooriSecuritiesABN-AMROADPAffinitas(Consortia)Alliance&LeicesterAssurantInc.ATHCostaRicaAustrianPaymentSystemsBankservBolsadeValoresdeColumbiaBombayStockExchangeBursatec(MexicanStockExchange)CapitalSecuritiesCashCardCEKABCertegyCIBCComdataFederatedInvestorsFidelityInformationServicesFirstDataCorp.FirstDataSlovakiaFirstTennesseeGirobankardHyundaiITSIncJCBInternationalCo.JihSunSecuritiesKeyCorpKookminCreditLGCard(LGC)Link-UKMarketAxessCorporationMasterLinkSecuritiesMerrillLynchNationalCreditCardCenterNationalProcessingCompanyPayPointPaybyTouchPolarisPolcardAdelphiaCableAMDBellSouthCableOneCablevisionSystemsCorp.CingularWirelessComcastCommunicationsInc.CopperweldContinentalDatagraphicsDellUSADirecTVEmergisInc.GentronicsHyundaiMotorAmericaPostiniProcompSingaporeComputerSystemsSIS/ADPSprintSyscomT-ComTexasElectronicInformationComp.TokyoInformationSystemsWestCorpWestconRossRoyalInstit.CharteredSurveyorsSabreHoldingsSafewaySandiaNationalLabs–U.S.DoEShellOil–EquivaServicesSouthwest.comStateofPennsylvaniaU.S.AirForceU.S.DepartmentofDefenseUSFoodserviceValeroEnergyCorporationWal-martMexico客户列表（按照行业划分）BankingFinancialandInsuranceServicesHealthcareCable,Telco,andManufacturingeBusiness,Retail,Public/Govt.,Services概要•GoldenGate公司简介•GoldenGate原理•GoldenGate主要应用•成功案例•GoldenGate相关产品GoldenGateTDM（交易数据管理）软件是一种基于日志的结构化数据复制软件，它通过解析源数据库在线日志或归档日志获得数据的增删改变化，再将这些变化应用到目标数据库，实现源数据库与目标数据库同步、双活。GoldenGateTDM软件可以在异构的IT基础结构（包括几乎所有常用操作系统平台和数据库平台）之间实现大量数据亚秒一级的实时复制GoldenGateGoldenGate工作原理网络源数据库目的数据库双向复制队列文件:暂存数据变化.传输:数据经过压缩和加密传送到目的地.Capture:实时读取交易日志捕捉数据变化并可实现过滤.Delivery:执行所需的数据变化，然后将数据变化提交到目的库.CaptureSourceTrailTargetTrailSourceTrailTargetTrailDeliveryDeliveryCapture交易数据管理GoldenGate提供异构环境下交易数据的实时捕捉、变换、投递。特性:实时性秒一级延迟异构环境支持在不同平台和数据库环境下复制数据以交易为单位复制维护交易一致性收益:高性能能够以低资源消耗完成每秒数千交易的复制可扩展开放的结构使客户适应各种异构数据平台可靠保证数据的连续可用GoldenGate的工作特点•实时数据复制•支持异构环境•可靠性：断点续传，不影响系统连续运行。•高性能，对生产系统影响小•事务完整性•整合：ETLtools,MessageService•灵活拓扑结构•复制冲突检测和解决•事件标记基础架构(Eventmarkerinfrastructure)•路由和压缩：TCP/IP，LAN，WAN•加密：128-位，SSL•自定义延时应用修改•根据事务大小和数量自动管理内存基于日志的实时数据复制•亚秒级复制•不依赖源数据库的触发器和规则，对源数据库影响小。数据库日志网络CaptureSourceTrailTargetTrailDeliveryDataPumpJMSMessageBusGoldenGate支持异构环境任意组合DatabasesO/SandPlatformsCapture:􀂃Oracle􀂃DB2􀂃Ingres􀂃MicrosoftSQLServer􀂃SybaseASE􀂃Teradata􀂃􀂃Enscribe􀂃SQL/MP􀂃SQL/MXDelivery:􀂃Alllistedabove,􀂃MySQL,Netezza,Greenplum,􀂃HPNeoview􀂃AndanyODBCcompatibleDBsWindows2000,2003,XPLinuxSunSolarisHPNonStopHP-UXHPTRU64HPOpenVMSIBMAIXIBMz/OSGoldenGate10.4支持的主流数据库版本•Oracle8i(DMLonly)•Oracle9.1and9.2(DMLandDDL)•Oracle10.1and10.2(DMLandDDL)•Oracle11g(DMLandDDL)•DB2UDB8.xand9.5onWindowsandUNIX•DB2UDBforOS/390andz/OS7.1(untilIBMendofservicedate)•DB2UDBforz/OSVersion8.1and9.1•SQLServer2000and2005onMS-supportedOSasasourceortarget.•SQLServer2008onMS-supportedOSasatargetonly.•Sybase12.5.4and15ASE•MySQLversions4.0and4.1灵活的拓扑结构单向复制备份、查询双向复制灾备、双业务中心点对点多业务中心广播复制数