Parallel DistributedSystem: seeks to improve performance through parallelization of various operations, such as data loading, index building and query evaluating.
Distributed Database System: Data is physically stored across several sites, and each site is typically managed by a DBMS capable of running independent of the other sites. The distribution of data is governed by factors such as local ownership and increased availability.
Distributed DBMS consists of many Geo-distributed, low –bandwidth link connected, autonomic site. While parallel DBMS consists of tightly coupled, high- bandwidth link connected, non- autonomic node.
Component Role
Sites in distributed DBMS can work independently to handle local transaction or work together to handle global transactions. While nodes in parallel DBMS can only work together to handle global transactions.
Design Purposes
List and explain two major types of distributed database.
State the two concept of data storage in distributed database.
READING ASSIGNMENT Understanding Data Processing for senior secondary schoolsby Dinehin Victoria pages 272 – 277
WEEKEND ASSIGNMENT A distributed database system is a system that permits ………. data storage across several sites. (a) physical (b) logical (c) vertical (d) horizontal
Network traffic blocking is one of the problems related to the ………. model.. (a) parallel database (b) distributed database (c) client server (d) network
This is a process of splitting a relation into smaller relation or fragments. (a) Replication (b) shared memory (c) fragmentation (d) implementation.
One of the following is architecture of distributed database system. (a) table (b) fragment (c) replication (d) client server.
In distributed Database data is stored at a number of sites, also referred to as………. (a) nodes (b) field (c) hierarchical (d) platform.
