Parallel and Distributed Databse

- In Parallel database the distribuition is governed solely by performance consideration.

- In Distributed databse distribution of data is governed by factors such as local ownership nad increased availability, in
addition to performance issues.

JDBC and ODBC are called GATEWAY PROTOCOL.

Architecture of Parallel DB :
1 - Shared Nothing
2 - Shared Memory
3 - Shared Disk

Architecture of Distributed DB :
1 - client Server
2 - Collaboration Server
3 - Middleware.

Types of Distributed DB :
1 - Homogenous
2 - Heterogenous

Fragmentation types :
1 - Vertical
2 - horizontal