vdocuments.mx oracle-dba-11g-scroll-slides-for-a-brief-introduction

Introduction to Oracle
Database
www.kerneltraining.com/oracle-dba
3-tier Architecture
DATABASE
Network
End-User
Network
Application Server
Application Softwares
Application Logic
Websites
DATA
www.kerneltraining.com/oracle-dba
DATA
Every organization has some information needs.
• A library keeps a list of members, books, due dates, and fines.
• A company needs to save information about its employees,
departments, and salaries.
These pieces of information are called data.
www.kerneltraining.com/oracle-dba
www.kerneltraining.com/oracle-dba
Database
• A database is an organized collection of data for one
or more purposes, usually in digital form.
www.kerneltraining.com/oracle-dba
Oracle Database
DB2
ORACLE
50% of Market Share
INFORMIX
SYBASE
SQL SERVER
www.kerneltraining.com/oracle-dba
Relational Database
• A relational database management system (RDBMS) is a
database management system (DBMS) that is based on the
relational model as introduced by E.F. Codd.
www.kerneltraining.com/oracle-dba
www.kerneltraining.com/oracle-dba
Relational Database
DATABASE
SQL
End-User
• Retrieve Data
• Insert Data
• Modify Data
• Remove Data
DATA
Tables
www.kerneltraining.com/oracle-dba
www.kerneltraining.com/oracle-dba
www.kerneltraining.com/oracle-dba
History of Oracle Database
ORACLE
www.kerneltraining.com/oracle-dba
History Oracle Database
• In 1977, Larry Ellison, Bob Miner and Ed Oates founded
Software Development Laboratories
• After reading a paper by Codd in IBM Journal of Research &
Development, they created Oracle. (written in Assembly languag
• Version 2.0 of Oracle was released in 1979 & The company
changed its name to Relational Software Inc. (RSI)
• In 1982, RSI was renamed to Oracle Corporation.
• In 1983, Oracle released version 3.0,
which was rewritten in C.
• In 1984, Oracle 4.0 & In 1985 version Oracle 5.0 released.
www.kerneltraining.com/oracle-dba
• In 1986, Oracle goes public on the NASDAQ exchange.
• In 1988, Oracle version 6.0 was released.
(It provided row-level locking, hot backup and
PL/SQL)
• In 1992, Oracle 7.0 released. It provided better performance,
administrative utilities, application development tools, secu
stored procedures, triggers and declarative integrity.
• In 1997, Oracle released Oracle 8.0. It started embracing Java.
Partitioning, support for images, large text, external data etc.(
*Started support for Object in database (Object-Relational DB
• By 1999, Oracle released Oracle 8i. Supported for XML, Java V
Machine (JVM) to run Java program in Database and also sc
which was required for internet databases.
www.kerneltraining.com/oracle-dba
History Oracle Database
• In 2001, Oracle9i was released. Allows Oracle to run on RAC.
• In 2003, Oracle10g was released, where g stands for Grid comp
• In 2007, Oracle has released Oracle11g.
Employing nearly 1,08,000 people worldwide as of 31 May 2011.
www.kerneltraining.com/oracle-dba
Responsibilities of Administrator
Enforcing Data
INTEGRITY
ASSIST
PROGRAMMERS
Maintaining
SECURITY
RECOVERING
DATA
DATABASE
Providing
AVAILABILITY
PERFORMANCE
www.kerneltraining.com/oracle-dba
Questions?
www.kerneltraining.com/oracle-dba
THANK YOU
for attending Demo ofOracle DBA