ORACLE Stream Replication Research In Group Hospital

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.