
16 Data Sharing in a Nutshell
2.1 Parallel database architecture alternatives
Three general alternatives can be described as parallel database architectures.
We call these alternatives Shared Nothing (SN), Shared Disks (SDi), and Shared
Data (SDa). They are considered parallel because processes that access the
data may execute in parallel. Figure 2-1 illustrates each of these alternatives.
Figure 2-1 Parallel database architectures
Shared Nothing (SN)
These are some characteristics of the Shared Nothing alternative:
The database is partitioned.
No disks are shared among the nodes.
Distributed commit is necessary.
Data re-partitioning is ne ...