Scribd
Upload
123 views15 pages

Database Systems: University of Gujrat

This document provides an overview of database systems and Oracle. It discusses that Oracle is one of the largest enterprise IT vendors and their flagship product is the Oracle Database. It provides a brief history of Oracle starting in 1977 and describes their various versions from Oracle 2 in 1979 to the current Oracle 12c. It also outlines the Oracle family of products and key features of the Oracle Database including SQL, parallel processing, backup/recovery, diagnostics and grid architecture. Finally, it introduces relational database management systems (RDBMS) and defines their purpose and major vendors.

Uploaded by

Abdul Manan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
123 views15 pages

Database Systems: University of Gujrat

This document provides an overview of database systems and Oracle. It discusses that Oracle is one of the largest enterprise IT vendors and their flagship product is the Oracle Database. It provides a brief history of Oracle starting in 1977 and describes their various versions from Oracle 2 in 1979 to the current Oracle 12c. It also outlines the Oracle family of products and key features of the Oracle Database including SQL, parallel processing, backup/recovery, diagnostics and grid architecture. Finally, it introduces relational database management systems (RDBMS) and defines their purpose and major vendors.

Uploaded by

Abdul Manan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 15

Database Systems

FACULTY OF CS & IT
UNIVERSITY OF GUJRAT
Contents
 Oracle introduction
 Oracle History
 Oracle Usage
 Oracle Versions
 Oracle family
 Oracle features
 RDBMS

2
Project
 All students are required to complete a
course project
 The details will be announced.
 You need to start forming project teams
◦ Talk to your classmates

3
Topic #1:
A Brief Introduction to Oracle:

4
Oracle
 One of the largest vendors in the
enterprise IT market, made a multiuser
relational database management system
(RDBMS) that's formally called Oracle
Database.

5
Oracle History
 Larry Ellison and his two friends and former co-
workers, Bob Miner and Ed Oates, started a
Software Development Laboratories (SDL) in
1977.
 SDL developed the original version of the
Oracle software.

6
Oracle Usage
 An Oracle database is a collection of data
treated as a unit.
 The purpose of a database is to store and
retrieve related information.
 A database server is the key to solving the
problems of information management.

7
Oracle Version
 Oracle release the first version ‘Oracle v2’ in
1979.
 In 1998 Oracle introduce the ‘I’ series, like
Oracle8i Database.
 In 2003 Oracle introduce the ‘g’ series, like
Oracle Database 10g.
 In 2013 Oracle introduce the ‘c’ series, like
Oracle Database 12c.

8
Meaning of i, g & c in Oracle
Database
 The ‘I’ in oracle 8i and 9i stands for INTERNET
 The g in 10g and 11g stands for GRID, because
from 10g onwards oracle supports grid
architecture.
 The c in 12c stands for ClOUD, this is the first
database designed for the cloud.

9
Oracle Family
 Oracle Personal Edition- for single users. Used
to develop systems
 Oracle Standard Edition- (Entry level
Workgroup server)
 Oracle Enterprise edition- (Extended
functionality )

10
Features
 SQL based RDBMS
 Parallel SQL execution
 Online backup and recovery
 Automated Database Management
 Automatic Database Diagnostic Monitor
 Grid architecture
 Active Data Guard
 Database Cloud Service

11
Now:
A Brief Introduction to RDBMS:

12
Database Management System
 Specialized software
 Buy, install, set up for particular application
 Available for PC’s, workstations, mainframes,
supercomputers
 Is expected to:
◦ Allow users to create new databases (schema)
◦ Give users the ability to query/modify the data
◦ Support the storage of very large amounts of data
◦ Control access to data from many users at once

13
Database Management System
(cont’d)
 Major vendors/products:
◦ Oracle
◦ IBM (DB2)
◦ Microsoft (SQL Server, Access)
 Powerful tool for providing efficient, convenient,
and safe multi-user storage of and access to
massive amounts of persistent data

14
Example: Banking System
 Data = information on accounts,
customers, balances, current interest
rates, transaction histories, etc

15

You might also like