difference between interoperation and intraoperation parallelism
#1

i want to know about difference between interoperation and intraoperation parallelism
Reply
#2

Interquery and Intraquery Parallelism in Parallel Database


Inter-query Parallelism
It is a form of parallelism where many different Queries or Transactions are executed in parallel with one another on many processors.
Advantages
It increases Transaction Throughput. That is, number of transactions executed in a given time can be increased.
It scales up the Transaction processing system. Hence, best suited for On-Line Transaction Processing (OLTP) systems.
Supported Parallel Database Architectures
It is easy to implement in Shared Memory Parallel System. Lock tables and Log information are maintained in the same memory. Hence, it is easy to handle those transactions which shares locks with other transactions. Locking and logging can be done efficiently.
In other parallel architectures like Shared Disk and Shared Nothing, the locking and logging must be done through message passing between processors, which is considered as costly operation when compared Shared Memory Parallel architecture. Cache coherency problem would occur.
Example Database systems which support Inter-query Parallelism
Oracle 8 and Oracle Rdb

Intra-Query Parallelism
It is the form of parallelism where Single Query is executed in parallel on many processors.
Advantages
To speed up a single complex long running queries.
Best suited for complex scientific calculations (queries).
Supported Parallel Database Architectures
SharedMemory, Shared Disk and Shared Nothing parallel architectures are supported. We need not worry about locking and logging as because it involves parallelizing single query.


Types
Intra-operation parallelism – the process of speeding up a query through parallelizing the execution of individual operations. The operations which can be parallelized are Sort, Join, Projection, Selection and so on.
Inter-operation parallelism – the process of speeding up a query through parallelizing various operations which are part of the query. For example, a query which involves join of 4 tables can be executed in parallel in two processors in such a way that each processor shall join two relations locally and the result1 and result2 can be joined further to produce the final result.
Example Database systems which support Intra-query Parallelism
Informix, Terradata
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Tagged Pages: interoperation and intraoperation parallelism,
Popular Searches: inter vs intra query parallelism, difeerence inter and intra query parallelism ppt, interoperation parallelism, intraquery parallelism ppt, inter and intra operation parallelism ppt, diffrence between interoperation and intraoperation parallelism in database, difference between intra and inter query parallelism,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  well-spring some homemade barbecue backchat and moistureless rubs and the actuality 0 1,025 10-09-2019, 05:48 PM
Last Post:
  agent some homemade barbecue cheek and prosaic rubs and suit 0 942 10-09-2019, 07:04 AM
Last Post:
  pass some homemade barbecue coolness and arid rubs and module 0 898 09-09-2019, 06:35 PM
Last Post:
  Recruitment and selection procedure in itc limited and hul ltd 1 1,598 13-08-2018, 08:20 AM
Last Post: Alima
  advantages and disadvantages of crank and slider mechanism 0 1,579 05-06-2018, 06:45 PM
Last Post: Guest
  to use newspaper to study and report on sahres and dividends 0 1,059 02-05-2018, 02:29 PM
Last Post: Guest
  anchoring dialogue between two people for farewell party 0 955 01-02-2018, 08:59 PM
Last Post: Guest
  difference between adc0808 and adc0804 1 687 31-01-2018, 03:16 PM
Last Post: dhanabhagya
  minimum distance between borewell and septic tank 1 702 15-12-2017, 01:29 PM
Last Post: jaseela123d
  difference between 120 degree conduction and 180 degree conduction 1 770 09-12-2017, 09:38 AM
Last Post: jaseela123d

Forum Jump: