Database administration isqa 436
Download
1 / 22

Database Administration ISQA 436 - PowerPoint PPT Presentation


  • 147 Views
  • Uploaded on

Database Administration ISQA 436. Fall 2006 Mark Freeman [email protected] Database Administration ISQA 436. Syllabus Books Attendance Grading WebCT http://psuonline.pdx.edu/ Use your PSU Odin account. DATABASE Applications. Oracle 10G (v10.2) Database server: SBALABS

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Administration ISQA 436' - iliana-burris


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Database administration isqa 436
Database AdministrationISQA 436

Fall 2006

Mark Freeman

[email protected]


Database administration isqa 4361
Database AdministrationISQA 436

  • Syllabus

  • Books

  • Attendance

  • Grading

  • WebCT

    http://psuonline.pdx.edu/

    Use your PSU Odin account


Database applications
DATABASE Applications

  • Oracle 10G (v10.2)

  • Database server: SBALABS

    • Use for SQL and PL/SQL programming assignments

    • You will be assigned a user account

  • Local database server on lab desktops

    • Use for DBA lab assignments

  • SQL Developer

  • Enterprise Manager

  • Net configuration/management


Database
DATABASE

  • Remote connection

    • Oracle 10g client

    • Service

      • SBALABS

    • Host

      • IP Address (See install/config lab for details)


What you should know
What you should know

  • Basic SQL

    • INSERT, UPDATE and DELETE

    • SELECT

      • WHERE

      • ORDER BY

      • GROUP BY/HAVING

    • Joins (2 or 3 tables)

  • Basic DDL

    • CREATE, ALTER, DROP TABLE, etc


What you should know1
What you should know

  • Referential Integrity

    • Primary and Foreign Keys

  • NULL

  • Know about:

    • Views

    • Functions, procedures, triggers

    • Indexes

    • Transactions


What we will learn
WHAT WE WILL LEARN

  • Oracle Database Architecture

  • Administration

    • Basic DBA tasks

    • Backup and recovery

    • Storage management

    • Network management

    • Security management

  • PL/SQL programming

  • Internet database technology*

    *As time allows


Oracle timeline
ORACLE TIMELINE*

IBM employee

E.F. Codd publishes

theory of relational

databases

Oracle is founded

by Larry Ellison,

Bob Miner and Ed Oates

Originally named SDL

First commercial

relational database

is shipped!

1970

1974

1977

1978

1979

1980

Name changed

to RSI

Name changed

to Oracle

IBM develops System R UC Berkeley develops Ingres Neither becomes commercial before Oracle

* Sources: http://math.hws.edu/vaughn/cpsc/343/2003/history.html

http://www.oracle.com/corporate/history.html


Oracle timeline1
ORACLE TIMELINE

Oracle begins

development of

Oracle Financials

software

Version 6.0

PL/SQL

Oracle Financials

released

Version 3.0

on minicomputers

written in C

Version 6.2

Parallel Server

1980

1981

1982

1983

1984

1985

1986

1987

1988

1989

1990

IBM releases DB2

Version 4.0

PC version

Read consistency

Version 5.0

Distributed database

Client/server


Oracle timeline2
ORACLE TIMELINE

Oracle becomes

#1 database

company for

internet and

ERP

Oralce Applications

ERP, Supply Chain,

Manufacturing, etc..

Version 7.0 on Unix

Very Large Databases

(VLDB)

Linux

1990

1991

1992

1993

1994

1995

1996

1997

1998

1999

2000

$1 billion

in sales

Network PC

Version 8.0,

named Oracle8,

Released

64-bit

Oracle 8i

Java

OAS


Oracle timeline3
ORACLE TIMELINE

Oracle 9i

Release 2

Oracle 10g

2000

2001

2002

2003

2004

Oracle 9i Release 1

Internet Application

Server (IAS)


Oracle documentation
Oracle Documentation

  • All Oracle documentation is available online

    • http://www.oracle.com/pls/db102/homepage

  • Useful documents for this class*

    • Oracle Database Concepts

    • Database Administrator’s Guide

    • SQL Reference

    • PL/SQL User Guide an Reference

* There are more than 200 Oracle documentation manuals


Database administrator
DATABASE ADMINISTRATOR

  • What is a DBA?

    • Database Administrator

    • Default Blame Accepter?

  • What does a DBA do?


Database administrator1
DATABASE ADMINISTRATOR

  • DBA tasks:

    • Database Design and Planning

    • Database Installation and Upgrade

    • Backup and Recovery

    • Storage Management

    • Security Management

    • Network Administration

    • Performance Tuning

    • On-call Emergency Crisis Management


Database design and planning
DATABASE DESIGN AND PLANNING

  • Capacity planning

    • Number and speed of CPU

    • Memory

    • Disk space

    • Size and distribution of data files

  • Network

    • Firewall

    • Concurrancy

    • Distributed databases

  • Database parameters

    • Sizing and resource allocation

  • Standby and test databases


Database installation and upgrade
DATABASE INSTALLATION AND UPGRADE

  • What products to install

  • Configuring the operating system

    • memory parameters

    • Oracle account

    • filesystem

  • Installing/configuring database and web servers

  • Installing client software

  • Planning and performing upgrades


Backup and recovery
BACKUP AND RECOVERY

  • Develop backup and recovery plan

  • Implement backup procedures

  • Test recovery plans

  • Schedule exports and other special-needs backups


Storage management
STORAGE MANAGEMENT

  • Ensure enough disk space and data files for growth

  • Monitor growth

  • Schedule database reorganizations


Security management
SECURITY MANAGEMENT

  • Create database user accounts and roles

  • Grant and revoke privileges

  • Maintain operating system security

  • Network security

    • firewall

  • Web server security

  • Encryption


Network administration
NETWORK ADMINISTRATION

  • Server network configuration

  • Client network configuration

  • Distributed database configuration

  • Managing connection capacity


Performance tuning
PERFORMANCE TUNING

  • Monitor performance

    • response time

    • resource contention

      • CPU

      • Memory

      • Disk

      • Network

  • Adjust database parameters accordingly

  • Assist in SQL statement tuning


On call crisis management
ON-CALL CRISIS MANAGEMENT

  • Anticipate emergencies and take preventative measures

  • Respond to pager at 3am

  • Keep a cool head

  • Call Oracle for support

  • Minimize damage

  • Minimize downtime


ad