Basic HTML version of Foils prepared 7 October 97

Foil 20 Three (Hardware) architectures for parallel DBMS

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou


1 shared-memory (also called Symmetric Multiprocessors SMP)
  • all processors share direct access to a common global memory and to all disks. example: Oracle7 on SGI Challenge
2 shared-disks
  • each processor has a private memory but has direct access to all disk. example: Oracle 7 on IBM SP2
3 shared-nothing
  • each memory and disk is owned by some processor that acts as a server for that data. Mass storage is distributed among processors by connecting one or more disk to each processor. example: DB2 on SP2
  • This is "owner compute" rule as in much scientific computing (HPF default implies processor where variable "stored" performs computations setting variable's value)

in Table To:


© on Mon Oct 13 1997