数据库原理知识点总结精华

11.(Data):2.:(Database,DB)3.DBMS:;:1.2.3.4.5.6.4.DatabaseSystemDBSDBMSAccess,VFP/DBMSSQLServer,Oracle,MySQL,DB25DBSDBA)121234DBMS3.1234564.DBMSSecurityIntegrityConcurrencyRecovery2:3;:;;:12E-RE-RDBMS3E-RDBMS12346712,nstudent(nonamesexagedept)51111nmn2111nmnE-RE-RE-R3E-R12R1R2R1DBMSDB4DBMSC/SDBMSB/SInternetDBMSIE1()2/,/,3DBMS5123DBMS3//5)1DBMS2DBMSDDLDMLDCLSQLDDLDMLDCLSQL123456FRRSFRDBABEGINTRANSACTIONCOMMITROLLBACK6NFNFBCNFNFNFNF5432111NFRR?1NFR22NFR?1NFR?2NFR1R2R2[]R233NFR?2NFR?3NF1NF2NF3NF4R?1NFR2NFR?2NF0~1R3NF3NF7()E-RE-RE-RHASHE-R12E-R1E-R2E-R3E-R12111nnmnE-R121131nn4mn58121(.mdf)(.ndf)(.ldf)2MasterModel1Use2Dropdatabase123DBMS9(1)(2)1.2.111122111211212:T1T2T1T121DB23.DBMS10Locking1SQLServer2XTAXAASTASASAA34TAXTAS1ABT1T2AB2(1)TRX(2)(1)TRSS(2)(1)TRS(2)11DBMSB+ClusterHASHselectDBMS121DBMSDBMS12342UNDOREDO1REDOUNDO2UNDOUNDOUNDO3REDOREDOREDO31DBA,2DBA3DBADBMS1),2)3),,4),,1)(REDO)(Undo)2)(Undo)(UNDO),UNDO3)(Redo)(REDO),REDO1)2)131.CREATEROLEGRANT2.(DAC)DBA3.(MAC)DAC()4.()()5.CREATETRIGGER6.7.TCSEC/TDI8.(DAC)(MAC)9.(DAC)SQLGRANTREVOKE10(MAC)11.MAC12.13.1.()2.1.2.-3.I/O()CPU()14(domain)121D1,D2,D3D1D2D32D1D2D312312(,)(,,,,)[]RSRSRSRSRSRSRSRSRS=RSRmK1SnK2RS(m+n)(K1K2)1R)(RF2RRA3SSRFF4SRRS155RxySyzRS=PxxyzRxSyKKRSRSRABCSBCDa1b1c2b1c2d1a2b3c7b2c1d1a3b4c6b2c3d2a1b2c3a4b6c6a2b2c3a1b2c1RAa1a2a3a4a1{b1c2b2c3b2c1}a2{b3c7b2c3}a3{b4c6}a4{b6c6}SBCK{b1c2b2c3b2c1}a1KRS={a1}RXHKHKMXMDZCJ961C1OSD170962C2DBSD272962C4AID280962C1OSD175963C1OSD1901RUUxyUxyxyyxxy16KHKMXMDZ(XH,KH)CJKH(KM,XM)2.xyxx,xyxyyxyxf1(XH,KH)CJXHCJKHCJCJKHXHf),(2KHKMKMKHfxyxyxf3xyxx,xyxyyxyxp1(KH,KM)XMKMXMXMKMKHp),2(XH,KH)DZKHDZDZKHXHp),4xy,yz,yx,zxtKMXM,XMDZ,XMKMxyyxSno,snamesnoyxSno,snamesname,sdeptyxRxyzRxyxyxyxzyzxyyzxzxyxz,xyzxyzxyxz