数据库系统概念英文答案习题解答.pdfVIP

CHAPTER19

DistributedDatabases

PracticeExercises

19.1Howmightadistributeddatabasedesignedforalocal-areanetworkdiffer

fromonedesignedforawide-areanetwork?

Answer:Datatransferonalocal-areanetwork(LAN)ismuchfasterthan

onawide-areanetwork(WAN).Thusreplicationandfragmentationwill

notincreasethroughputandspeed-uponaLAN,asmuchasinaWAN.

ButeveninaLAN,replicationhasitsusesinincreasingreliabilityand

availability.

19.2Tobuildahighlyavailabledistributedsystem,youmustknowwhatkinds

offailurescanoccur.

a.Listpossibletypesoffailureinadistributedsystem.

b.Whichitemsinyourlistfrompartaarealsoapplicabletoacentral-

izedsystem?

Answer:

a.Thetypesoffailurethatcanoccurinadistributedsysteminclude

i.Sitefailure.

ii.Diskfailure.

iii.Communicationfailure,leadingtodisconnectionofoneormore

sitesfromthenetwork.

b.Thefirsttwofailuretypescanalsooccuroncentralizedsystems.

19.3Considerafailurethatoccursduring2PCforatransaction.Foreachpos-

siblefailurethatyoulistedinPracticeExercise19.2a,explainhow2PC

ensurestransactionatomicitydespitethefailure.

Answer:Aproofthat2PCguaranteesatomiccommits/abortsinspiteof

siteandlinkfailures,follows.Themainideaisthatafterallsitesreply

withareadyTmessage,onlytheco-ordinatoro