信息集成技術(shù)及應(yīng)用

1、IBM Software Group 2003 IBM CorporationInformation Management Software信息集成技術(shù)及應(yīng)用IBM信息集成架構(gòu)王光宇王光3596010-65391188-3596IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation今天的業(yè)務(wù)集成挑戰(zhàn)基礎(chǔ)架構(gòu)投資缺乏連貫性為新的業(yè)務(wù)單位提供無(wú)縫集成聯(lián)接封裝的應(yīng)用

2、和遺留系統(tǒng)管理各種不同系統(tǒng)的成本越來(lái)越高集成異構(gòu)的“孤島”系統(tǒng)減輕人員和技能的缺乏問(wèn)題行業(yè)和政府的監(jiān)管增強(qiáng) 行業(yè)標(biāo)準(zhǔn) 政府監(jiān)管. 高效提供新的服務(wù)和應(yīng)用 支持新的標(biāo)準(zhǔn)維護(hù)系統(tǒng)和資產(chǎn)安全集成項(xiàng)目花費(fèi)的時(shí)間太長(zhǎng)，成本太高集成項(xiàng)目花費(fèi)的時(shí)間太長(zhǎng)，成本太高業(yè)務(wù)成功的關(guān)鍵在于盡快提供價(jià)值（業(yè)務(wù)成功的關(guān)鍵在于盡快提供價(jià)值（Time to Value)速度速度+成本成本+風(fēng)險(xiǎn)風(fēng)險(xiǎn)IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003

3、 IBM Corporation流程建模 應(yīng)用整合對(duì)外接口流程監(jiān)控管理業(yè)務(wù)結(jié)果應(yīng)用訪問(wèn)標(biāo)準(zhǔn)化動(dòng)態(tài)適應(yīng)工作環(huán)境支持任何時(shí)間,任何地點(diǎn)的訪問(wèn)有效利用數(shù)據(jù)及內(nèi)有效利用數(shù)據(jù)及內(nèi)容資源容資源分布式數(shù)據(jù)訪問(wèn)分布式數(shù)據(jù)訪問(wèn)數(shù)據(jù)集中數(shù)據(jù)集中數(shù)據(jù)轉(zhuǎn)換數(shù)據(jù)轉(zhuǎn)換管理數(shù)據(jù)分布管理數(shù)據(jù)分布集成: 關(guān)鍵能力需求PeopleProcessesInformation+安全性和完整性IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Cor

4、porationLegacyApps信息信息集成集成流程集成用戶交互消費(fèi)者消費(fèi)者貿(mào)易伙伴貿(mào)易伙伴服務(wù)供應(yīng)商服務(wù)供應(yīng)商供應(yīng)商供應(yīng)商B2B PortalB2C Site價(jià)值鏈價(jià)值鏈異構(gòu)環(huán)境異構(gòu)環(huán)境新電子商務(wù)新電子商務(wù)應(yīng)用應(yīng)用供應(yīng)鏈管理供應(yīng)鏈管理客戶關(guān)系客戶關(guān)系管理管理服務(wù)供應(yīng)商集成到服務(wù)供應(yīng)商集成到ERP和和HR系統(tǒng)系統(tǒng)產(chǎn)品研發(fā)管理產(chǎn)品研發(fā)管理應(yīng)用應(yīng)用聯(lián)接聯(lián)接Build to Integrate需要不同類型的集成IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Softwar

5、e | February 2003 2003 IBM Corporation如果沒(méi)有統(tǒng)一的信息整合DB2OracleSQLServerExcelspreadsheetXMLdocumentInternetSSLclientapplicationsBrowsersData managementlayerApplicationlayerWebserversIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Co

6、rporationIBM信息集成藍(lán)圖AccessAccessFoundationFoundationFeaturesFeaturesXMLXMLSQLSQLWeb ServicesWeb ServicesStore Search Federate Cache Transform ReplicateStore Search Federate Cache Transform ReplicateScalableScalableManageableManageableAvailableAvailableDB2, Informix,Oracle, MicrosoftDocumentsRich Media

7、XMLApplicationsWeb-based應(yīng)用應(yīng)用集成企業(yè)內(nèi)外的各種業(yè)務(wù)信息集成企業(yè)內(nèi)外的各種業(yè)務(wù)信息IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation數(shù)據(jù)聯(lián)邦透明對(duì)應(yīng)用而言，所有數(shù)據(jù)如同在同一數(shù)據(jù)庫(kù)中。異構(gòu)集成各類數(shù)據(jù)源的數(shù)據(jù)包括關(guān)系型數(shù)據(jù),結(jié)構(gòu)化數(shù)據(jù), XML, 消息隊(duì)列, Web, 等可擴(kuò)展聯(lián)邦技術(shù)幾乎可擴(kuò)展到所有數(shù)據(jù)源.基于開(kāi)放式的Wrapper框架，提供Wrapper

