Got it

Parallelism in Database and its Types

Latest reply: Mar 25, 2022 10:28:24 539 23 11 0 0

Parallelism in Database :

Instead of a single backend, many backend machines are connected to a single host or numerous hosts in a parallel database machine environment. The database is stored on many disc units, which are controlled by the backends. Using a programmable switch to direct data request traffic, any of the hosts can communicate with any of the backends. Because the relevant data may be located on various discs, a query is broken into subqueries, which are then processed using the appropriate partition of the database's database.

ing

Vertical Parallelism:

Vertical parallelism refers to a system's ability to use many devices at the same time. For example, in a program, one thread may perform heavy work, while another handles DB queries, and a third performs IO. This ability is exposed by default in most operating systems.

Horizontal parallelism

When a single device is used or an action is performed on numerous similar pieces of data, horizontal parallelism arises. This is the type of parallelism that occurs when numerous threads are operating on the same piece of code, but with a difference. Horizontal parallelism is the ability to run multiple instances of an operator on the specified portion of the data

Intraquery Parallelism

Intraquery parallelism refers to the simultaneous execution of numerous queries on multiple processors and storage. This parallelism program breaks down a serial SQL query into lower-level tasks like scan, join, sort, and aggregate. Using intraquery parallelism to speed up long-running queries is critical.

Interquery parallelism

Different queries or transactions run in parallel with one another in interquery parallelism. Individual transaction response times are not faster than they would be if the transactions were done separately. This type of parallelism helps speed up transaction processing.

Interquery parallelism has been successfully implemented on SMP systems, increasing throughput and allowing more concurrent users to be supported. This is because several requests are handled by distinct server threads (or processes) at the same time.

Intra-operation parallelism

Intra-operation parallelism is a type of parallelism in which each individual operation of a task, such as sorting, joins, and projections is parallelized. In intra-operation parallelism, the level of parallelism is extremely high.

SELECT * FROM  Cars ORDER BY Ser_Number;

The relational action in the given query is sorting, and because a relation can contain a high number of records, the operation can be executed on distinct subsets of the relation in several processors, reducing the time it takes to sort the data.

inter


Inter-operation parallelism 

Inter-operation parallelism occurs when distinct operations in a query phrase are conducted in parallel. There are two kinds of them.

Pipelined parallelism 

The principle behind pipelined parallelism is to consume the output of one action by the next process in the pipeline. In this type of Parallelism, a lot of operations can be done in parallel by getting some of the output from one query operation and performing the task.

pipe


Independent parallelism:

Operations that aren't interdependent can be carried out in parallel on different processors




  • x
  • convention:

Anno7
Moderator Author Created Mar 10, 2022 12:35:50

amazing write up
View more
  • x
  • convention:

MahMush
MahMush Created Mar 10, 2022 12:39:59 (0) (0)
thanks  
wissal
MVE Created Mar 10, 2022 13:34:26

Important content
View more
  • x
  • convention:

MahMush
MahMush Created Mar 11, 2022 04:55:29 (0) (0)
thankyou for acknowledge  
Saqibaz
Created Mar 10, 2022 13:42:34

Well defined Parallelism in Database and its Types-4769195-1
View more
  • x
  • convention:

MahMush
MahMush Created Mar 14, 2022 05:39:17 (0) (0)
thanks for your response  
taha_29four
Created Mar 10, 2022 14:01:59

Nice work. Parallelism in Database and its Types-4769243-1 SQL.. SELECT... ORDER BY ... my good old days Parallelism in Database and its Types-4769243-2Parallelism in Database and its Types-4769243-3Parallelism in Database and its Types-4769243-4
View more
  • x
  • convention:

MahMush
MahMush Created Mar 11, 2022 04:55:42 (0) (0)
thankyou...  
zaheernew
MVE Author Created Mar 10, 2022 14:27:50

Useful Info
View more
  • x
  • convention:

MahMush
MahMush Created Mar 11, 2022 04:56:08 (0) (0)
it very refreshing that someone get useful it  
zaheernew
zaheernew Reply MahMush  Created Mar 11, 2022 08:19:57 (0) (0)
 
Unicef
MVE Created Mar 11, 2022 10:04:21

Thanks for sharing friend
View more
  • x
  • convention:

MahMush
MahMush Created Mar 12, 2022 07:36:05 (0) (0)
thankyou for response  
BAZ
MVE Author Created Mar 12, 2022 10:01:49

Key topic 9f database
View more
  • x
  • convention:

MahMush
MahMush Created Mar 14, 2022 05:39:32 (0) (0)
glad to hear it  
Funstuff
Moderator Author Created Mar 14, 2022 12:15:01

great share
View more
  • x
  • convention:

SamB
Moderator Created Mar 14, 2022 12:21:42

Thanks for sharing
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.