【作者】 郑全；

【导师】 傅鹂； 李初民；

【作者基本信息】 重庆大学 ， 软件工程， 2007， 硕士

【摘要】 从2000年开始,我国的集团医院发展迅猛,到2003年时,就有320多家,但我国集团医院之间由于地域上的分布特点,为了实现统计管理功能,比较传统的做法就是直接在各医院之间铺设专线,这样,有几个明显的缺陷,一是费用比较昂贵,二是太依赖中心数据库,如果中心数据库出现问题,其他所有医院都没有办法继续操作,三是我国当前的网络条件,总有网络延迟现象,这样,各分院在进行系统操作时,运行速度总不能令人满意。而根据集团医院的特点,不是任何操作都必须要实时与中心进行连接的,分院和总院之间,只需要定期进行数据交换即可。本论文提出使用ORACLE流复制来解决这个问题,而ORACLE流复制本身可以在几个数据库之间使用增量异步复制,让各数据库定期进行同步,各分院客户端只需要连接到分院服务器即可开展正常的业务操作,这样,各医院之间使用现行的INTERNET互联网就可解决以前要使用专线才能解决的问题,同时,网络速度问题也得到了圆满解决。当然,ORACLE流复制技术不是直接就可以应用到集团医院的,它需要处理复制中的冲突,网络流量等,本文正是基于流复制本身在集团医院中的应用前景,研究如何利用ORACLE流复制这一新的技术在集团医院数据共享中的应用,不光是实现单向复制的容灾,同时要实现双向对等的复制,以及一个完整的流复制建立过程,包括如何建立流复制环境,流复制项目变更的处理,以及高可用性环境的建立等等,让ORACLE流复制在集团医院中真正应用起来,为集团医院节省大笔的开销。最后,以南京栖霞区医院的实际使用来例证了流复制技术在集团医院信息共享中的可行性。更多还原

【Abstract】 Since A.D. 2000,The Group Hospital in china develop rapid,until A.D. 2006,the number of the group hospital reached at 320. because the hospitals in group hospital locate at different areas,for statistic function and management,we plan to construct special line in between the hospitals and group hospital. Like this, there are three obvious shortage like the following: firstly,cost is very expensive;secondly,branch hospital depend center database,if the central database is crashed,all the other hospital is stopped;finally,network connect is slow base on current network in china,the speed is not satisfied. For the characteristic of group hospital,it is not necessary that stable connecting between center and branch,between branch and center ,the only need is switching data in regular time. Oracle stream replication can do asynchronous increment replication,all the database can in-phase in regular time.the branch can implement normal operation as soon as they connect to the branch hospital server,like this,using internet both the branches can resolve the problem that the special network resolve, simultaneity,the speed of network has been resolved.Of course ,the ORACLE stream replication is not applied directly at the group hospital,we need resolve conflict ,network flux etc.The author introduced the oracle stream replication application in group hospital.not only single direction replication,but also double direction replication ,and how to set up a complete stream replication ,for example:how to construct stream replication entironment,how to resolve the changed stream replication item,and construct the high available entironment,etc.the group hospital will save much cost by the oracle stream replication is been applied.finally,this thesis verify the feasibility and rationality of stream replication in group hospital information sharing by stream implements in xixia people hospital.更多还原