数据库系统原理(英文)-Syllabus for Database System Principles

BeijingUniversityofTelecommunicationsofComputerSyllabusforDatabaseSystemPrinciplesTitle:PrinciplesCredit:Credits,requiredcourseYear:2007—

17design,professionalthiscourse:）,30credits,conductedthe3Prerequisites:

DiscreteMathematicsOperating1

AlgorithmsDesignandAnalysis2.LectureTime:AM:8:00–10:00FridayAM:8:00–10:00,weeksTeachingBuilding3.FacultyInstructor

ame:Dr.WenYE(文)Room918,TeachingBuildingOfficeIalsoappointmentatmoreconvenientforyou,especiallythethisPhone:(O)E-mail:gryew@263.net,yewen@

???directingexperimentsRoom913,Building2

OfficeFriday14:00PM,byappointment

()homeworkRoom918,BuildingOffice13:30to15:00byappointmentE-mail:BookSilberschatz,HenryF.Korth,S.Database(ForthEdition),EducationBeijing,May,2002.References研究组，2002，，2002年8冯，SQLServer年3月。年3年M.Connolly,CarolynE.AbyStepGuideBuildingChinaMachinePressandHall,Beijing,Feb.2004。Server实，2002年35.Websites

Lecturenotesandcoursematerialsmaybeonwebsiteonregularbasis.arecheckitregularlyalso

