
Computer Engineering
1999ꡡ254ڡVol.25No.41999



ݿ⸴ƼĸĽ
͵ݷͷ
岨
ժҪݡŴ硷Ҫ˶ݿ⸴ƵĲνṹͰȫԵҪȻҪMS SQL Server6.5ݿ⸴ƻƣΪƵİ͵Ľ㷨
ؼʡֲʽݿ⸴ƹȡȡ
The Improvement of Distribution Database Replication
--A Distributing Methods According to Data Ascription
Liu Qingbo
(People's Band of china,Xiamen Branch Xiamen Branch Xianmen 361004)
Abstract:According to the requirement of Credit Registering Network System in Xiamen,this paper presents the in hierarchical structure and security of database replication,introduces the replication mechanism of MS SQL server 6.5,then describes the plan and algorithms designed for the requirement.
Key words:Distribution;Database;Replication;Ascription;Publication;Horizontal partition;Vertical partition
ݿ⸴ƼѾʵãŴʲķֲʽݿϵͳƺʵʱһЩ⣬бȽͻһ칹ݿ֮ĸƣͬݿ֮䰲ȫ⡣Ҫ۵ڶ⡣Ŵʲһ֯ҽڻͬ齨磬ǸҽڻŴݡɶλͬϵͳУݿİȫԵøҪڸϵͳУݿİȫҪڸҽڻܹͻڻŴϢͬʱҪ֤ԼĴ󲿷Ŵݺͻͳֲй©ڻǸĽMS SQL Server 6.5ݿ⸴Ƽһֲܹͬݿİķͷ
1MS SQL Server 6.5ݿ⸴ƻ
MS SQL Server 6.5УݿڸеĽɫΪַࣺͶķϵݿԶΪݿ⣬ݿݵķԴءķݿǳݿĸƷķݷַĿĵءַݷͣӳݿȡıݣڷݿŶӣȻ͸ķȴķȡݿĸƿԸݿ⣬ֻݿһ֣ûͨĿͳ涨ƵķΧ
ĿĿݿ⸴ƵĻλ ,  ĿݲڵһҪƵı
һĿһ԰һĿһݿԽһһҲΪĵλǶҲԶĶֻĳһĳЩĿĸƷмƻͽ־֡

ͼ1SQL Serverģ
ȡȡ    ĿȡĳһűĵĲУַΪȡĿԶΪĳһűӼĿĲУַΪȡȡͨʽԼ˹̼Թˡ
MS SQL ServerƵҪܲǣ־Ķַ̣̣̺ͬͷַݿ⡣־Ķ̽־диƱ־Ľ͵ַݿ⡣ͬҪĴ䣬γɳʼͬļԼڷַݿм¼ͬҵַ̽洢ڷַݿĽ׺ͳʼͬҵ͵ķַݿһִ洢תݿ⣬Ĵ׼͵ķĽס
2 ݹ͵ݷͷ
MS SQL Serverݿ⸴ƻܹͨӦõҪ󡣵ǶһЩӦãЩܾԵЩŴʲݿ⸴Ƶİȫرر棺һڻĵݱԼݣڶڻ¼νṹϼĵݱ¼ݡ
MS SQL Server ṩķֲʽݿĸƹ޷ˣԸ죬һ䡣MS SQL ServerԴ洢̵ʽʵݿĸƣʽΪûṩԵõĽӿڣ͸졣
ŴʲʱΪҪǶMS SQL ServerṩķֲʽݿĸƹܼԸĽһֲܹͬݿİݹ͵ݷͷ÷´ʩ
1)ڻмĽڿԷΪΣм֧мͰ´ֱBankBranchOfficesÿĻܰŴҵΪŴ   Creditorʾ
2)ÿķһΨһĺͬʱӵ䱾ID֧кźͰ´š<ID֧кźͰ´>˸÷
3)ҵݵĹÿһҵݾĳһŴݿУŴʶCred_IDΪҵݵһҪȷ˸ñҵ
4)ʼͬˣݶķ˵ڸûݣγڸûĳʼݡ
5)ͣݽ׵Ĺѽ׷͵ӦҵС
Ϊʵֳʼͬ˺ͰͣǱĿԷࡣЩĿҪͣ⴦ĿΪͨĿΪAࡣĿǹݣÿ߾ҪЩݡһЩĿҪ͡ݹȷЩĿֿԷΪ࣬УܹͨȷĿΪB࣬ͨⲿͱñĳһȷĿΪCࡣ
ʼͬ㷨
Ŀƣ   ߷
(1)жϸĿǷΪA࣬ת(9)ת(2)
(2)жϸĿǷΪB࣬ת(3)ת(4)
(3)ڸĿԴŴϽһͼ(view)ͼΪķӦϽݣת(5)
(4)ڸĿԴñŴϽһͼͼΪķӦĻϽݣת(5)
(5)ݿϵͳṩĿ(bcp)ͼݵʱļУ
(6)ɾͼ
(7)γɸĿͬӵҵУ
(8)߶ԸĿĶ񣬲ʹԶַʧЧ(ȥö״̬أ
(9)MS SQL ServerԶ̡ͬ
͹
͹̵㷨һݽṹݽṹһŴſɷЧҵŵıñڿƶḶ́ñĽṹ£
<publisher_idValidJobIdbusy>
publisher_idID
ValidJobId:ЧҵID
Busyæ״̬С
͹㷨
(1)ȡЧҵָ룬BusyΪ0BusyΪ1ת(2)˳
(2)ӷַݿҵȡ ID  ڸָȫҵ
(3)ÿҵִ(4)-(10)
(4)ҵеÿִ(5)-(8)
(5)ͬʱļʽתȨ
(6)InsertȡValueӾŴIDѸ뵽ŴIDĻĶҵУ
(7)DeleteȡWhereӾŴIDѸӵŴIDĻĶҵУ
(8)UpdateȡWhereӾŴIDѸ뵽ŴIDĻĶҵУ
(9)(5)-(8)
(10)޸Чҵţ
(11)(4)-(10)
(12)BusyΪ0
(13)
**(6)-(8)BĿCĿֱȡCred_IDֻͨⲿñCred_IDAĿ3
3С
Ϸͨڳ桢ַͶ3׶θĽγһܹݹ͵ķֲʽݿ⡣÷ֲʽݿѾɹӦŴʲϵͳΪϵͳĺġŴʲϵͳ19973µʽͶУ1997ͨй֯ļ
ʵУ͵֯ṹǳձ飬šŹ˾֯϶ǷֲεġڽӦʱ⣬ԲϷԽ
߼:岨У32,ʦ,:ݿ
ߵλ:йзš361004
ο
1Microsoft.Microsoft SQL Server 6.5 ָ.1997
2Microsoft.Microsoft SQL Server Books Online.1996
ո:1998-06-08
