CS

530

Dat

abas

e A

rchi

tect

ure

Mod

els

and

Des

ign

Pro

f. Ia

n H

OR

RO

CK

SD

r. R

ober

t STE

VE

NS

CS

530:

Dat

abas

es

slid

e 2

22/1

0/20

04

Obj

ecti

ves

Rai

se a

war

enes

s ab

out d

atab

ases

, da

taba

se d

esig

n an

d da

taba

se

man

agem

ent s

yste

ms

Ena

ble

you

to d

esig

n an

d us

e a

data

base

to

sup

port

an a

pplic

atio

nTo

und

erst

and

the

impl

icat

ions

of y

our

desi

gnTo

real

ise

that

des

igni

ng d

atab

ases

is n

on-

trivi

al a

nd re

quire

s im

agin

atio

n, fl

exib

ility

and

thou

ght

slid

e 3

22/1

0/20

04

Labo

rato

ry E

xerc

ise:

Ori

noco

Rec

ords

Use

, des

ign

and

build

a d

atab

ase

to s

uppo

rt a

holid

ay b

ooki

ng s

yste

m

Ora

cle

9i D

BM

SE

xam

ple

clas

ses

and

labs

inte

grat

ed

slid

e 4

22/1

0/20

04

Cou

rse

Mat

eria

lsP

rinte

d M

ater

ial

Lect

ure

Not

es /

Slid

es a

re Im

porta

nt a

nd

shou

ld b

e ce

ntra

l to

your

revi

sion

Ass

ocia

ted

Mat

eria

l is

for b

ackg

roun

d re

adin

g an

d is

impo

rtant

for y

our

unde

rsta

ndin

g of

the

conc

epts

(dis

cuss

ed

in th

e le

ctur

e no

tes)

in d

etai

lS

elf A

sses

smen

t Que

stio

ns g

ive

you

a w

eekl

y ch

eck

on y

our p

rogr

ess

Moc

k E

xam

s

slid

e 5

22/1

0/20

04

Rec

omm

ende

d T

exts

Prim

ary

-Warrender

–D

atab

ases

(Com

putin

g S

tudy

Tex

ts)

Sec

onda

ry -

Con

nolly

and

Beg

g–

Dat

abas

e S

yste

ms

–3r

d E

ditio

n, A

ddis

on W

esle

yO

ld b

ut V

alid

-El

mas

rian

d N

avat

he

–Fu

ndam

enta

ls o

f Dat

abas

e S

yste

ms

–3r

d E

ditio

n, A

ddis

on W

esle

yLa

b –

Ear

p an

d B

agui

–Le

arni

ng S

QL

(A S

tep

by S

tep

Gui

de U

sing

Ora

cle)

slid

e 6

22/1

0/20

04

Oth

er T

exts

Atz

eni,

Cer

i, P

arab

osch

iand

Tor

lone

–D

atab

ase

Sys

tem

s: C

once

pts,

Lan

guag

es a

n A

rchi

tect

ures

–M

acG

raw

Hill

Ullm

anan

d W

idom

–A

Firs

t Cou

rse

in D

atab

ases

Gar

cia-

Mol

ina,

Ullm

anan

d W

idom

–D

atab

ase

Sys

tem

s: T

he C

ompl

ete

Boo

k

slid

e 7

22/1

0/20

04

Intr

oduc

tion

slid

e 8

22/1

0/20

04

File

Man

agem

ent

Sys

tem

s: a

phy

sica

l int

erfa

ce

Tim

etab

le

Stu

dent

Adm

in

Sch

edul

er

Pay

roll

Stu

dent

D

ata

Cou

rse

Dat

a

Lect

urer

D

ata

Yea

r Lis

t

Che

ques

slid

e 9

22/1

0/20

04

File

Man

agem

ent

Sys

tem

s: S

hari

ng

Tim

etab

le

Stu

dent

Adm

in

Sch

edul

er

Pay

roll

Stu

dent

D

ata

Cou

rse

Dat

a

Lect

urer

D

ata

Yea

r Lis

t

Che

ques

slid

e 10

22/1

0/20

04

F M

S: R

eplic

atio

n an

d R

edun

danc

y Tim

etab

le

Stu

dent

Adm

in

Sch

edul

er

Pay

roll

Yea

r Lis

t

Che

ques

Stu

dent

sC

ours

e D

ata

Lect

urer

Dat

a

slid

e 11

22/1

0/20

04

File

Man

agem

ent

Sys

tem

s•

Unc

ontro

lled

redu

ndan

cy•

Inco

nsis

tent

dat

a•

Infle

xibi

lity

•Li

mite

d da

ta s

harin

g•

Poo

r enf

orce

men

t of s

tand

ards

•Lo

w p

rogr

amm

er p

rodu

ctiv

ity•

Exc

essi

ve p

rogr

am m

aint

enan

ce•

Exc

essi

ve d