Others6.Course(DBS)isessentialofInformationManagementknowledgeareaspecifiedChinaCurricula2001byIEEE/CS.Principlesrequiredcoursemajoringcomputer.hisismajoringcomputerandacquirefullmasteryofdatabaseprinciplesandbyMicrosoftSQLServerafter-classtheterm.4in-classteachingisdesignedtobeintroductionthemethodologiesofDatabasesystems.coursewillalsobeamixturepracticalwherewilltheorySQLexperimentsandprofessionalpractices.MicrosoftSQLServer2000ascasestudytheDatabaseSystemPrinciplesinInparallellearning,finishseveralexperimentswhichwillthemacquiringoftaughtinclassandbecomeServer.Duringtheterm(usuallytwoendeachDatabaseSystemPrinciples，thedevelopatelecommunications-area-orienteddemo,SubsystemintheOptimizationforGSM/GPRSMobileCommunicationssoastoattainofdesignandheimplementationthementionedabovewilltheabilitiesofimprovetheofDatabaseSystemPrinciplesin数据库系课的Server技术(ApplicationofSQLServertoProfessional5PracticeCourseSystemPrinciples)Assupportedbythesyllabus,lectures,experimentguides,applicationthecoursewillwebsiteofMicrosoftofuniversities.learnersofDatabaseSystemPrincipleswillthesematerialsfreeofMeanwhile,theimplementationthecoursewillalsotoMicrosoftServerandproducts.Inaddition,SubsystemintheManagementMobileCommunicationsSystemsdevelopedbyinprofessionalwillaforandofthisstudyofdatabaseapplicationsystemsintelecommunications7.1程系三个14含个核心知识单元～IM7）心（～IM146

数超多数“IM目前，国内外该IM”知识领域中的6个核心知（IM2～和2个心（而IM知识领（如修非核心知识单元，用于完备课程体系。求查ChinaCurricular7IM6IM7和心/选修知识单元IM9、个在Curricula2002中Practice（专业实践）是一项重要教学活动。它可以帮同解决问专业通数据库系统》课程实验包括((coursepractice)两7.2程习求“知道了掌、精通要”的相关要”的要“”要”的相关知识部分。8.Course8.1CourseofSystemincludesi.e.,In-classofDatabaseSystemPrincipleson8ProfessionalinSQLServer200010days,hours),i.e.willMicrosoftSQLServerasastudy,itsprinciplestheI.OverviewintroductionthefeaturesandofDBSisincludingconceptsofdatamodelanddataabstraction.MicrosoftServertakenasanII.RelationalDBSdatamodeldataandintegrityStructuredlanguageSQLinMicrosoftServerusedthefunctionalitiesofindatadefinition,dataanddatacontrol.(3)andSecurityintegritysecuritySQLServeraretakenasexamples,includingtriggers,users,privilegesSQLServer.III.E_RmodelandareDBSrequirementanalysis,conceptualDBSlogicalDBSandphysicalDBSdesignaregiven.9IV.(1)ofandareprovided.Serverisgoodexample.(2)storageandfileorganizationstoragemechanismsSQLServeraretakenastoillustratetheofstorageallocationdataaccessinDBS.(3)Queryoptimizationcomponents,optimizationtechnologiesare(4)TransactionmanagementmechanismsinDBSespeciallyconcurrencyTransactioninSQLServerisgivenSQLServersrow-levellocking,locking,dynamicare(5)Recoveryforarepresented.BackuprecoveryusedSQLcoursewillcovertherelevantandsectionstheI.PrinciplesofDBS(基本理论)modelPART1,PART3(chapter8)PART7A,B10PART2—PART3—II.(数据库应用系统开发LifetimesdesignofDBS(生命周期与设计过)LogicalDBSdesign(逻辑数据库设计PART2（form）PART9(App.发)PART7III.(orDBMS)ImplementationmanagementPART4QueryPART4PART7TransactionPART5PART7PART6(chapter18-20)IV.CASESTUDIESPART811Server20008.3DBS

InparallelcoursesixexperimentsSQLindependently,gettohaveagraspoftheirknowledgeaboutDBSlearnedinthebecomepracticalDBMSSQLServer.EnvironmentsMicrosoftDBMS:SQLServerorenterpriseversion)ContentsonSQLServerlearnSQLdatadefinition,includingviews.onSQLServertoTransact-SQLdataincludingcomplexquery,andnestedquery.(3)TheSQLlearnbuildingmaintainingofincludingDelete,onDB..experimentonSQLServerlearnsecuritymechanisms,includingroles,andprivilegesdataonServertolearnintegritymechanisms,12

includingandexperimentonSQLServerlearnbackupinDBS.8.4ProfessionalPractice/CourseDBS

GoalsInCurriculumpracticethepartdiscipline.ToincorporateprofessionalpracticetheDatabaseSystemPrinciples,implementationteamsarerequiredtodesignandtelecommunications-area-orienteddatabaseapplicationtotheofengineeringandDBSprofessionalpracticehelpsthetofullofwhattheyhavelearnedinclass,learnworkinteams,experiencewholeofsimpledatabasesystemsbySQLAllthiswillimprovetheabilityofDBS.

EnvironmentstoolsMicrosoftDBMS:SQLServerorenterpriseversion)13ProgrammingMicrosoftVisual6.0/MicrosoftVisualJ++6.0

aregroupedintoandthereeachEachteamaofdatamanagementinnetworkmanagementforThehasarchitecture,datainGSM/GPRSnetworkasmanagement,management,andfailureconsistsphases,thatis,analysis,conceptualschemadesign,logicaldesign,physicalschemadesign,Thedesigndocumentsforofthese

DevelopmentContentsDescribingtheofdatainGSM/GPRSnetworkmanagementintermsofdataflowdiagram.Identifying(ManagedObjects)innetworksinTMNNetworkManagement),intoentitiesobtainingdiagramastheresultsofDBSconceptualdesign.TransferringtheE-Rdiagramsintorelationalschemas,which14thenrefinedtonormalasthelogicaldesign.DefiningindicesschemabyofinSQLServer,andandinThen,loadingrealtablestoupthenetworkservermachine.DevelopingapplicationprogramsclientmachinesbyBasic,interactserverODBCorJDBC,andallowuserstoaccessnetwork9.and

统SQLServer2000,在课

Server15

/于ServerB/SGSM/GPRS网养对面向心/选修知识单物10.RelationshipsOther

data++，I/O子系：系统：式11.Policieswilltwoin-classopen-booktests.Therewillseverale