Oracle基本概念

CHAPTER01SQLOracle10gOracleOraclech01.indd12006/5/30､U､ﾈ06:22:271-2OracleDatabase10gOCPI1Z0-042OracleRelationalDatabaseManagementSystemRDBMS1-110DatabaseManagementSystemDBMSch01.indd22006/5/30､U､ﾈ06:22:29Chapter01Oracle1-350hierarchicalnetworkrelationalOracleRelationalDatabaseManagementSystemRDBMS19706ACMCommunicationsoftheACMAssociationofComputingMachineryjournalIBMDr.E.F.CoddARelationalModelofDataforLargeSharedDataBanksphysicalstorageNoteDr.E.F.CoddARelationalModelofDataforLargeSharedDataBanksACMwww.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.CoddStructuredEnglishQueryLanguageSEQUELStructuredQueryLanguageSQLsequelSQLDataDefinitionLanguageDDLDDLDDLCREATEALTERDROPRENAMETRUNCATECREATETABLEDROPINDEXDataManipulationLanguageDMLDMLDMLINSERTUPDATEDELETECOMMITROLLBACKSAVEPOINTSELECTDMLDMLch01.indd52006/5/30､U､ﾈ06:22:321-6OracleDatabase10gOCPI1Z0-042DataControlLanguageDCLDCLDCLGRANTREVOKEpermissionRDBMS1-1CustomersOrdersCustomerIDjoinconditionSQLRDBMSSQLSQLOraclePL/SQLSQLRDBMSOracleObjectRelationalDatabaseManagementSystemORDBMSOracle8OracleRDBMSOracle8OracleOracle10gORDBMS1980ORDBMSch01.indd62006/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-9clusterOrderIDOracleIDsequencesynonymOraclestoredprocedureSQLPL/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-3DBADBADBAOracleDBAOracleCPUOracleOracleOracleDBACDOracleDBAOraclech01.indd112006/5/30､U､ﾈ06:22:341-12OracleDatabase10gOCPI1Z0-0423DBADBAOracleDBADBADBAStarTrek:TheNextGenerationCaptainPicardandGiordich01.indd122006/5/30､U､ﾈ06:22:34Chapter01Oracle1-13DBA1-4OracleOracleOracleOracleOracleOracleOracleOracleE-BusinessSuiteOracleApplicationsE-BusinessSuiteERPE-BusinessSuiteOracleOracleE-BusinessSuiteOracleApplicationServerDeveloperSuiteOracleCollaborationSuiteOracleCollaborationSuitee-mailOracleE-BusinessSuiteCollaborationSuiteOracleApplicationServerOracleApplicationServerJava2EnterpriseEditionJ2EEOracleApplicationServerwebweb-basedOracleApplicationServerportletWebServicesOracleFormsch01.indd132006/5/30､U､ﾈ06:22:341-14OracleDatabase10gOCPI1Z0-042OracleReportsPL/SQLJavaMcirosoftAcitveDirectoryNovellNDSSuniPlanetsinglesign-onOracleDeveloperSuiteOracleApplicationServerOracleDeveloperSuiteJavaPL/SQLOracleCosultingOracleOracleConsultingOracleUniversityOracleOracleUniversityOracleOraclewww.oracle.comRDBMSSQLDCLDDLDMLOracle10gOracleOracle1.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.BOracleApplicationServerJava2EnterpriseEditionJ2EEweb-basedOracleInternetDirectory2.BEID3.D4.COracleCollaborationSuitee-mailOracleApplicationServer5.DDBADBAch01.indd162006/5/30､U､ﾈ06:22:35