ata

mai

nten

ance

slid

e 12

22/1

0/20

04

DB

MS

: A L

ogic

al I

nter

face

Uni

vers

ityD

atab

ase

Met

adat

a

stud

ent

cour

se

lect

urer

Dat

abas

eM

gmt

Sys

tem

Lab

Tim

etab

le

Uni

vers

ity D

atab

ase

Dat

a

Dat

a D

ictio

nary

or

Syst

em C

atal

og?Q

UER

IES

Teac

hing

Sch

edul

e

Tuto

rials

slid

e 13

22/1

0/20

04

Wha

t is

a d

atab

ase?

a st

ruct

ured

colle

ctio

n of

info

rmat

ion

capt

ures

the

sem

antic

sof

an

appl

icat

ion

Logi

cally

coh

eren

t—so

it m

akes

sen

se

Inhe

rent

mea

ning

—in

form

atio

n vs

data

Spe

cific

pur

pose

—in

tend

ed u

ser g

roup

Rep

rese

ntat

ion

of th

e re

al w

orld

—ch

ange

s in

the

real

wor

ld re

flect

ed in

the

data

base

slid

e 14

22/1

0/20

04

Dat

abas

e M

anag

emen

t S

yste

ms?

a co

llect

ion

of p

rogr

ams

and

tool

s to

cr

eate

& m

aint

ain

a da

taba

se

Def

inin

gsp

ecify

ing

type

sof

dat

aC

onst

ruct

ing

stor

ing

& p

opul

atin

gM

anip

ulat

ing

quer

ying

, upd

atin

g, re

porti

ng

slid

e 15

22/1

0/20

04

Cha

ract

eris

tics

of

a D

atab

ase

Stru

ctur

e–

data

type

s–

data

beh

avio

urP

ersi

sten

ce–

stor

e d

ata

on

seco

ndar

y st

orag

eR

etrie

val

–a

decl

arat

ive

quer

y la

ngua

ge–

a pr

oced

ural

dat

abas

e pr

ogra

mm

ing

lang

uage

Per

form

ance

–re

triev

e an

d st

ore

data

qui

ckly

Cor

rect

ness

Sha

ring

–co

ncur

renc

yR

elia

bilit

y an

d re

silie

nce

Larg

e vo

lum

es

slid

e 16

22/1

0/20

04

DbM

SA

ppro

ach

Con

trolle

d re

dund

ancy

–co

nsis

tenc

y of

dat

a &

in

tegr

ity c

onst

rain

tsIn

tegr

atio

n of

dat

a–

self-

cont

aine

d &

re

pres

ents

sem

antic

s of

ap

plic

atio

nD

ata

and

oper

atio

n sh

arin

g–

mul

tiple

inte

rface

s

Ser

vice

s &

Con

trols

–se

curit

y &

priv

acy

cont

rols

–

back

up &

reco

very

–en

forc

emen

t of s

tand

ards

Flex

ibili

ty–

data

inde

pend

ence

–da

ta a

cces

sibi

lity

–re

duce

d pr

ogra

m

mai

nten

ance

Eas

e of

app

licat

ion

deve

lopm

ent

slid

e 17

22/1

0/20

04

Con

tinu

edS

umm

ary:

In a

file

man

agem

ent

syst

em it

s da

ta is

P

HY

SIC

ALL

Y a

cces

sed

and

UN

INTE

GR

ATE

D

In a

dat

abas

e m

anag

emen

t sys

tem

dat

a is

LO

GIC

ALL

Y a

cces

sed

and

INTE

GR

ATE

D–

a da

ta d

ictio

nary

–a

quer

y la

ngua

ge

mor

e ex

pens

ive

mor

e co

mpl

exge

nera

l

sim

ple

strin

gent

real

-tim

esi

ngle

use

r st

atic

slid

e 18

22/1

0/20

04

Act

ors

Dat

abas

eA

dmin

istr

ator

D

BA

Dat

abas

eD

atab

ase

Dat

abas

e D

esig

ners

End

Use

rsC

asua

l‘p

aram

etric

’or

‘can

ned’

tran

sact

ions

soph

istic

ated

Dat

abas

e M

anag

emen

t Sys

tem

Dat

abas

e M

anag

emen

t Sys

tem

DB

MS

Des

igne

rs a

nd Im

plem

ente

rs

Tool

Dev

elop

ers

Ope

rato

rs a

nd M

aint

enan

ceP

erso

nnel

slid

e 19

22/1

0/20

04

Sim

plif

ied

Env

iron

men

t (f

rom

Elm

asri

& N

avat

he)

DB

MS

Softw

are

App

licat

ion

Prog

ram

s/Q

uerie

s

Use

rs/P

rogr

amm

ers

Softw

are

to P

roce

ss Q

uerie

s / P

rogr

ams

Softw

are

to A

cces

s St

ored

Dat

a

Dat

abas

