Oracle OCP SQL Introduction
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
management system (RDBMS).
• The relational model consists of the following:
– Collection of objects or relations – Set of operators to act on the relations – Data integrity for accuracy and consistency
Development tools
Internet applications
Business logic Presentation and
and data
business logic
Databases
Application servers
Network services
SQL PL/SQL
Java
I-8
mind
I-3
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i
I-4
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i Application Server
Database
Relational Database Concept
• Dr. E.F. Codd proposed the relational model for
database systems in 1970.
• It is the basis for the relational database
Introduction
Copyright © Oracle Corporation, 2001. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following:
I-12
Copyright © Oracle Corporation, 2001. All rights reserved.
Definition of a Relational Database
A relational database is a collection of relations or two-dimensional tables.
I-2
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i
Scalability
One vendor
Reliability
Single development
model
One management
interface
Common skill sets
Oracle server
Table Name: EMPLOYEES Table Name: DEPARTMENTS
…
I-13
…
Copyright © Oracle Corporation, Leabharlann Baidu001. All rights reserved.
Data Models
Model of system in client’s
Portals
A
Transactional Apps
P
A
C
Business Iintelligence
H
E
Integration
I-5
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i Database
Object Relational Data
I-9
Copyright © Oracle Corporation, 2001. All rights reserved.
Data Storage on Different Media
Electronic spreadsheet
Filing cabinet
I-11
Copyright © Oracle Corporation, 2001. All rights reserved.
Copyright © Oracle Corporation, 2001. All rights reserved.
System Development Life Cycle
Strategy and
analysis
Design
Build and document
Transition
Production
Documents
XML
Multimedia
Messages
I-6
Copyright © Oracle Corporation, 2001. All rights reserved.
Relational and Object Relational Database Management System
• Relational model and object relational model • User-defined data types and objects • Fully compatible with relational database • Support of multimedia and large objects • High-quality database server features
• List the features of Oracle9i • Discuss the theoretical and physical aspects of
a relational database
• Describe the Oracle implementation of the
RDBMS and ORDBMS
I-7
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle Internet Platform
Clients Any browser
Any mail client
Any FTP client
System management
• The relational model consists of the following:
– Collection of objects or relations – Set of operators to act on the relations – Data integrity for accuracy and consistency
Development tools
Internet applications
Business logic Presentation and
and data
business logic
Databases
Application servers
Network services
SQL PL/SQL
Java
I-8
mind
I-3
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i
I-4
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i Application Server
Database
Relational Database Concept
• Dr. E.F. Codd proposed the relational model for
database systems in 1970.
• It is the basis for the relational database
Introduction
Copyright © Oracle Corporation, 2001. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following:
I-12
Copyright © Oracle Corporation, 2001. All rights reserved.
Definition of a Relational Database
A relational database is a collection of relations or two-dimensional tables.
I-2
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i
Scalability
One vendor
Reliability
Single development
model
One management
interface
Common skill sets
Oracle server
Table Name: EMPLOYEES Table Name: DEPARTMENTS
…
I-13
…
Copyright © Oracle Corporation, Leabharlann Baidu001. All rights reserved.
Data Models
Model of system in client’s
Portals
A
Transactional Apps
P
A
C
Business Iintelligence
H
E
Integration
I-5
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle9i Database
Object Relational Data
I-9
Copyright © Oracle Corporation, 2001. All rights reserved.
Data Storage on Different Media
Electronic spreadsheet
Filing cabinet
I-11
Copyright © Oracle Corporation, 2001. All rights reserved.
Copyright © Oracle Corporation, 2001. All rights reserved.
System Development Life Cycle
Strategy and
analysis
Design
Build and document
Transition
Production
Documents
XML
Multimedia
Messages
I-6
Copyright © Oracle Corporation, 2001. All rights reserved.
Relational and Object Relational Database Management System
• Relational model and object relational model • User-defined data types and objects • Fully compatible with relational database • Support of multimedia and large objects • High-quality database server features
• List the features of Oracle9i • Discuss the theoretical and physical aspects of
a relational database
• Describe the Oracle implementation of the
RDBMS and ORDBMS
I-7
Copyright © Oracle Corporation, 2001. All rights reserved.
Oracle Internet Platform
Clients Any browser
Any mail client
Any FTP client
System management