8、開(kāi)發(fā)接口和工具自治幾乎對(duì)原有系統(tǒng)應(yīng)用沒(méi)有影響,無(wú)需在原有系統(tǒng)上安裝程序,軟件, 無(wú)需特有的接口.性能優(yōu)化分布式的查詢性能優(yōu)化.提供數(shù)據(jù)cache能力.IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationDB2 IIOracle ClientOracleSQL性能比較IBM Software Group | DB2 Information Management SoftwareIBM D

9、B2 Information Integrator Software | February 2003 2003 IBM CorporationIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation縱向系統(tǒng)間信息架構(gòu)的挑戰(zhàn)XMLdocument?Program?Program?Program分支機(jī)構(gòu)內(nèi)網(wǎng)?Program?Program?Program分支機(jī)構(gòu)?Program?Program

10、?Program分支機(jī)構(gòu)Internet電話數(shù)據(jù)分層分布統(tǒng)一的服務(wù)需求數(shù)據(jù)集中的迫切需求數(shù)據(jù)集中的迫切需求結(jié)構(gòu)性的矛盾結(jié)構(gòu)性的矛盾以客戶為中心以客戶為中心統(tǒng)一服務(wù)統(tǒng)一服務(wù)統(tǒng)一管理統(tǒng)一管理總部IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationSource: Gartner Group?Program?Program?Program?Program?Program?Program?Pro

11、gram?Program?ProgramLoadProgramExtractProgramExtractProgramLoadProgramExtractProgramLoadProgramScreenScrapeDatabase ReplicatorDownloadFileDownloadFileTransactionFileMessageQueueDownloadFileTransactionFileMessageQueueApplicationSystem BApplicationSystem AApplicationSystem CFrom This.同類信息分布在不同的應(yīng)用系統(tǒng)To

12、This.?Purchased Application Package?Legacy Application SystemNew ApplicationDomain?Program?Program?ProgramService?Program?Program?ProgramMessageBrokerServiceRequesterRequester建立單個(gè)業(yè)務(wù)主題的ODS橫向系統(tǒng)間的信息整合的需求IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | Fe

13、bruary 2003 2003 IBM CorporationBusiness data warehouseOperational systemsData martsMetadataBusiness data warehouseOperational systemsData martsOperational data storeMetadata第一代第二代數(shù)據(jù)倉(cāng)庫(kù)的發(fā)展IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2

14、003 IBM CorporationBusiness data warehouseOperational systems(Operational) data martsInformation integrationMetadataUntrusted & unstructured sources (e.g. Internet)從客戶信息整合到完全信息集成Business data warehouseOperational systems(Operational) data martsClient info. integrationMetadataIBM Software Group |

15、 DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation傳統(tǒng)數(shù)據(jù)交換方式文件文件文件ftp文件文件文件文件文件ftp文件文件文件文件ftpIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationDB2 IIDB2 famil

16、yOracleSybaseInformixSQL ServerIMSDB2 II簡(jiǎn)化數(shù)據(jù)遷移Cross Loader高速數(shù)據(jù)跨庫(kù)加載數(shù)據(jù)源由SQL定義,提供靈活性數(shù)據(jù)無(wú)需中間緩存在目標(biāo)端數(shù)據(jù)加載可不記日志實(shí)測(cè)速度可達(dá)50GB/小時(shí)Cross LoaderSQLSQL結(jié)果集IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationDB2 II異構(gòu)數(shù)據(jù)復(fù)制異構(gòu)數(shù)據(jù)復(fù)制增量數(shù)據(jù)的識(shí)別增量數(shù)據(jù)的遷移

17、復(fù)制流程的管理和監(jiān)控IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationDB2 II進(jìn)入山東地稅山東地稅率先推行省級(jí)發(fā)票數(shù)據(jù)集中式地稅發(fā)票改革方案 DB2 II 擊敗Oracle和BEA成為山東地稅全省的信息集成基礎(chǔ)平臺(tái)項(xiàng)目第一階段順利完成兩個(gè)月集成市縣兩級(jí)約200個(gè)數(shù)據(jù)庫(kù)解決了數(shù)據(jù)庫(kù)異構(gòu)，版本差異大等多方面的問(wèn)題完成了部分?jǐn)?shù)據(jù)的省級(jí)集中取代Oracle，進(jìn)一步成為OLTP業(yè)務(wù)的數(shù)據(jù)庫(kù)

