Scribd
Upload
3K views1 page

Differences Between Parallel and Distributed DB

Parallel databases store data in a centralized location and use multiple processors to access the data simultaneously for faster retrieval. Distributed databases store data across multiple independent sites so the data is geographically dispersed. Query processing and transactions are more complicated in distributed databases due to the independence of each site and slower interconnection between sites.

Uploaded by

Sanju Munugapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3K views1 page

Differences Between Parallel and Distributed DB

Parallel databases store data in a centralized location and use multiple processors to access the data simultaneously for faster retrieval. Distributed databases store data across multiple independent sites so the data is geographically dispersed. Query processing and transactions are more complicated in distributed databases due to the independence of each site and slower interconnection between sites.

Uploaded by

Sanju Munugapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Distinguish between Parallel and Distributed databases :

Parallel Database Distributed Database

In parallel databases, processes are In distributed databases, the sites are


tightly coupled and constitutes a single loosely coupled and share no physical
database system  i.e., the parallel components i.e., distributed database is our
database is a centralized database and geographically departed, and data are
data reside in a single location distributed at several locations.

 In parallel databases, query processing In distributed databases, query processing


and transaction is complicated. and transaction is more complicated.

In distributed databases, a local and global


In parallel databases, it’s not applicable. transaction can be transformed into
distributed database systems

In distributed databases, each site preserve


In parallel databases, the data is
a local database system for faster
partitioned among various disks so that
processing due to the slow interconnection
it can be retrieved faster.
between sites

In parallel databases, there are 3 types


Distributed databases are generally a kind
of architecture: shared memory, shared
of shared-nothing architecture
disk, and shared shared-nothing.

In distributed databases, query


In parallel databases, query
Optimisation techniques may be different
optimization is more complicated.
at different sites and are easy to maintain

In distributed databases, data is replicated


In parallel databases, data is generally
at any number of sites to improve the
not copied.
performance of systems

Parallel databases are generally Distributed databases may be


homogeneous in nature homogeneous or heterogeneous in nature.

Skew is the major issue with the Blocking due to site failure and
increasing degree of parallelism in transparency are the major issues in
parallel databases. distributed databases. 

Local Reliability Protocols

You might also like