oracle数据库售前培训v1

Oracle„„„„SQL()„SQL()„()„„6432OS„WindowsUnix„UnixLinux„Unix„Linux„Oracle„OracleRDBMSSQLserverDB2„Oracle„Oracle„„.().20002„HectorGarcia-MolinaJeffreyD.UllmanJenniferWidom..200310„AbrahamSilberschatzHenryF.KorthS.Sudarshan..200310„RaghuRamakrishnanJohannesGehrke..200212„.20042„„Oracle8i9i10g„MicroSoftSQLServer2000/2005„„(Data)„(Database)„(DBMS)„(DBS)„(Data)„(Data)„„„„„„„„19721990„„„„„19721990„„19721990„„„„19721990„Database„„„(Database,DB)„„„950041995950062095950081895………………„„„„„„„DBMS„DatabaseManagementSystemDBMS„DBMS„„DBMS1„„(DDL)„„:(DML)„()„DBMS2„„„„„()„„„„„„„DatabaseSystemDBS„„„„„„„(40--50)„(50--60)„(60--)„„„„„DBMSDBMS12…„DBMS„„„„„DBMS„„„„„„DBMS„„„„„„„DBMS„DBMS„Security„„Integrity„„Concurrency„„Recovery„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„(E-R)„E-R„E-RE-R„E-R„E-R„(1)Entity„„„(2)Attribute„„„E-R„(3)Key„„(4)Domain„„E-R„(5)EntityType„„„(6)EntitySet„„E-R„(7)Relationship„„„„„„„1:1„1:n„m:n„E-R„12111:112mnm:n121n1:n„E-R„„„ABAB1:1„„E-R„„„ABnn0BAAB1:n„„E-R„„m:n„ABnn0BAmm0ABm:n„„E-R„„„E1E2...EnEjj=12...i-1i+1...nEiEiE1E2...Ei-1Ei+1...En„„„1970IBMSanJoseE.F.Codd„„Relation„Tuple„Attribute„„Key„Domain„„12n„„950041995950062095950081895………………„„„„„„„„„1()2„„3„„„„„„„“”„„„„„„DBMSDbaseFoxbase„DBMSOracle„„„„„„„„„„„„„„„ORACLE„SYBASE„INFORMIX„DB/2„COBASE„PBASE„EasyBase„DM/2„OpenBase„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„„Bhash„„„„„„„„„„„„„„„„„„„„„„„OracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracleOracle„„6432OS„WindowsUnix„UnixLinux„Unix„Linux„6432OS„CPU64„„Unix64„Windows642003XP„6432OS„32„„„321.7GBoracleSGA„WindowsUnix„64windowsUnix„Unixwindow„„„Unixwindows„windows„„windows„UnixLinux„Linux„„OracleRAConLinuxRHAS4u2SASu4„„Unix„SunSolaris910„AIX5.3„HP-UX„Linux„RedHatAS34„SuSEOracle„RAS„Reliability„„Availability„„Serviceability„Oracle„HighAvailability„95999.999%5„„„„„„„„cluster„Oracle„OracleRACOracle„cluster„node„„Oracle„Oracle„Sun„422„„SunClusterVeritasVCS„VeritasVM„GBGB„V490Oracle„Oracle„„„„„CPU„OracleOracle„Oracle„Sun/Solaris„„SunV490„4„FCSCSI„„„Solaris910„SunClusteroracleagent„oracle9iR2/10gR2oracleOracle„Oracle„WindowsMSCS„„PC„4„FCSCSI„„„window2003server(64)„oracle10gR2Oracle„OracleRAC„„„„„CPU„OracleOracle„OracleRAC„Sun/Solaris„„SunV490„4„FCSCSI„„„Solaris10„oracle10gR2Oracle„OracleRAC„Linux„„PCDell2850HP380G4„4„FCSCSI„„„AS4update264„oracle10gR2„Dell2950HP380G5AS4update464Oracle„OracleRAC„IBMAIX„„RS6000„4„FCSCSI„„„AIX5.3„HACMP5.2„oracle10gR2Oracle„LegatoAAM„windows„„„4GBOracle„„„„Bakbone„VeritasNBU„OracleRMANOracle„BakboneVeritasNBU„MMLRMAN„„„„„„„CCTV„Oracle„oracleRMAN„„„„CCTV„„Solaris9„Solaris10Solariszoneoracle„OracleHA„OracleRAC„orace„„oracle„OracleHA„OracleRAC„Oracleoracle„„„„orace„„