18、平臺(tái)IBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation山東地稅信息整合前數(shù)據(jù)架構(gòu)Sybase市中心縣征管系統(tǒng)OracleIntranetOracleSQLServerSQLServerSQLServerIntranet2M省中心SQLServerSQLServerSQLServerIntranet2MSQLServerSQLServerSQLServerIntranet2MSQLSe

19、rverSQLServerSQLServerIntranet2MIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM CorporationWrapper信息整合平臺(tái) (DB2 II P650)山東地稅信息整合架構(gòu)發(fā)票數(shù)據(jù)發(fā)票數(shù)據(jù)(DB2)SQLServerSybase應(yīng)用服務(wù)平臺(tái)SQLXMLWeb Services發(fā)票布獎(jiǎng)發(fā)票布獎(jiǎng)發(fā)票稅控發(fā)票稅控 發(fā)票管理發(fā)票管理對(duì)外服務(wù)對(duì)外服務(wù)省中心各地市征管系統(tǒng)(100

20、+ SQL Server, 10+ Sybase)OracleIntranetSQLServerSQLServerSybase2MWrapperIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation原有泰康信息架構(gòu)團(tuán)險(xiǎn)，銀險(xiǎn)團(tuán)險(xiǎn)，銀險(xiǎn)Informix個(gè)險(xiǎn)個(gè)險(xiǎn)AS400財(cái)務(wù)財(cái)務(wù)Oracle文件文件總公司總公司泰康在線泰康在線Broker 服務(wù)服務(wù)Call CenterOA綜合服務(wù)綜合服務(wù)銀

21、行接口銀行接口中間業(yè)務(wù)中間業(yè)務(wù)每日下發(fā)數(shù)據(jù)SQLServerCall Center業(yè)務(wù)分析業(yè)務(wù)分析分公司SQLServerCall Center業(yè)務(wù)分析業(yè)務(wù)分析分公司單項(xiàng)業(yè)務(wù)數(shù)據(jù)集中單項(xiàng)業(yè)務(wù)數(shù)據(jù)集中28家分公司家分公司SQLServerIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation泰康信息整合規(guī)劃團(tuán)險(xiǎn)，銀險(xiǎn)團(tuán)險(xiǎn)，銀險(xiǎn)Informix個(gè)險(xiǎn)個(gè)險(xiǎn)AS400財(cái)務(wù)財(cái)務(wù)Oracle總公司總公

22、司泰康在線泰康在線Broker 服務(wù)服務(wù)Call CenterOA綜合服務(wù)綜合服務(wù)銀行接口銀行接口中間業(yè)務(wù)中間業(yè)務(wù)單項(xiàng)業(yè)務(wù)數(shù)據(jù)集中單項(xiàng)業(yè)務(wù)數(shù)據(jù)集中分公司分公司CRM分析應(yīng)用分析應(yīng)用分析應(yīng)用分析應(yīng)用新應(yīng)用新應(yīng)用映射層信息整合層數(shù)據(jù)服務(wù)層信息整合平臺(tái)DB2 II應(yīng)用服務(wù)平臺(tái)(組件化) WASSQLXMLWeb Services分公司數(shù)據(jù)服務(wù)SQLServerMQIBM Software Group | DB2 Information Management SoftwareIBM DB2 Information Integrator Software | February 2003 2003 IBM Corporation市縣業(yè)務(wù)系統(tǒng)市縣業(yè)務(wù)系統(tǒng)60+ Oracle省公司信息省公司信息集成平臺(tái)集成平臺(tái)應(yīng)用應(yīng)用WAS, Brio服務(wù)門戶服務(wù)門戶WPS映射層(nicknames)信息整合層數(shù)據(jù)服務(wù)層DWcacheXMLSQL黑龍江電力信息整合架構(gòu)OracleDBOracleDBOracleDBOracleDBDB營(yíng)銷綜合指標(biāo)營(yíng)銷綜合指標(biāo) 實(shí)時(shí)業(yè)務(wù)監(jiān)控實(shí)時(shí)業(yè)務(wù)監(jiān)控營(yíng)業(yè)日管理營(yíng)業(yè)日管理 專題分析