e Sy

stem

Stor

ed D

atab

ase

Def

initi

on(M

etad

ata)

Stor

edD

atab

ase

slid

e 20

22/1

0/20

04

Inte

rfac

es t

o a

Dat

a D

icti

onar

y

Dat

abas

e A

dmin

istra

tors

App

licat

ion

Pro

gram

mer

sE

nd U

sers

Dat

a D

ictio

nary

Com

pile

rs /

Pre

com

pile

rsA

pplic

atio

n P

rogr

ams

/ R

epor

t Gen

erat

ors

Inte

grity

C

onst

rain

t E

nfor

cer

Hum

an In

terfa

ces

Sof

twar

e an

d D

BM

S In

terfa

ces

slid

e 21

22/1

0/20

04

Mod

els

and

Sch

emas

Mod

el–

A s

truct

ure

that

dem

onst

rate

s al

l the

requ

ired

feat

ures

of t

he

parts

of t

he re

al w

orld

whi

ch is

of

inte

rest

to th

e us

ers

of th

e in

form

atio

n in

the

mod

el.

–R

epre

sent

atio

n an

d re

flect

ion

of th

e re

al w

orld

(Uni

vers

e of

D

isco

urse

)

Dat

a M

odel

–A

set

of c

once

pts

that

can

be

use

d to

des

crib

e th

e st

ruct

ure

of a

dat

abas

e:

the

data

type

s,

rela

tions

hips

, con

stra

ints

, se

man

tics

and

oper

atio

nal

beha

viou

r.–

It is

a to

ol fo

r dat

a ab

stra

ctio

nA

mod

el is

des

crib

ed b

y th

e sc

hem

aw

hich

is h

eld

in th

e da

ta d

ictio

nary

.

Stud

ent(

stud

no,n

ame,

addr

ess)

Cour

se(c

ours

eno,

lect

urer

)

Stud

ent(

123,

Blog

gs,W

oolt

on)

(321

,Jon

es,O

wens

)Sc

hema

Instan

ce

slid

e 22

22/1

0/20

04

Sha

ring

—M

ulti

ple views

of d

ata

Dat

aBas

eM

anag

emen

t Sys

tem

Dat

abas

e

slid

e 23

22/1

0/20

04

Dat

a In

depe

nden

ce

Dat

abas

e

New

ha

rdw

are

New

func

tions

New

us

ers N

ew s

tora

ge

tech

niqu

esLi

nkag

e to

oth

er

data

base

s

New

dat

a

Use

r's

view

Cha

nge

in

use C

hang

e in

te

chno

logy

Logi

cal d

ata

inde

pend

ence

–ch

ange

the

conc

eptu

al s

chem

a w

ithou

t hav

ing

to c

hang

e th

e ex

tern

al s

chem

asP

hysi

cal d

ata

inde

pend

ence

–ch

ange

the

inte

rnal

sch

ema

with

out h

avin

g to

cha

nge

the

conc

eptu

al s

chem

a

slid

e 24

22/1

0/20

04

Ans

i-Spa

rcD

atab

ase

Arc

hite

ctur

e

Con

cept

ual S

chem

aC

once

ptua

l Lev

el

Inte

rnal

sch

ema

Inte

rnal

Lev

el

Ext

erna

l Lev

elE

xter

nal

View

AE

xter

nal

View

BEx

tern

al

View

N

exte

rnal

/con

cept

ual m

appi

ng

conc

eptu

al/in

tern

al m

appi

ng

End

Use

rs

Sto

red

Dat

abas

e

slid

e 25

22/1

0/20

04

For

Nex

t Le

ctur

eR

e-R

ead

Thes

e N

otes

Pre

p fo

r Lab

1 –

Sys

tem

s Tr

aini

ng

I exp

ect y

ou to

hav

e SK

IM R

ead

the

note

s fo

r the

nex

t lec

ture

bef

ore

it’s

deliv

ered

. The

seq

uenc

e of

: ski

m re

ad; l

ectu

re d

eliv

ery;

SA

Q w

ill m

ake

revi

sion

a

who

le lo

t eas

ier.

slid

e 26

22/1

0/20

04

Add

itio

nal I

nfor

mat

ion

Enc

lose

d–

Syl

labu

s–

Cou

rse

Sch

edul

e–

Cou

rse

Ove

rvie

w

Oth

er–

Cha

pter

1R

.L.W

arre

nder

, D

atab

ases

(Com

putin

g S

tudy

Tex

ts),

ISB

N:

1903

3370

89.

–C

hapt

er 0

Ear

p,B

agui

, Lea

rnin

gS

ql:a

Ste

p-by

-Ste

p G

uide

Usi

ng O

racl

e.

This

is c

opyr

ight

info

rmat

ion.

Th

e co

pyrig

ht b

elon

gs to

the

auth

or.

This

mat

eria

l will

NO

T be

on

the

Web

site

.