Got it

Architecture types in Parallel DBMS

Latest reply: May 31, 2022 18:56:42 661 17 7 0 0

Parallel database management system (DBMS)

A parallel database management system (DBMS) is a database management system that works on several processors or CPUs and is primarily designed to execute query operations in parallel whenever possible. The parallel DBMS connects several smaller machines to obtain the same throughput as a single large system. Parallelism is utilized to support query speedup, in which extra resources, like processors and drives, are made available. Scale-up is another application of parallelism, in which increasing workloads are managed without increasing response time by raising the degree of parallelism.

 

There are three types of architectures for the parallel database management system (DBMS), Here I am going to describe them,


Shared Nothing Architecture:

Shared nothing architecture is a distributed database management system. It is also called the shared-nothing architecture because the nodes are not connected to each other.

The nodes are generally independent, horizontally partitioned, and synchronized by messages that are passed between them. Nodes can be added or removed from the system at any time without affecting the other nodes in the system. This type of architecture can be used to create large-scale systems that are capable of handling an enormous amount of data with high availability, resilience, and scalability

sn


Shared Everything/Shared Disk Architecture:

The concept of shared ownership of the complete database between RDBMS servers, each of which is executing on a node of a distributed memory system, is implemented using shared-disk architecture. Each RDBMS server can read, write, update, and remove data from the same shared database, necessitating the need for a distributed lock manager in the system (DLM)

The discs are accessible from all cluster nodes in this architecture. This architecture is capable of quickly adapting to changing workloads. It employs a robust optimization strategy.

share

Shared-Memory Architecture:

Shared-memory or shared-everything style is the standard technique of building an RDBMS on SMP hardware. It is quite straightforward to construct and has proven highly effective up to the point when it runs into the shared-everything architecture's scalability limitations. The major benefit of this approach is that a single RDBMS server can most likely use all CPUs, access all memory, and access the whole database, giving the client a consistent single system image.

The DBMS assumes that many database components executing SQL queries interact with each other via shared memory in shared-memory SMP systems. All CPUs have access to all data on the local disc, which is partitioned.

Shared mem

Conclusion:

Different types of architecture suits different application the above explanation simply explains their architecture. Shred Disk Architecture is comparatively more expensive than Shared nothing Architecture but it has Dynamic load balancing. In a shared everything environment, all servers have access to the same shared store, and each workload has access to the store as well as all of the grid's computational resources. The Shared Nothing Architecture is focused on boosting performance, and everything in shared is focused on maximizing resource utilization. So it depends on the requirement to wisely choose the architecture for your Parallel DBMS.


reference:

https://www.javatpoint.com/data-warehouse-types-of-database-parallelism

https://www.geeksforgeeks.org/design-of-parallel-databases-dbms/

https://www.geeksforgeeks.org/difference-between-shared-nothing-architecture-and-shared-disk-architecture/



  • x
  • convention:

Anno7
Moderator Author Created Mar 21, 2022 05:09:42

very clear and complete conclusion
View more
  • x
  • convention:

MahMush
MahMush Created Mar 22, 2022 05:43:08 (0) (0)
thanks for appreciation  
Unicef
MVE Created Mar 21, 2022 06:47:00

WELL DONE
View more
  • x
  • convention:

MahMush
MahMush Created Mar 22, 2022 05:43:28 (0) (0)
thanks for your time to review  
Saqibaz
Created Mar 21, 2022 07:39:55

Well Done, thanks for sharing
View more
  • x
  • convention:

MahMush
MahMush Created Mar 22, 2022 05:43:47 (0) (0)
thanks for your response  
wissal
MVE Created Mar 21, 2022 20:29:09

Important content
View more
  • x
  • convention:

MahMush
MahMush Created Mar 22, 2022 05:44:12 (0) (0)
thanks hope you get informative data from it  
olive.zhao
Admin Created Mar 22, 2022 05:58:53

Architecture types in Parallel DBMS-4803971-1
View more
  • x
  • convention:

zaheernew
MVE Author Created Mar 24, 2022 08:37:39

Useful Info
View more
  • x
  • convention:

MahMush
MahMush Created Mar 25, 2022 05:47:19 (0) (0)
thanks for your time  
Saqib123
Moderator Created Mar 24, 2022 14:00:15

Well Explained
View more
  • x
  • convention:

MahMush
MahMush Created Mar 25, 2022 05:46:43 (0) (0)
thanks for review it  
user_4358465
Created Mar 25, 2022 04:15:26

Excellent. Thank you for the information on the architecture types in Parallel DBMS!
View more
  • x
  • convention:

MahMush
MahMush Created Mar 25, 2022 05:47:03 (0) (0)
haaapppy to know it  
atadmrl251
Moderator Created Mar 28, 2022 20:31:42

clear explanation thank you
View more
  • x
  • convention:

12
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.