数据库系统概念 第五版 (西尔伯沙茨 著) 机械工业出版社 课后答案 preface 课后答案 11页

'课后答案网，用心为你服务！大学答案---中学答案---考研答案---考试答案最全最多的课后习题参考答案，尽在课后答案网（www.khdaw.com）！Khdaw团队一直秉承用心为大家服务的宗旨，以关注学生的学习生活为出发点，旨在为广大学生朋友的自主学习提供一个分享和交流的平台。爱校园（www.aixiaoyuan.com）课后答案网（www.khdaw.com）淘答案（www.taodaan.com） PrefaceDatabasemanagementhasevolvedfromaspecializedcomputerapplicationtoacentralcomponentofamoderncomputingenvironment,and,asaresult,knowl-edgeaboutdatabasesystemshasbecomeanessentialpartofaneducationincom-puterscience.Inthistext,wepresentthefundamentalconceptsofdatabasemanage-ment.Theseconceptsincludeaspectsofdatabasedesign,databaselanguages,anddatabase-systemimplementation.Thistextisintendedforafirstcourseindatabasesatthejuniororseniorunder-graduate,orfirst-yeargraduate,level.Inadditiontobasicmaterialforafirstcourse,thetextcontainsadvancedmaterialthatcanbeusedforcoursesupplements,orasintroductorymaterialforanadvancedcourse.Weassumeonlyafamiliaritywithbasicdatastructures,computerorganization,andahigh-levelprogramminglanguagesuchasJava,C,orPascal.Wepresentcon-ceptsasintuitivedescriptions,manyofwhicharebasedonourrunningexampleofabankenterprise.Importanttheoreticalresultsarecovered,butformalproofsareomitted.Inplaceofproofs,figuresandexamplesareusedtosuggestwhyaresultistrue.Formaldescriptionsandproofsoftheoreticalresultsmaybefoundinresearchpapersandadvancedtextsthatarereferencedinthebibliographicalnotes.Thefundamentalconceptsandalgorithmscoveredinthebookareoftenbasedonthoseusedinexistingcommercialorexperimentaldatabasesystems.Ouraimistopresenttheseconceptsandalgorithmsinageneralsettingthatisnottiedtooneparticulardatabasesystem.DetailsofparticulardatabasesystemsarediscussedinPart9,“CaseStudies.”Inthis,thefiftheditionofDatabaseSystemConcepts,wehaveretainedtheoverallstyleoftheprioreditionswhileevolvingthecontentandorganizationtoreflectthechangesthatareoccurringinthewaydatabasesaredesigned,managed,andused.Wehavealsotakenintoaccounttrendsintheteachingofdatabaseconceptsandmadeadaptationstofacilitatethesetrendswhereappropriate.Beforewedescribethecontentofthebookindetail,wehighlightsomeofthefeaturesofthefifthedition.xvii xviiiPreface•EarliercoverageofSQL.ManyinstructorsuseSQLasakeycomponentoftermprojects(seeourWebsite,www.db-book.com,forsampleprojects).Inordertogivestudentsampletimefortheprojects,particularlyforuniversi-tiesandcollegesonthequartersystem,itisessentialtoteachSQLasearlyaspossible.Withthisinmind,wehaveundertakenseveralchangesinorganiza-tion:1.Deferringthepresentationoftheentity-relationshipmodeltoPart2,enti-tled“DatabaseDesign.”2.Streamliningtheintroductionoftherelationalmodelbydeferringcover-ageoftherelationalcalculustoChapter5,whileretainingcoverageoftherelationalalgebrainChapter2.3.DevotingtwoearlychapterstoSQL.Chapter3coversbasicSQLfeaturesincludingdatadefinitionandmanipulation.Chapter4coversmoread-vancedfeatures,includingintegrityconstraints,dynamicSQL,andpro-ceduralconstructs.Newmaterialinthischapterincludesexpandedcov-erageofJDBC,proceduralconstructsinSQL,recursioninSQL,andnewfeaturesfromSQL:2003.Thechapteralsoincludesashortoverviewofau-thorization;detailedcoverageofauthorizationisdeferredtoChapter8.ThesechangesallowstudentstobeginwritingSQLqueriesearlyinthecourse,andgainfamiliaritywiththeuseofdatabasesystems.Thisalsoal-lowsstudentstodevelopanintuitionaboutdatabasedesignthatfacilitatestheteachingofdesignmethodologyinPart2ofthetext.Wehavefoundthatstudentsappreciatedatabase-designissuesbetterwiththisorganization.•Anewpart(Part2)thatisdevotedtodatabasedesign.Part2ofthetextcontainsthreechaptersdevotedtothedesignofdatabasesanddatabaseap-plications.Weincludehereachapter(Chapter6)ontheentity-relationshipmodelthatincludesallofthematerialfromthecorrespondingchapterofthefourthedition(Chapter2),plusseveralsignificantupdates.WealsopresentinChapter6abriefoverviewoftheprocessofdatabasedesign.InstructorswhoprefertobegintheircoursewiththeE-Rmodelcanbeginwiththischapterwithoutlossofcontinuity,aswehavestrivedtoavoiddependenciesonanypriorchapterotherthanChapter1.Chapter7,onrelationaldesign,presentsthematerialcoveredinChapter7ofthefourthedition,butdoessoinanew,morereadablestyle.Designcon-ceptsfromtheE-Rmodelareusedtobuildanintuitiveoverviewofrelationaldesignissues,inadvanceofthepresentationoftheformalapproachtodesignusingfunctionalandmultivalueddependenciesandalgorithmicnormaliza-tion.Thischapteralsoincludesanewsectionontemporalissuesindatabasedesign.Part2concludeswithanewchapter,Chapter8,thatdescribesthede-signanddevelopmentofdatabaseapplications,includingWebapplications,servlets,JSP,triggers,andsecurityissues.Inkeepingwiththeincreasedneedtosecuresoftwarefromattacks,coverageofsecurityhasbeensignificantlyexpandedfromthefourthedition. Prefacexix•Thoroughlyrevisedandupdatedcoverageofobject-baseddatabasesandXML.Part3includesaheavilyrevisedchapteronobject-baseddatabasesthatemphasizesSQLobject-relationalfeatures,replacingtheseparatechaptersonobject-orientedandobject-relationaldatabasesfromthefourthedition.Someoftheintroductorymaterialonobject-orientationwhichstudentsarefamil-iarwithfromearliercourseshasbeenremoved,ashavesyntacticdetailsofthenowdefunctODMGstandard.However,importantconceptsunderlyingobject-orienteddatabaseshavebeenretained,includingnewmaterialontheJDOstandardforaddingpersistencetoJava.Part3includesalsoachapteronthedesignandqueryingofXMLdata,whichissignificantlyrevisedfromthecorrespondingchapterinthefourthedition.ItincludesenhancedcoverageofXMLSchemaandXQuery,coverageoftheSQL/XMLstandard,andmoreexamplesofXMLapplicationsincludingWebservices.•Reorganizedmaterialondataminingandinformationretrieval.Datamin-ingandonlineanalyticprocessingarenowcentrallyimportantusesofdata-bases—nolongeronly“advancedtopics.”Wehave,therefore,movedourcov-erageofthesetopicsintoanewpart,Part6,containingachapterondatamin-ingandanalysisalongwithachapteroninformationretrieval.•NewcasestudycoveringPostgreSQL.PostgreSQLisanopen-sourcedatabasesystemthathasgainedenormouspopularityinthepastfewyears.Inadditiontobeingaplatformonwhichtobuilddatabaseapplications,thesourcecodecanbestudiedandextendedincoursesthatemphasizedatabaseinternals.AcasestudyofPostgreSQListhereforeaddedtoPart9,whereitjoinsthreecasestudiesthatappearedinthefourthedition(Oracle,IBMDB2,andMicrosoftSQLServer).Thelatterthreecasestudieshavebeenupdatedtoreflectthelatestversionsoftherespectivesoftware.Thecoverageoftopicsnotlistedabove,includingtransactionprocessing(concur-rencyandrecovery),storagestructures,queryprocessing,anddistributedandpar-alleldatabasesareallupdatedfromtheirfourth-editioncounterparts,thoughtheiroverallorganizationisrelativelyunchanged.ThecoverageofQBEinChapter5hasbeenrevised,removingsyntacticdetailsofaggregationandupdatesthatdonotcor-respondtoanyactualimplementation,whileretainingthekeyconceptsbehindQBE.OrganizationThetextisorganizedinninemajorparts,plusthreeappendices.•Overview(Chapter1).Chapter1providesageneraloverviewofthenatureandpurposeofdatabasesystems.Weexplainhowtheconceptofadatabasesystemhasdeveloped,whatthecommonfeaturesofdatabasesystemsare,whatadatabasesystemdoesfortheuser,andhowadatabasesysteminter-faceswithoperatingsystems.Wealsointroduceanexampledatabaseapplica-tion:abankingenterpriseconsistingofmultiplebankbranches.Thisexample xxPrefaceisusedasarunningexamplethroughoutthebook.Thischapterismotiva-tional,historical,andexplanatoryinnature.•Part1:RelationalDatabases(Chapters2through5).Chapter2introducestherelationalmodelofdata,coveringbasicconceptsaswellastherelationalal-gebra.Thechapteralsoprovidesabriefintroductiontointegrityconstraints.Chapters3and4focusonthemostinfluentialoftheuser-orientedrelationallanguages:SQL.WhileChapter3providesabasicintroductiontoSQL,Chap-ter4describesmoreadvancedfeaturesofSQL,includinghowtointerfacebe-tweenaprogramminglanguageandadatabasesupportingSQL.Chapter5coversotherrelationallanguages,includingtherelationalcalculus,QBE,andDatalog.Thechaptersinthispartdescribedatamanipulation:queries,updates,in-sertions,anddeletions,assumingaschemadesignhasbeenprovided.SchemadesignissuesaredeferredtoPart2.•Part2:DatabaseDesign(Chapters6through8).Chapter6providesanover-viewofthedatabase-designprocess,withmajoremphasisondatabasedesignusingtheentity-relationshipdatamodel.Theentity-relationshipdatamodelprovidesahigh-levelviewoftheissuesindatabasedesign,andoftheprob-lemsthatweencounterincapturingthesemanticsofrealisticapplicationswithintheconstraintsofadatamodel.UMLclass-diagramnotationisalsocoveredinthischapter.Chapter7introducesthetheoryofrelationaldatabasedesign.Thetheoryoffunctionaldependenciesandnormalizationiscovered,withemphasisonthemotivationandintuitiveunderstandingofeachnormalform.Thischapterbeginswithanoverviewofrelationaldesignandreliesonanintuitiveunder-standingoflogicalimplicationoffunctionaldependencies.Thisallowstheconceptofnormalizationtobeintroducedpriortofullcoverageoffunctional-dependencytheory,whichispresentedlaterinthechapter.InstructorsmaychosetouseonlythisinitialcoverageinSections7.1through7.3withoutlossofcontinuity.Instructorscoveringtheentirechapterwillbenefitfromstudentshavingagoodunderstandingofnormalizationconceptstomotivatesomeofthechallengingconceptsoffunctional-dependencytheory.Chapter8coversapplicationdesignanddevelopment.Thischapterem-phasizestheconstructionofdatabaseapplicationswithWeb-basedinterfaces.Inaddition,thechaptercoversapplicationsecurity.•Part3:Object-BasedDatabasesandXML(Chapters9and10).Chapter9cov-ersobject-baseddatabases.Thechapterdescribestheobject-relationaldatamodel,whichextendstherelationaldatamodeltosupportcomplexdatatypes,typeinheritance,andobjectidentity.Thechapteralsodescribesdatabaseac-cessfromobject-orientedprogramminglanguages.Chapter10coverstheXMLstandardfordatarepresentation,whichissee-ingincreasinguseintheexchangeandstorageofcomplexdata.ThechapteralsodescribesquerylanguagesforXML. Prefacexxi•Part4:DataStorageandQuerying(Chapters11through14).Chapter11dealswithdisk,file,andfile-systemstructure.Avarietyofdata-accesstechniquesarepresentedinChapter12,includinghashingandB+-treeindices.Chapters13and14addressquery-evaluationalgorithmsandqueryoptimization.Thesechaptersprovideanunderstandingoftheinternalsofthestorageandretrievalcomponentsofadatabase.•Part5:TransactionManagement(Chapters15through17).Chapter15fo-cusesonthefundamentalsofatransaction-processingsystem,includingtrans-actionatomicity,consistency,isolation,anddurability,aswellasthenotionofserializability.Chapter16focusesonconcurrencycontrolandpresentsseveraltechniquesforensuringserializability,includinglocking,timestamping,andoptimistic(validation)techniques.Thechapteralsocoversdeadlockissues.Chapter17coverstheprimarytechniquesforensuringcorrecttransactionexecutiondespitesystemcrashesanddiskfailures.Thesetechniquesincludelogs,checkpoints,anddatabasedumps.•Part6:DataMiningandInformationRetrieval(Chapters18and19).Chap-ter18introducestheconceptofadatawarehouseandexplainsdataminingandonlineanalyticalprocessing(OLAP),includingSQL:1999supportforOLAPanddatawarehousing.Chapter19describesinformation-retrievaltechniquesforqueryingtextualdata,includinghyperlink-basedtechniquesusedinWebsearchengines.Part6usesthemodelingandlanguageconceptsfromParts1and2,butdoesnotdependonParts3,4,or5.ItcanthereforebeincorporatedeasilyintoacoursethatfocusesonSQLandondatabasedesign.•Part7:Database-SystemArchitecture(Chapters20through22).Chapter20coverscomputer-systemarchitecture,anddescribestheinfluenceoftheun-derlyingcomputersystemonthedatabasesystem.Wediscusscentralizedsys-tems,client–serversystems,parallelanddistributedarchitectures,andnet-worktypesinthischapter.Chapter21,onparalleldatabases,exploresavarietyofparallelizationtech-niques,includingI/Oparallelism,interqueryandintraqueryparallelism,andinteroperationandintraoperationparallelism.Thechapteralsodescribespara-llel-systemdesign.Chapter22coversdistributeddatabasesystems,revisitingtheissuesofdatabasedesign,transactionmanagement,andqueryevaluationandopti-mization,inthecontextofdistributeddatabases.Thechapteralsocoversis-suesofsystemavailabilityduringfailuresanddescribestheLDAPdirectorysystem.•Part8:OtherTopics(Chapters23through25).Chapter23coversperformancebenchmarks,performancetuning,standardizationandapplicationmigrationfromlegacysystems. xxiiPrefaceChapter24coversadvanceddatatypesandnewapplications,includingtemporaldata,spatialandgeographicdata,multimediadata,andissuesinthemanagementofmobileandpersonaldatabases.Finally,Chapter25dealswithadvancedtransactionprocessing.Topicscov-eredincludetransaction-processingmonitors,transactionalworkflows,elec-troniccommerce,high-performancetransactionsystems,real-timetransactionsystems,longdurationtransactions,andtransactionmanagementinmulti-databasesystems.•Part9:CaseStudies(Chapters26through29).Inthispartwepresentcasestudiesoffourleadingdatabasesystems,includingPostgreSQL,Oracle,IBMDB2,andMicrosoftSQLServer.Thesechaptersoutlineuniquefeaturesofeachofthesesystems,anddescribetheirinternalstructure.Theyprovideawealthofinterestinginformationabouttherespectiveproducts,andhelpyouseehowthevariousimplementationtechniquesdescribedinearlierpartsareusedinrealsystems.Theyalsocoverseveralinterestingpracticalaspectsinthede-signofrealsystems.•OnlineAppendices.Althoughmostnewdatabaseapplicationsuseeithertherelationalmodelortheobject-relationalmodel,thenetworkandhierarchi-caldatamodelsarestillinuseinsomelegacyapplications.Forthebenefitofreaderswhowishtolearnaboutthesedatamodels,weprovideappen-dicesdescribingthenetworkandhierarchicaldatamodels,inAppendicesAandBrespectively;theappendicesareavailableonlyonline(http://www.db-book.com).AppendixCdescribesadvancedrelationaldatabasedesign,includingthetheoryofmultivalueddependencies,joindependencies,andtheproject-joinanddomain-keynormalforms.Thisappendixisforthebenefitofindividualswhowishtostudythetheoryofrelationaldatabasedesigninmoredetail,andinstructorswhowishtodosointheircourses.Thisappendix,too,isavailableonlyonline,ontheWebpageofthebook.TheFifthEditionTheproductionofthisfiftheditionhasbeenguidedbythemanycommentsandsuggestionswereceivedconcerningtheearliereditions,byourownobservationswhileteachingatYaleUniversity,LehighUniversity,andIITBombay,andbyouranalysisofthedirectionsinwhichdatabasetechnologyisevolving.Ourbasicprocedurewastorewritethematerialineachchapter,bringingtheoldermaterialup-to-date,addingdiscussionsonrecentdevelopmentsindatabasetechnol-ogy,andimprovingdescriptionsoftopicsthatstudentsfounddifficulttounderstand.Asinthefourthedition,eachchapterhasalistofreviewtermsthatcanhelpreadersreviewkeytopicscoveredinthechapter.Mostchaptersalsohaveatoolssectionattheendofthechapterthatprovidesinformationonsoftwaretoolsrelatedtothetopicofthechapter.Wehavealsoaddednewexercisesandupdatedreferences. PrefacexxiiiInthefifthedition,wehavedividedtheexercisesintotwosets:practiceexercisesandexercises.ThesolutionsforthepracticeexercisesarepubliclyavailableontheWebpageofthebook.Studentsareencouragedtosolvethepracticeexercisesontheirown,andlaterusethesolutionsontheWebpagetochecktheirownsolutions.Solutionstotheotherexercisesareavailableonlytoinstructors(see“Instructor’sNote,”below,forinformationonhowtogetthesolutions).Instructor’sNoteThebookcontainsbothbasicandadvancedmaterial,whichmightnotbecoveredinasinglesemester.Wehavemarkedseveralsectionsasadvanced,usingthesymbol∗∗.Thesesectionsmaybeomittedifsodesired,withoutalossofcontinuity.Exercisesthataredifficult(andcanbeomitted)arealsomarkedusingthesymbol“∗∗.”Itispossibletodesigncoursesbyusingvarioussubsetsofthechapters.Weoutlinesomeofthepossibilitieshere:•SectionsofChapter4fromSection4.6onwardmaybeomittedfromanintro-ductorycourse.•Chapter5canbeomittedifstudentswillnotbeusingrelationalcalculus,QBEorDatalogaspartofthecourse.•Chapters9(Object-BasedDatabases),10(XML),and14(QueryOptimization)canbeomittedfromanintroductorycourse.•Bothourcoverageoftransactionprocessing(Chapters15through17)andourcoverageofdatabase-systemarchitecture(Chapters20through22)consistofanoverviewchapter(Chapters15and20,respectively),followedbychap-terswithdetails.YoumightchoosetouseChapters15and20,whileomittingChapters16,17,21,and22,ifyoudefertheselatterchapterstoanadvancedcourse.•Chapters18and19,coveringdataminingandinformationretrieval,canbeusedasself-studymaterialoromittedfromanintroductorycourse.•Chapters23through25aresuitableforanadvancedcourseorforself-studybystudents.•Thecase-studyChapters26through29aresuitableforself-studybystudents.Modelcoursesyllabi,basedonthetext,canbefoundontheWebhomepageofthebook(seethefollowingsection).WebPageandTeachingSupplementsAWebhomepageforthebookisavailableattheURL:http://www.db-book.com xxivPrefaceTheWebpagecontains:•Slidescoveringallthechaptersofthebook•Answerstothepracticeexercises•Laboratorymaterial•Thethreeappendices•Anup-to-dateerratalist•SupplementarymaterialcontributedbyusersofthebookThefollowingadditionalmaterialisavailableonlytofaculty:•Aninstructormanualcontainingsolutionstoallexercisesinthebook•AquestionbankcontainingextraexercisesFormoreinformationabouthowtogetacopyoftheinstructormanualandtheques-tionbank,pleasesendelectronicmailtocustomer.service@mcgraw-hill.com.IntheUnitedStates,youmaycall800-338-3987.TheMcGraw-HillWebpageforthisbookishttp://www.mhhe.com/silberschatzContactingUsandOtherUsersWehaveendeavoredtoeliminatetypos,bugs,andthelikefromthetext.But,asinnewreleasesofsoftware,bugsprobablyremain;anup-to-dateerratalistisaccessiblefromthebook’shomepage.Wewouldappreciateitifyouwouldnotifyusofanyerrorsoromissionsinthebookthatarenotonthecurrentlistoferrata.Wewouldbegladtoreceivesuggestionsonimprovementstothebooks.WealsowelcomeanycontributionstothebookWebpagethatcouldbeofusetootherread-ers,suchasprogrammingexercises,projectsuggestions,onlinelabsandtutorials,andteachingtips.Emailshouldbeaddressedtodb-book@cs.yale.edu.AnyothercorrespondenceshouldbesenttoAviSilberschatz,DepartmentofComputerScience,YaleUniversity,51ProspectStreet,P.O.Box208285,NewHaven,CT06520-8285USA.Wealsoprovideamailinglistthroughwhichusersofourbookcancommunicateamongthemselvesandwithus,andreceiveupdatesonthebookandotherrelatedinformation.Thelistismoderated,soyouwillnotreceivejunkmailonthelist.Pleasefollowthemailinglistlinkfromthebook’shomepagetosubscribetothemailinglist.AcknowledgmentsThiseditionhasbenefitedfromthemanyusefulcommentsprovidedtousbythenumerousstudentswhohaveusedthepriorfoureditions.Inaddition,manypeople Prefacexxvhavewrittenorspokentousaboutthebook,andhaveofferedsuggestionsandcom-ments.Althoughwecannotmentionallthesepeoplehere,weespeciallythankthefollowing:•HaniAbu-Salem,DePaulUniversity;JamelR.Alsabbagh,GrandValleyStateUniversity;RamziBualuan,NotreDameUniversity;ZhengxinChen,Uni-versityofNebraskaatOmaha;JanChomick,SUNYBuffaloUniversity;QinDing,PennStateUniversityatHarrisburg;FrantisekFranek,McMasterUni-versity;ShashiK.Gadia,IowaStateUniversity;WilliamHankley,KansasStateUniversity;RandyM.Kaplan,DrexelUniversity;MarkLlewellyn,Univer-sityofCentralFlorida;MartyMaskarinec,WesternIllinoisUniversity;Yiu-KaiDennisNg,BrighamYoungUniversity;SunilPrabhakar,PurdueUniver-sity;StewartShen,OldDominionUniversity;AnitaWhitehall,FoothillCol-lege;ChristopherWilson,UniversityofOregon;WeiningZhang,UniversityofTexasatSanAntonio;whoservedasreviewersofthebookandwhosecom-mentshelpedusgreatlyinformulatingthisfifthedition.•AnastassiaAilamaki,SaileshKrishnamurthy,SpirosPapadimitriou,andBia-ncaSchroeder(CarnegieMellonUniversity)forwritingtheappendixdescrib-ingthePostgreSQLdatabasesystem.•HakanJakobsson(Oracle),fortheappendixontheOracledatabasesystem,•SriramPadmanabhan(IBM),fortheappendixdescribingtheIBMDB2databasesystem.•SameetAgarwal,Jos´eA.Blakeley,ThierryD’Hers,GeraldHinson,DirkMy-ers,VaqarPirzada,BillRamos,BalajiRathakrishnan,MichaelRys,FlorianWaasandMichaelZwilling(allofMicrosoft)fortheappendixontheMi-crosoftSQLServerdatabasesystem.Jos´eBlakeleyalsoforcoordinatingandeditingChapter29,andC´esarGalindo-Legaria,GoetzGraefe,KalenDelaney,andThomasCasey(allofMicrosoft)fortheircontributionstothepreviouseditionoftheMicrosoftSQLServerchapter.•ChenLiandSharadMehrotraforprovidingmaterialonJDBCandsecuritythathelpedupdateandextendChapter8.•ValentinDinu,GoetzGraefe,BruceHillyer,ChadHogg,NahidRahman,PatrickSchmid,JeffStorey,PremThomas,LiuZhenming,andparticularlyN.L.Sardafortheirfeedback,whichhelpeduspreparethefifthedition.•RamiKhouri,NahidRahman,andMichaelRysforfeedbackondraftversionsofchaptersfromthefifthedition.•RajAshar,JanekBogucki,GavinM.Bierman,ChristianBreimann,TomChap-pell,Y.C.Chin,LaurensDamen,PrasannaDhandapani,ArvindHulgeri,Zhe-ngJiaping,GrahamJ.L.Kemp,HaeChoonLee,Sang-WonLee,Thanh-DuyNguyen,D.B.Phatak,JuanAltmayerPizzorno,RajarshiRakshit,GregRic-cardi,N.L.Sarda,MaxSmolens,NikhilSethi,andTimWahlsforpointingouterrorsinthefourthedition. xxviPreface•MarilynTurnamian,whoseexcellentsecretarialassistancewasessentialfortimelycompletionofthisfifthedition.ThepublisherwasBetsyJones.ThesponsoringeditorwasKellyLowery.Thede-velopmentaleditorwasMelindaD.Bilecki.TheprojectmanagerwasPeggySelle.TheexecutivemarketingmanagerwasMichaelWeitz.ThemarketingmanagerwasDawnBercier.ThecoverillustratorandcoverdesignerwasJoAnneSchopler.ThefreelancecopyeditorwasGeorgeWatson.ThefreelanceproofreaderwasJudyGan-tenbein.ThedesignerwasLaurieJanssenThefreelanceindexerwasTobiahWaldron.Thiseditionisbasedonthefourpreviouseditions,sowethankonceagainthemanypeoplewhohelpeduswiththefirstfoureditions,includingR.B.Abhyankar,DonBatory,PhilBernhard,HaranBoral,PaulBourgeois,PhilBohannon,RobertBraz-ile,YuriBreitbart,MichaelCarey,SoumenChakrabarti,J.Edwards,ChristosFalout-sos,HommaFarian,AlanFekete,ShashiGadia,JimGray,LeGruenwald,EitanM.Gurari,RonHitchens,YannisIoannidis,Hyoung-JooKim,WonKim,HenryKorth(fatherofHenryF.),CarolKroll,GaryLindstrom,IrwinLevinstein,LingLiu,DaveMaier,KeithMarzullo,FletcherMattox,SharadMehrotra,JimMelton,AlbertoMend-elzon,HectorGarcia-Molina,AmiMotro,BhagirathNarahari,AnilNigam,CyrilOrji,MeralOzsoyoglu,BrucePorter,JimPeterson,K.V.Raghavan,KrithiRamamritham,MikeReiter,OdinaldoRodriguez,MarkRoth,MarekRusinkiewicz,SunitaSarawagi,N.L.Sarda,S.Seshadri,ShashiShekhar,AmitSheth,NanditSoparkar,GregSpeegle,DilysThomas,andMarianneWinslett.MarilynTurnamianandNandprasadJoshiprovidedsecretarialassistanceforthefourthedition,andMarilynalsopreparedanearlydraftofthecoverdesignforthefourthedition.LynDupr´ecopyeditedthethirdeditionandSaraStrandtmaneditedthetextofthethirdedition.NileshDalvi,SumitSanghai,GauravBhalotia,ArvindHulgeriK.V.Raghavan,PrateekKapadia,SaraStrandtman,GregSpeegle,andDawnBezvinerhelpedtopreparetheinstructor’smanualforearliereditions.Thenewcoverisanevolutionofthecoversofthefirstfoureditions.TheideaofusingshipsaspartofthecoverconceptwasoriginallysuggestedtousbyBruceStephan.Finally,Sudarshanwouldliketoacknowledgehiswife,Sita,forherloveandsup-portandsonMadhurforhislove.Hankwouldliketoacknowledgehiswife,Joan,andhischildren,AbbyandJoe,fortheirloveandunderstanding.AviwouldliketoacknowledgeValerieforherlove,patience,andsupportduringtherevisionofthisbook.A.S.H.F.K.S.S.'