The VLDB Journal (1996) A Database Model for Object Dynamics

  • 格式:pdf
  • 大小:425.76 KB
  • 文档页数:27

Person
Unemployed
Employee
Engineer

Principal−Engineer

Member−of−Board
Fred
t1

t2

t3
t4
hires

employed_by

owns
owned_by

is−a
is−ais−a

is−a
PRIVATE
CORPORA−
TION

GOVERN−
MENT
BRANCH

EMPLOYEE
MANAGER
EMPLOYER

COMPANY
OWNER

n
a
m
e
a
d
d
r
e

s
s

s
a
l
a
r
y

EMPLOYEE
EMPLOYER

MANAGER
COMPANY
OWNER

PRIVATECORPORATIONGOVERNMENT
BRANCH

hires
employed_by

owns
owned_by

is−a
is−a
is−ais−a

is−a
{m1,m2,m3
c1}

{pc1,pc2}{pc1,pc2 gb1,gb2}{gb1,gb2}

{e1,e2,e3,
e4,e5,e6,
e7,e8,
e9,e10,
m1,m2,m3
c1}

{(pc1,e1),
(pc1,e5),
(pc1,e7)}

{(pc1,c1),
(pc2,c1)}
{c1}
EMPLOYEE
EMPLOYER

MANAGER
COMPANY
OWNER

PRIVATECORPORATIONGOVERNMENT
BRANCH

hires
employed_by

owns
owned_by

is−a
is−ais−a

is−a
is−aEXECUTIVEDIRECTOREDUCATEDEMPLOYEESHAREHOLDERENGINEERSHAREHOLDERENGINEER ACADEMICis−ais−ais−ais−ais−aAPPLICATION−#2APPLICATION−#1APPLICATION−#n{e1,e3,e5}{e1,e2,e7}{e3,e4}{e1}{e1,e2,e3,e4,e5,e6,e7,e8}{m3}{pc1,pc2 gb1,gb2}{m1,m2,m3 c1}{c1}{pc1,pc2}{gb1,gb2} CLASS DAG WITHOBJECT ROLES{e1,e2,e3,e4,e5,e6,e7,e8,e9,e10,m1,m2,m3c1}is−a

CLASS
DAG
...
......c.........

...
c
...

...
ACADEMIC

PROFESSORSTUDENTASSISTANT
is−ais−ais−a
ACADEMIC
PROFESSORSTUDENTASSISTANT
is−ais−ais−a
TUTOR
is−a
ACADEMIC
PROFESSOR−TUTORSTUDENT−TUTORASSISTANT−TUTOR
PROFESSORSTUDENTASSISTANTTUTOR
is−ais−ais−ais−a

is−a
is−ais−a
is−a
is−a

is−a

{i1, ..., in1}{j1, ... , jn2}{k1, ..., kn3}

k1, ..., kn3}j1, ... , jn2,{i1, ..., in1,
is−ais−a
PRIVATE
CORPORA−
TION

GOVERN−
MENT
BRANCH

EMPLOYER
contracted−to
(a)
PRIVATE
CORPORA−
TION

GOVERN−
MENT
BRANCH

pc1
pc2
pc3

pcn
.
.
.

gb1
gb2

gb5

is−a
pc1
pcn
CONTRACTED−TO
IMPORTANT
GOVERNMENT
BRANCH

(b)
EMPLOYEE
EMPLOYER

hires

is−a
is−a
PRINCIPAL
ENGINEER

ENGINEER
FOR
PRIVATE
CORPORATION_pc1

PRINCIPAL−ENGINEER
FOR
PRIVATE
CORPORATION_pc1

h
i
r
e
s

p
r
i
n
c
i
p
a
l

e
n
g
i
n
e
e
r
is

a

is−a

is−a
EMPLOYEE
is−a
is−a
is−ais−a

CUSTOMER

STEADY
JOB
CUSTOMER

QUALIFIES
FOR
HOME−LOAN

QUALIFIES
FOR
CAR−LOAN

{e1,e2,e3
e4,e5,e6,e7}

{e1,e2,e7}
{e2,e4,e6}

{e1,e2,e3,
e4,e5,e6,
e7,e8,
e9,e10,
m1,m2,m3
c1}

{e1,e2,e3,e4
e5,e6,e7,e8}
EDUCATED
EMPLOYEE

SOCIAL
WORKER
ENGINEER

ACADEMIC

CASUAL
LECTURER

U
is−a

is−a
is−a
is−a

{e1,e2,e3,e4,
e5,e6,e7,e8}

{e1,e2,e7}
{e5}
{e6}

{e3,e4}