资源描述
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,Aftercompleting thislesson,youshould be able,todothefollowing:,List thefeaturesofOracle9i,Discuss thetheoreticalandphysicalaspectsofa relationaldatabase,DescribetheOracle implementation of theRDBMSandORDBMS,Oracle9i,Scalability,Reliability,Singledevelopmentmodel,Commonskill sets,Onemanagementinterface,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,Documents,XML,Relational andObjectRelationalDatabaseManagement System,Relational model andobjectrelationalmodel,User-defineddatatypesandobjects,Fullycompatible withrelationaldatabase,Support of multimediaand large objects,High-qualitydatabaseserver features,OracleInternetPlatform,Clients,Systemmanagement,Network 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,SystemDevelopmentLifeCycle,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 managementsystem(RDBMS),.,.,Therelationalmodelconsistsofthefollowing:,Collection of objectsorrelations,Setofoperators to actontherelations,Data integrityforaccuracyand consistency,Definition of aRelationalDatabase,A relationaldatabaseisacollection of relationsor,two,-,-dimensionaltables.,Oracle,server,TableName:EMPLOYEES,TableName:DEPARTMENTS,Data Models,Modelofsysteminclient,smind,Entitymodelofclient,smodel,Tablemodelofentitymodel,Tablesondisk,Oracle,server,Createanentity relationshipdiagram frombusinessspecificationsornarratives,Scenario,“.,.,.Assign oneormore employeestoadepartment,.,.,.,.”,“.,.,.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,Singularname,Lowercase,Mandatorymarked with,“,“*,”,”,Optionalmarkedwith,“,“o”,UniqueIdentifier,(,(UID),Primary markedwith“,#,#”,Secondarymarked with,“,“(,#,#)”,EMPLOYEE,#*number,*name,ojobtitle,DEPARTMENT,#*number,*name,olocation,assignedto,composedof,EntityRelationshipModelingConventions,Entity,Soft 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,assignedto,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,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 statementis 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 manipulationlanguage,(,(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.,
展开阅读全文