What is Shared Nothing Architecture in parallel databases

Shared Nothing Architecture is a distributed computing architecture in parallel databases where each node is independent and self-sufficient. There is no sharing of memory or disk storage, hence the name "Shared Nothing".

Here are the steps to understand this concept:

1. Understanding Distributed Computing: Distributed computing is a model in which components of a software system are shared among multiple computers. This is done to improve efficiency and performance.

2. Understanding Nodes: In this context, a node refers to a computer that runs part of the overall software system. Each node operates independently of the others.

3. No Shared Resources: In Shared Nothing Architecture, each node has its own memory and disk storage. This means that there is no central storage system that all nodes access. Instead, each node is responsible for processing its own data.

4. Communication: Nodes communicate with each other through a network. If one node needs data from another, it will request it through the network. The node with the data will then send it over the network to the requesting node.

5. Benefits: This architecture is highly scalable because you can add more nodes to increase processing power. It also avoids the risk of a single point of failure. If one node fails, it does not affect the operation of the others.

6. Drawbacks: The main drawback is the complexity of managing and coordinating multiple nodes. Also, data distribution and balancing load among nodes can be challenging.

In summary, Shared Nothing Architecture in parallel databases is a distributed computing model where each node is independent and self-sufficient, with no shared memory or disk storage.