- Trending Categories
- Data Structure
- Operating System
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is shared memory architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance.
Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing.
Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly.
There are several architectural models for parallel machines, which are given below −
- Shared memory architecture.
- Shared disk architecture.
- Shared nothing architecture.
- Hierarchical architecture.
Shared Memory Architecture
Let us discuss about shared memory architecture in detail −
Shared-memory multiple CPU − In this a computer that has several simultaneously active CPU attached to an interconnection network and share a single main memory and a common array of disk storage. This architecture is attractive for achieving moderate parallelism because a limited number of CPU’s can be exploited.
Examples − DBMS on symmetric multiprocessor, sequent, sun.
The architecture of shared memory multiple CPU’s is shown below −
P is the Processor.
M is the Memory.
The advantages of the shared memory architecture are as follows −
Efficient communication: communication overheads are low since data in shared memory can be accessed by any processor without being moved with software.
CPU to CPU communication is very efficient because a CPU can send data to another CPU with the speed of memory write.
Shared memory architectures usually have large memory caches at each processor, so that referencing of the shared memory is avoided whenever possible.
Suitable to achieve moderate parallelism.
The disadvantages of the shared memory architecture are as follows −
The architecture is not scalable beyond 32 or 64 CPU because the processor will spend most of their time waiting for their turn on the bus to access memory.
Existing CPU’s get slowed down, due to bus contention or network bandwidth.
Maintaining cache memory becomes an increasing overhead with an increasing number of processors.
- What is shared disk architecture in parallel databases?
- What is shared nothing architecture in parallel databases?
- What is shared-memory model in computer architecture?
- What is Hierarchical architecture in parallel databases?
- What is shared memory in the OS?
- Difference between Shared Memory Multiprocessors and Message-Passing Multiprocessors in Computer Architecture.
- What is single shared bus in computer architecture?
- What is multiple shared bus in computer architecture?
- What is Time-shared Common Bus in Computer Architecture?
- What is Memory Transfer in Computer Architecture?
- What is Memory Stack in Computer Architecture?
- What is Cache Memory in Computer Architecture?
- What is Distributed memory MIMD Architecture?
- What are Shared Memory MIMD Architectures?
- What is Distributed-Memory Multicomputer in Computer Architecture?