吉林大学数据库技术与Oracle sql_all完整225页.ppt

0IntroductionToORACLE

RDBMS1960‘sHardData1970’sFileSystem1970,RDBMS,E.F.Codd1979,FirstORACLERDBMSORDBMS

TypesofOracleUsersDatabaseAdministratorsSecurityOfficersNetworkAdministratorsApplicationDevelopersApplicationAdministratorsDatabaseUsers

DatabaseAdministratorsIInstallingandupgradingtheOracleserverandapplicationtoolsAllocatingsystemstorageandplanningfuturestoragerequirementsforthedatabasesystemCreatingprimarydatabasestoragestructures(tablespaces)afterapplicationdevelopershavedesignedanapplicationCreatingprimaryobjects(tables,views,indexes)onceapplicationdevelopershavedesignedanapplicationModifyingthedatabasestructure,asnecessary,frominformationgivenbyapplicationdevelopers

DatabaseAdministratorsIIEnrollingusersandmaintainingsystemsecurityEnsuringcompliancewithyourOraclelicenseagreementControllingandmonitoringuseraccesstothedatabaseMonitoringandoptimizingtheperformanceofthedatabase

DatabaseAdministratorsIIIPlanningforbackupandrecoveryofdatabaseinformationMaintainingarchiveddataontapeBackingupandrestoringthedatabaseContactingOracleCorporationfortechnicalsupport

TasksofaDatabaseAdministratorTask1:EvaluatetheDatabaseServerHardwareTask2:InstalltheOracleSoftwareTask3:PlantheDatabaseTask4:CreateandOpentheDatabaseTask5:BackUptheDatabase

TasksofaDatabaseAdministratorTask6:EnrollSystemUsersTask7:ImplementtheDatabaseDesignTask8:BackUptheFullyFunctionalDatabaseTask9:TuneDatabasePerformance

DatabaseObjectsTable,Column,DatatypesIndexViewSequenceSynonymPartitionCluster

DatabaseObjectsProcedureandFunctionPackageTriggerUsersPrivilegesandRolesDatabaseLinks

NativeDatatypes

CharacterDatatypesCHARDatatypeVARCHAR2andVARCHARDatatypesNCHARandNVARCHAR2DatatypesLONGDatatypeNUMBERDatatypeDATEDatatypeLOBDatatypesRAWandLONGRAWDatatypesROWIDandUROWIDDatatypes

SQLO