Database Architecture For Parallel Processing | PDF | Computers
Scribd
Upload
556 views

Database Architecture For Parallel Processing

The document discusses database architecture for parallel processing. It describes three main database management system software architectures: shared everything, shared disk, and shared nothing. The shared everything architecture uses shared memory across all processors to access common data. The shared disk architecture implements shared ownership of the entire database across database servers that share access to disks. The shared nothing architecture partitions data across all disks with each server owning its disk and database partition to parallelize SQL query execution across nodes.

Uploaded by

Jeevanantham Govindaraj
Copyright
© © All Rights Reserved
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
556 views

Database Architecture For Parallel Processing

The document discusses database architecture for parallel processing. It describes three main database management system software architectures: shared everything, shared disk, and shared nothing. The shared everything architecture uses shared memory across all processors to access common data. The shared disk architecture implements shared ownership of the entire database across database servers that share access to disks. The shared nothing architecture partitions data across all disks with each server owning its disk and database partition to parallelize SQL query execution across nodes.

Uploaded by

Jeevanantham Govindaraj
Copyright
© © All Rights Reserved
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 10

Database Architecture for

Parallel Processing
• Parallel Architecture includes Parallel
Hardware on which software
parallelism can be work with parallel
operating system.
• The use of parallel database
software architecture is required to
take advantage of shared memory
and distributed memory parallel
environment
Three main DBMS Software
Architecture are

• Shared Everything Architecture

• Shared Disk Architecture

• Shared Nothing Architecture


Shared Everything Architecture

• Shared-memory or shared-everything style is


the traditional approach of implementing an
RDBMS on SMP hardware.
• The parallel platform in which all the
processors access the common data space is
called as shared memory platform.
Shared Everything Architecture
Shared Disk Architecture

• Shared disk architecture implements a concept of


shared ownership of the entire database
between RDBMS servers.
• RDBMS servers shares the entire database
running on the nodes.
• Each RDBMS server can read, write, update, and
delete information from the same shared
database, which would need the system to
implement a form of a distributed lock manager
(DLM).
Shared Disk Architecture
Shared Nothing Architecture

In a shared-nothing distributed memory


environment, the data is partitioned across all
disks, and the DBMS is "partitioned" across
multiple co-servers, each of which resides on
individual nodes of the parallel system and has
an ownership of its disk and thus its database
partition.
• A shared-nothing RDBMS parallelizes the
execution of a SQL query across multiple
processing nodes.

• Each processor has its memory and disk and


communicates with other processors by
exchanging messages and data over the
interconnection network.
Shared Nothing Architecture

You might also like