1946 年——我们到达了吗？数据重构之旅.pdf

1、Are We There Yet?The Data Refactoring Journey 1946A Premier IBM Business PartnerAgenda2IntroductionCase StudiesA Tale of Two IMS ICDC ImplementationsKafka digressionReplatforming for GrowthSimpler is BetterTwo Birds,One StoneRoadmaps and ResourcesSummary and QuestionsIntroduction The Fillmore Group,

2、Inc.Founded in the US in Maryland,1987IBM Business Partner since 1989Delivering IBM authorized education since 1994IBM Gold Consultants since 1998IBM Champions since 20093A Tale of Two CDC for IMS Implementations4OrientationIBM Information Management System(IMS)Hierarchical database developed in the

3、 1960sSeries of internal pointers to link“Segments”of a“Record”Record:Insured or PatientSegment:Office visit,Diagnostic,Co-payApplications typically coded in COBOLChallengesEBCDIC:not Unicode or ASCII;collating sequence differenceWeak datatyping:REDEFINES,invalid numerics,datesVariable record format

4、:OCCURS DEPENDING ON(ODO)A Tale of Two CDC for IMS(contd)5SolutionIBM InfoSphere Change Data Capture(CDC)Heterogeneous replication Source and Target are differentInfoSphere Data Replication for IMS for z/OSIBM Data Replication IMS for z/OS Remote SourceSimplifying the job of working with IMS dataRed

5、ucing the requirement for mainframe skillsMoving the CPU-intensive processing off z/OS to Linuxz/OSLinuxNon-z CDC TargetPlatformIMS for z/OS SourceIMSLogsAddress SpaceDocker containerIMS z/OS RemoteSource Process+CDC CaptureEngineIDR/IIDRCDCTargetEngineTCP/IP IMS for z/OS CDC Remote SourceIMSDBTCP/I

6、P 7CDC SourcesCDC Target databases and middleware applicationsIBM Db2 for Linux,UNIX and Windows(LUW)IBM Db2 for iIBM Db2 for z/OSIMSMicrosoft SQL ServerOracleSybaseInformixDb2 on CloudVSAMPostgreSQLDb2 Warehouse on CloudDb2 WarehouseMySQLIBM Db2 for Linux,UNIX and Windows(LUW)IBM Db2 for iIBM Db2 f