Introduction : Introduction
Lesson Objectives : Lesson Objectives After completing this lesson, you should be able to do the following:
List the features of Oracle10g
Discuss the theoretical and physical aspects of a relational database
Describe the Oracle implementation of the RDBMS and ORDBMS
Understand the goals of the course
Goals of the Course : Goals of the Course After completing this course, you should be able to do the following:
Identify the major structural components ofOracle Database 10g
Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Run data manipulation language (DML) statements to update data in Oracle Database 10g
Obtain metadata by querying the dictionary views
Oracle10g : Oracle10g
Oracle10g : Oracle10g
Oracle Database 10g : Oracle Database 10g Multimedia Object relational data Messages Documents
Oracle Application Server 10g : Oracle Application Server 10g Application development framework Application server Business intelligence Portals Integration Transactional applications
Oracle Enterprise Manager 10g Grid Control : Oracle Enterprise Manager 10g Grid Control Software provisioning
Application service level monitoring
Relational and Object RelationalDatabase Management Systems : Relational and Object RelationalDatabase Management Systems 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
Oracle Internet Platform : Oracle Internet Platform System management Network services Databases Application
servers Internet applications Anybrowser AnyFTP client Anymail client SQL PL/SQL Java Clients Presentation and
business logic Business logic
and data Development tools
System Development Life Cycle : System Development Life Cycle
System Development Life Cycle : System Development Life Cycle
Data Storage on Different Media : Data Storage on Different Media Electronic spreadsheet Filing cabinet Database
Relational Database Concept : Relational Database Concept Dr. E. F. Codd proposed the relational model for database systems in 1970.
It is the basis for the relational database 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
Definition of a Relational Database : Definition of a Relational Database A relational database is a collection of relations or two-dimensional tables.
Data Models : Data Models
Entity Relationship Model : Create an entity relationship diagram from business specifications or narratives:
Scenario
“. . . Assign one or more employees to a department . . .”
“. . . Some departments do not yet have assigned employees . . .” Entity Relationship Model EMPLOYEE
#* number
* name
o job title DEPARTMENT
#* number
* name
o location assigned to composed of
Slide 18 :
Entity Relationship Modeling Conventions : Entity Relationship Modeling Conventions Entity
Singular, unique name
Uppercase
Soft box
Synonym in parentheses Unique identifier (UID)
Primary marked with “#”
Secondary marked with “(#)” EMPLOYEE
#* number
* name
o job title DEPARTMENT
#* number
* name
o location Attribute
Singular name
Lowercase
Mandatory marked with *
Optional marked with “o” assigned to composed of
Entity Relationship Modeling Conventions : Entity Relationship Modeling Conventions Unique Identifier (UID)
Primary marked with #
Secondary marked with (#) Entity
Singular, unique name
Uppercase
Soft box
Synonym in parentheses Attribute
Singular name
Lowercase
Mandatory marked with *
Optional marked with “o” EMPLOYEE
#* number
* name
o job title DEPARTMENT
#* number
* name
o location assigned to composed of
Relating Multiple Tables : Relating Multiple Tables Each row of data in a table is uniquely identified by a primary key (PK).
You can logically relate data from multiple tables using foreign keys (FK).
Slide 22 :
Relational Database Terminology : Relational Database Terminology
Slide 24 :
Relational Database Properties : Relational Database Properties A relational database:
Can be accessed and modified by executing structured query language (SQL) statements
Contains a collection of tables with no physical pointers
Uses a set of operators
Communicating with an RDBMSUsing SQL : Communicating with an RDBMSUsing SQL SQL statement is entered. Statement is sent to Oracle server. Oracle
server SELECT department_name
FROM departments;
Oracle’s Relational Database Management System : Oracle’s Relational Database Management System User tables Data
dictionary Oracle
server
SQL Statements : SQL Statements SELECT
INSERT
UPDATE
DELETE
MERGE
CREATE
ALTER
DROP
RENAME
TRUNCATE
COMMENT
COMMIT
ROLLBACK
SAVEPOINT
GRANT
REVOKE Data manipulation language (DML) Data definition language (DDL) Transaction control Data control language (DCL)
Tables Used in the Course : Tables Used in the Course EMPLOYEES DEPARTMENTS JOB_GRADES
Summary : Summary Oracle Database 10g is the database for grid computing.
The database is based on the object relational database management system.
Relational databases are composed of relations, managed by relational operations, and governed by data integrity constraints.
With the Oracle server, you can store and manage information by using the SQL language and PL/SQL engine.