吉林大学数据库技术与Oracle sql-00.ppt

1-*0数据库链路（DatabaseLink）,DatabaseLink是一个关键部件,引用其他数据库的数据时，需要指明详细路径，链路就是详细路径的识别名。数据库连接允许用户处理远程数据库的数据而不用知道数据在什么地方。当建立了一个数据库连接后，提供对远程数据库的登录信息。每当使用数据库连接时，在分布网络上初始化一个对话(Session)，以解决对远程数据库或视图的引用。数据库技术与Oracle参考书：Oracle技术系列丛书1．《Oracle9i初学者指南》王海峰等译，机械工业出版社3．《Oracle数据库管理与应用系统开发》，刘荣华等编著，人民邮电出版社2．《Oracle9i参考手册》，机械工业出版社IntroductionToORACLERDBMS1960‘sHardData1970’sFileSystem1970,RDBMS,E.F.Codd1979,FirstORACLERDBMSORDBMSTypesofOracleUsersDatabaseAdministratorsSecurityOfficersNetworkAdministratorsApplicationDevelopersApplicationAdministratorsDatabaseUsersDatabaseAdministratorsIInstallingandupgradingtheOracleserverandapplicationtoolsAllocatingsystemstorageandplanningfuturestoragerequirementsforthedatabasesystemCreatingprimarydatabasestoragestructures(tablespaces)afterapplicationdevelopershavedesignedanapplicationCreatingprimaryobjects(tables,views,indexes)onceapplicationdevelopershavedesignedanapplicationModifyingthedatabasestructure,asnecessary,frominformationgivenbyapplicationdevelopersDatabaseAdministratorsIIEnrollingusersandmaintainingsystemsecurityEnsuringcompliancewithyourOraclelicenseagreementControllingandmonitoringuseraccesstothedatabaseMonitoringandoptimizingtheperformanceofthedatabaseDatabaseAdministratorsIIIPlanningforbackupandrecoveryofdatabaseinformationMaintainingarchiveddataontapeBackingupandrestoringthedatabaseContactingOracleCorporationfortechnicalsupportTasksofaDatabaseAdministratorTask1:EvaluatetheDatabaseServerHardwareTask2:InstalltheOracleSoftwareTask3:PlantheDatabaseTask4:CreateandOpentheDatabaseTask5:BackUptheDatabaseTasksofaDatabaseAdministratorTask6:EnrollSystemUsersTask7:ImplementtheDatabaseDesignTask8:BackUptheFullyFunctionalDatabaseTask9:TuneDatabasePerformanceDatabaseObjectsTable,Column,D