Database administration isqa 436
This presentation is the property of its rightful owner.
Sponsored Links
1 / 22

Database Administration ISQA 436 PowerPoint PPT Presentation


  • 104 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Database Administration ISQA 436

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


  • Login