基于Web服务的分布式异构数据库集成研究

学号：常州大学毕业设计（论文）（2012届）题目基于Web服务的分布式异构数据库集成研究学生学院专业班级校内指导教师专业技术职务校外指导老师专业技术职务二○一二年六月I基于Web服务的分布式异构数据库集成研究摘要：随着企业的快速发展和不断扩充，对企业内部新旧系统之间的数据、信息进行整合和共享，实现企业信息数据一体化日趋重要。但是，由于企业内部之间采用的系统以及数据库存在分布性和异构性，这必然会促进企业应用集成的发展。本文首先介绍了分布式系统的概念、国内外发展现状，以及分布式系统的体系结构和特点。接着介绍了异构数据库集成的现状，以及异构数据相互集成的方法。然后对各种异构数据集成技术方案进行了分析，阐述了各自的优缺点。最后通过设计和开发一个基于WCFDataService的数据集成案例，在此案例中主要使用了基于XML的数据标准OData。实践证明，基于EntityFramework以及DataService的分布式异构数据集成方案，可以很好的降低系统集成对客户端的限制，对于分布式异构数据集成具有较高的参考价值，该方案同样适用于手机等开发平台。关键字：异构；分布式；Web服务；数据集成IIWebservicebasedonDistributedHeterogeneousDatabaseIntegrationResearchAbstract：Withtherapiddevelopmentofenterprisesandexpanding,ofenterpriseinternaldatabetweennewandoldsystem,informationintegrationandsharing,realizeenterpriseinformationdataintegrationarebecomingmoreandmoreimportant.But,Becausetheenterpriseinteriorisadoptedbetweenthesystemandthedatabaseisdistributedandheterogeneous,thiswillpromotethedevelopmentoftheenterpriseapplicationintegration.Thispaperfirstintroducedtheconceptofdistributedsystems,thedomesticandforeigndevelopmentpresentsituation,anddistributedsystemstructureandcharacteristics.Thenitintroducesthepresentsituationoftheintegrationofheterogeneousdatabase,andeachotherofheterogeneousdataintegrationmethod.Andthentoallsortsofheterogeneousdataintegrationtechnologysolutionsareanalyzed,expoundstheadvantagesanddisadvantagesofeach.FinallythroughthedesignanddevelopmentofaWCFDataServicebasedontheDataintegrationcase,inthiscasethemainusebasedonXMLdataODatastandard.Practiceproves,basedonEntityFrameworkandDataServicedistributedheterogeneousdataofintegratedsolutions，canbeverygoodtoreducethesystemintegrationonclientlimit,fordistributedheterogeneousdataintegrationisofhighreferencevalue,theplanalsoapplytocellphonedevelopmentplatform.Keywords：heterogeneous;distributed;WebService;dataintegrationIII目录摘要............................................................................................................................................I目录..........................................................................................................................................III1前言........................................................................................................................................12相关技术................................................................................................................................22.1分布式数据库系统..............................................................................................................22.1.1基本概念..........................................................................................................................22.1.2分布式数据库系统的特点..............................................................................................22.1.3分布式数据库的体系结构..............................................................................................32.1.5分布式数据库系统的现状..............................................................................................32.2异构数据库系统.................................................................................................................42.2.1异构数据库系统概述......................................................................................................42.2.2异构数据集成现状..........................................................................................................42.2.2异构数据库系统之间数据转换以及集成......................................................................52.3各种异构、分布数据信息集成技术的比较.....................................................................72.3.1ODBC技术......................................................................................................................72.3.2CORBA.............................................................................................................................82.3.3COM/DCOM技术.........................................................................................................102.3.4WebService技术...........................................................................................................102.3.5XML技术.......................................................................................................................123本文用到的技术..................................................................................................................173.1REST..................................................................................................................................173.2WCFDataService.............................................................................................................183.2.1WCFDataService系统架构.........................................................................................193.2.2使用WCFDataService的OData数据发布前后比较...............................................223.3EntityFramework..............................................................................................................233.3.1EntityFramework系统架构........................................................................................233.3.2EntityFramewo