Physical
database addresses
Slideshow
:
2 types of database addresses
The
physical
block address
The
physical
record
address
❮
❯
2 types of database addresses
There are
2 common techniques
to
identify
a
block/record
stored on
disk
:
Physical
datbase address
Logical
database address
Physical
(Database) Address
: a
direct
addressing format for identify block/record on a
disk
Physical Address
of a
block
:
Physical Address
of a
block
=
physical
address
used to
identify
a
block
on a
disk
Components
of a
physical
block address
:
A
physical
block address
consists of:
Host ID
of the
host (computer)
that contains the
disk
Disk ID
of the
disk
on the
host
Block number
of the
block
on the
disk
Physical Address
of a
record
:
Physical Address
of a
record
=
physical
address
used to identify a
record
on a
disk
Components
of a
record physical address
:
Physical address
of a
block
plus
Offset
of the
record
inside the
block