OracleOCPSQLIntroduction

《OracleOCPSQLIntroduction》由会员分享，可在线阅读，更多相关《OracleOCPSQLIntroduction（26页珍藏版）》请在装配图网上搜索。

1、Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,#,Click to edit Master title style,First Level,Second Level,Third Level,Fourth Level,Fifth Level,I-,1,Copyright Oracle Corporation,2001.All rights reserved.,Introduction,Objectives,A

2、ftercompleting thislesson,youshould be able,todothefollowing:,List thefeaturesofOracle9i,Discuss thetheoreticalandphysicalaspectsofa relationaldatabase,DescribetheOracle implementation of theRDBMSandORDBMS,Oracle9i,Scalability,Reliability,Singledevelopmentmodel,Commonskill sets,Onemanagementinterfac

3、e,Onevendor,Oracle9i,Oracle9iApplicationServer,BusinessIntelligence,Businessintelligence,Transactional Apps,Transactional Apps,Portals,Portals,A,P,A,C,H,E,Integration,Integration,Oracle9iDatabase,Multimedia,Multimedia,ObjectRelationalData,ObjectRelationalData,Messages,Messages,Documents,XML,Document

4、s,XML,Relational andObjectRelationalDatabaseManagement System,Relational model andobjectrelationalmodel,User-defineddatatypesandobjects,Fullycompatible withrelationaldatabase,Support of multimediaand large objects,High-qualitydatabaseserver features,OracleInternetPlatform,Clients,Systemmanagement,Ne

5、twork services,Databases,Application,servers,Developmenttools,Internetapplications,Presentationand,businesslogic,Businesslogic,anddata,Anybrowser,AnyFTP client,Anymail,client,Java,SQL,PL/SQL,SystemDevelopmentLifeCycle,Strategy,and,analysis,Design,Build,and,document,Transition,Production,SystemDevelo

6、pmentLifeCycle,Strategy,and,analysis,Design,Build,and,document,Transition,Production,Data StorageonDifferent Media,Electronic spreadsheet,Filingcabinet,Database,Relational Database Concept,Dr.E.F.Codd proposed therelational model fordatabasesystems in 1970,.,.,Itisthebasisfor therelational database

7、managementsystem(RDBMS),.,.,Therelationalmodelconsistsofthefollowing:,Collection of objectsorrelations,Setofoperators to actontherelations,Data integrityforaccuracyand consistency,Definition of aRelationalDatabase,A relationaldatabaseisacollection of relationsor,two,-,-dimensionaltables.,Oracle,serv

8、er,TableName:EMPLOYEES,TableName:DEPARTMENTS,Data Models,Modelofsysteminclient,smind,Entitymodelofclient,smodel,Tablemodelofentitymodel,Tablesondisk,Oracle,server,Createanentity relationshipdiagram frombusinessspecificationsornarratives,Scenario,“.,.,.Assign oneormore employeestoadepartment,.,.,.,.”

9、,“.,.,.Somedepartmentsdonotyet haveassignedemployees.,.,.,.,.”,EntityRelationship Model,EMPLOYEE,#*number,*name,ojobtitle,DEPARTMENT,#*number,*name,olocation,assignedto,composedof,EntityRelationshipModelingConventions,Entity,Soft box,Singular,unique name,Uppercase,Synonym in parentheses,Attribute,Si

10、ngularname,Lowercase,Mandatorymarked with,“,“*,”,”,Optionalmarkedwith,“,“o”,UniqueIdentifier,(,(UID),Primary markedwith“,#,#”,Secondarymarked with,“,“(,#,#)”,EMPLOYEE,#*number,*name,ojobtitle,DEPARTMENT,#*number,*name,olocation,assignedto,composedof,EntityRelationshipModelingConventions,Entity,Soft

11、box,Singular,unique name,Uppercase,Synonym in parentheses,Attribute,Singularname,Lowercase,Mandatorymarked with,“,“*,”,”,Optionalmarkedwith,“,“o”,UniqueIdentifier,(,(UID),Primary markedwith“,#,#”,Secondarymarked with,“,“(,#,#)”,EMPLOYEE,#*number,*name,ojobtitle,DEPARTMENT,#*number,*name,olocation,as

12、signedto,composedof,RelatingMultipleTables,Each rowofdata in atableisuniquelyidentifiedbya primarykey(PK),.,.,Youcan logicallyrelatedatafrom multiple tablesusingforeign keys,(,(FK).,TableName:EMPLOYEES,TableName:DEPARTMENTS,Primary key,Primary key,Foreign key,Relational Database Terminology,1,2,3,4,

13、5,6,Relational Database Properties,A relationaldatabase,:,:,Canbeaccessedand modified by executingstructured query language(SQL,),)statements,Containsa collectionoftables withnophysicalpointers,Uses aset of operators,Communicating withaRDBMSUsingSQL,SELECT department_name,FROM departments;,SQL state

14、mentis entered.,Oracle,server,StatementissenttoOracleServer.,Relational Database ManagementSystem,User tables,Data,dictionary,Oracle,server,SQLStatements,SELECT,INSERT,UPDATE,DELETE,MERGE,CREATE,ALTER,DROP,RENAME,TRUNCATE,COMMIT,ROLLBACK,SAVEPOINT,GRANT,REVOKE,Data retrieval,Data manipulationlanguag

15、e,(,(DML),Data definitionlanguage,(,(DDL),Transactioncontrol,Data controllanguage,(,(DCL),TablesUsedintheCourse,EMPLOYEES,DEPARTMENTS,JOB,_,_GRADES,Summary,TheOracle9iServeristhe database forInternetcomputing,.,.,Oracle9iisbasedontheobject relationaldatabasemanagementsystem,.,.,Relational databasesarecomposedofrelations,managed by relationaloperations,and governed by dataintegrity constraints.,With theOracleServer,youcan store andmanageinformationbyusingthe SQLlanguageandPL,/,/SQL engine.,