您好,欢迎访问三七文档
当前位置:首页 > IT计算机/网络 > 数据库 > Oracle基本概念
1、CHAPTER01SQLOracle10gOracleOraclech01.indd12006/5/30、U、ネ06:22:271-2OracleDatabase10gOCPI1Z0-042OracleRelationalDatabaseManagementSystemRDBMS1-110DatabaseManagementSystemDBMSch01.indd22006/5/30、U、ネ06:22:29Chapter01Oracle1-350hierarchicalnetworkrelationalOracleRelationalDatabaseManagementSystemRDBMS19706ACMCommunicationsoftheACMAssociationofComputingMachineryjournalIBMDr.E.F.CoddARelationalModelofDataforLargeSharedDataBanksphysicalstorageNoteDr.E.F.CoddARelationalModelofDataforLargeSharedDataBank。
2、sACMwww.acm.org/classics/nov95/toc.htmlconstraintCodd1212RDBMS1-1CustomersIDOrdersch01.indd32006/5/30、U、ネ06:22:311-4OracleDatabase10gOCPI1Z0-042CustomerIDprimarykey1-1CustomersCustomerIDCustomerIDOrdersOrderID1-1CustomersOrdersCustomerIDch01.indd42006/5/30、U、ネ06:22:32Chapter01Oracle1-5foreignkey1-1OrdersCustomerIDCustomersCustomerIDOrdersCustomerIDCustomersCustomerIDOracleSQLStructuredQueryLanguageRDBMSOracleStructuredQueryLanguageSQLSQLIBME.F.CoddStructuredEnglishQueryLanguageSEQUELStructuredQu。
3、eryLanguageSQLsequelSQLDataDefinitionLanguageDDLDDLDDLCREATEALTERDROPRENAMETRUNCATECREATETABLEDROPINDEXDataManipulationLanguageDMLDMLDMLINSERTUPDATEDELETECOMMITROLLBACKSAVEPOINTSELECTDMLDMLch01.indd52006/5/30、U、ネ06:22:321-6OracleDatabase10gOCPI1Z0-042DataControlLanguageDCLDCLDCLGRANTREVOKEpermissionRDBMS1-1CustomersOrdersCustomerIDjoinconditionSQLRDBMSSQLSQLOraclePL/SQLSQLRDBMSOracleObjectRelationalDatabaseManagementSystemORDBMSOracle8OracleRDBMSOracle8OracleOracle10gORDBMS1980ORDBMSch01.indd6200。
4、6/5/30、U、ネ06:22:33Chapter01Oracle1-7OracleOracle810gBLOBOracleOracleORDBMSRDBMSRDBMSOracleOracleORDBMSOracleCustomersSuppliersEmployeesPhoneNumberPhoneNumberPhoneNumber1-2RDBMSOracleOracleOracle10g1-1ch01.indd72006/5/30、U、ネ06:22:331-8OracleDatabase10gOCPI1Z0-042tablecolumnrowinstanceIDcellCustomerID10002CompanyNameBradleySystemsconstraintPRIMARYFOREIGNKEYNOTNULLCHECKviewSQLSQLindexindex-organizedtable6281partitionOracle10gch01.indd82006/5/30、U、ネ06:22:33Chapter01Oracle1-9clusterOrderIDOracleIDseq。
5、uencesynonymOraclestoredprocedureSQLPL/SQLtriggerINSERTUPDATEDELETESTARTUPSHUTDOWNfunctionstoredprogrampackageuser-defineddatatypemethodBLOBBLOBbinarylargeobjectBLOBBLOBCLOBNCLOBBFILE1-1Oracle10gch01.indd92006/5/30、U、ネ06:22:331-10OracleDatabase10gOCPI1Z0-042OracledimensionsdirectoriesmaterializedviewsOracleOracleschemausersschemaOracleOracledatadictionarymetadataOraclebasetableSYSOracleOracleUser_All_ALL_USER_ch01.indd102006/5/30、U、ネ06:22:34Chapter01Oracle1-11DBA_DBA_DBASELECTDBA_Oracle1-3DBADBAD。
6、BAOracleDBAOracleCPUOracleOracleOracleDBACDOracleDBAOraclech01.indd112006/5/30、U、ネ06:22:341-12OracleDatabase10gOCPI1Z0-0423DBADBAOracleDBADBADBAStarTrek:TheNextGenerationCaptainPicardandGiordich01.indd122006/5/30、U、ネ06:22:34Chapter01Oracle1-13DBA1-4OracleOracleOracleOracleOracleOracleOracleOracleE-BusinessSuiteOracleApplicationsE-BusinessSuiteERPE-BusinessSuiteOracleOracleE-BusinessSuiteOracleApplicationServerDeveloperSuiteOracleCollaborationSuiteOracleCollaborationSuitee-mailOracleE-BusinessSui。
7、teCollaborationSuiteOracleApplicationServerOracleApplicationServerJava2EnterpriseEditionJ2EEOracleApplicationServerwebweb-basedOracleApplicationServerportletWebServicesOracleFormsch01.indd132006/5/30、U、ネ06:22:341-14OracleDatabase10gOCPI1Z0-042OracleReportsPL/SQLJavaMcirosoftAcitveDirectoryNovellNDSSuniPlanetsinglesign-onOracleDeveloperSuiteOracleApplicationServerOracleDeveloperSuiteJavaPL/SQLOracleCosultingOracleOracleConsultingOracleUniversityOracleOracleUniversityOracleOraclewww.oracle.comRDBM。
8、SSQLDCLDDLDMLOracle10gOracleOracle1.Javaweb-basedActiveDirectoryOracleA.OracleDatabasech01.indd142006/5/30、U、ネ06:22:34Chapter01Oracle1-15B.OracleApplicationServerC.OracleCollaborationSuiteD.OracleE-BusinessSuiteE.OracleDeveloperSuite2.A.B.C.D.E.3.OracleA.OracleB.C.D.E.4.e-mailLinuxJavaOracleA.OracleDatabaseB.OracleApplicationServerC.OracleCollaborationSuiteD.OracleE-BusinessSuiteE.OracleDeveloperSuite5.OracleA.ch01.indd152006/5/30、U、ネ06:22:351-16OracleDatabase10gOCPI1Z0-042B.C.OracleD.E.1.BOracl。
9、eApplicationServerJava2EnterpriseEditionJ2EEweb-basedOracleInternetDirectory2.BEID3.D4.COracleCollaborationSuitee-mailOracleApplicationServer5.DDBADBAch01.indd162006/5/30、U、ネ06:22:35。
本文标题:Oracle基本概念
链接地址:https://www.777doc.com/doc-11487 .html