Parallel database - Revision history

2409:4041:6D91:57F2:B498:49FD:675:DF43: /* Types of parallelism */

2022-08-20T05:12:03Z

Types of parallelism

← Previous revision		Revision as of 05:12, 20 August 2022
Line 14:		Line 14:
	;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.		;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.

	==References==		==References==

Materialscientist: Reverted edits by 2409:4041:6D91:57F2:B498:49FD:675:DF43 (talk) (HG) (3.4.10)

2022-08-20T05:11:53Z

Reverted edits by 2409:4041:6D91:57F2:B498:49FD:675:DF43 (talk) (HG) (3.4.10)

← Previous revision		Revision as of 05:11, 20 August 2022
Line 11:		Line 11:

	==Types of parallelism==		==Types of parallelism==
	;Intraquery ~~tirthparallelism~~:A single query that is executed in parallel using multiple processors or disks.<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>		;Intraquery parallelism:A single query that is executed in parallel using multiple processors or disks.<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>
	;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors. ~~tari mano bhoshdo .:~~		;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.


	==References==		==References==

2409:4041:6D91:57F2:B498:49FD:675:DF43: /* Types of parallelism */

2022-08-20T05:11:15Z

Types of parallelism

← Previous revision		Revision as of 05:11, 20 August 2022
Line 11:		Line 11:

	==Types of parallelism==		==Types of parallelism==
	;Intraquery ~~parallelism~~:A single query that is executed in parallel using multiple processors or disks.<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>		;Intraquery tirthparallelism:A single query that is executed in parallel using multiple processors or disks.<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>
	;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.		;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors. tari mano bhoshdo .:


	==References==		==References==

Comp.arch at 19:53, 17 July 2022

2022-07-17T19:53:02Z

← Previous revision		Revision as of 19:53, 17 July 2022
Line 1:		Line 1:
	A '''parallel [[database]]''' system seeks to improve performance through [[parallelization]] of various operations, such as loading data, building indexes and evaluating queries.<ref>{{Cite journal \| last1 = Dewitt \| first1 = David\| author-link1 = David DeWitt\| author-link2 = Jim Gray (computer scientist)\| last2 = Gray \| first2 = Jim\| doi = 10.1145/129888.129894 \| title = Parallel database systems: The future of high performance database systems \|url = http://www.cs.berkeley.edu/~brewer/cs262/5-dewittgray92.pdf\| journal = Communications of the ACM \| volume = 35 \| issue = 6 \| pages = 85 \| year = 1992 \| citeseerx = 10.1.1.119.8427}}</ref> Although data may be stored in a distributed fashion, the distribution is governed solely by performance considerations. Parallel databases improve processing and [[input/output]] speeds by using multiple [[CPU]]s and disks in parallel. Centralized and [[client–server]] database systems are not powerful enough to handle such applications. In parallel processing, many operations are performed simultaneously, as opposed to serial processing, in which the computational steps are performed sequentially. Parallel databases can be roughly divided into two groups, the first group of architecture is the multiprocessor architecture, the alternatives of which are the following:		A '''parallel [[database]]''' system seeks to improve performance through [[parallelization]] of various operations, such as loading data, building indexes and evaluating queries.<ref>{{Cite journal \| last1 = Dewitt \| first1 = David\| author-link1 = David DeWitt\| author-link2 = Jim Gray (computer scientist)\| last2 = Gray \| first2 = Jim\| doi = 10.1145/129888.129894 \| title = Parallel database systems: The future of high performance database systems \|url = http://www.cs.berkeley.edu/~brewer/cs262/5-dewittgray92.pdf\| journal = Communications of the ACM \| volume = 35 \| issue = 6 \| pages = 85 \| year = 1992 \| citeseerx = 10.1.1.119.8427}}</ref> Although data may be stored in a distributed fashion, the distribution is governed solely by performance considerations. Parallel databases improve processing and [[input/output]] speeds by using multiple [[CPU]]s and disks in parallel. Centralized and [[client–server]] database systems are not powerful enough to handle such applications. In parallel processing, many operations are performed simultaneously, as opposed to serial processing, in which the computational steps are performed sequentially. Parallel databases can be roughly divided into two groups, the first group of architecture is the multiprocessor architecture, the alternatives of which are the following:
	;[[Shared memory architecture]]: Where multiple [[Central processing unit\|processors]] share the [[main memory\|main memory (RAM)]] space but each processor has its own disk (HDD). If many processes run simultaneously, the speed is reduced, the same as a computer when many parallel tasks run and the computer slows down.		;[[Shared memory\|Shared-memory architecture]]: Where multiple [[Central processing unit\|processors]] share the [[main memory\|main memory (RAM)]] space but each processor has its own disk (HDD). If many processes run simultaneously, the speed is reduced, the same as a computer when many parallel tasks run and the computer slows down.
	;[[Shared disk architecture]]: Where each node has its own main memory, but all nodes share mass storage, usually a [[storage area network]]. In practice, each node usually also has multiple processors.		;[[Shared-disk architecture]]: Where each node has its own main memory, but all nodes share mass storage, usually a [[storage area network]]. In practice, each node usually also has multiple processors.
	;[[Shared nothing architecture]]: Where each node has its own mass storage as well as main memory.		;[[Shared-nothing architecture]]: Where each node has its own mass storage as well as main memory.

	The other architecture group is called hybrid architecture, which includes:		The other architecture group is called hybrid architecture, which includes:

TCMemoire: Reverted edits by 102.89.2.69 (talk) (HG) (3.4.10)

2022-01-15T14:55:02Z

Reverted edits by 102.89.2.69 (talk) (HG) (3.4.10)

← Previous revision		Revision as of 14:55, 15 January 2022
Line 17:		Line 17:

	==References==		==References==
	{{~~Ronaldo~~}}		{{Reflist}}

	Football legend
	{{DEFAULTSORT:Parallel Database}}		{{DEFAULTSORT:Parallel Database}}
	[[Category:Types of databases]]		[[Category:Types of databases]]

102.89.2.69: Fixed typos

2022-01-15T14:54:51Z

Fixed typos

← Previous revision		Revision as of 14:54, 15 January 2022
Line 17:		Line 17:

	==References==		==References==
	{{~~Reflist~~}}		{{Ronaldo}}
			Football legend

	{{DEFAULTSORT:Parallel Database}}		{{DEFAULTSORT:Parallel Database}}
	[[Category:Types of databases]]		[[Category:Types of databases]]

Mwtoews: use def'n syntax; define Intraquery parallelism

2021-06-13T21:26:47Z

use def'n syntax; define Intraquery parallelism

← Previous revision		Revision as of 21:26, 13 June 2021
Line 11:		Line 11:

	==Types of parallelism==		==Types of parallelism==
	* '''Interquery parallelism~~'''~~<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>		;Intraquery parallelism:A single query that is executed in parallel using multiple processors or disks.<ref>{{cite web \|url=http://www.exploredatabase.com/2014/03/parallel-database-intraquery-parallelism.html \|title=Parallel Database - Intraquery Parallelism - Advanced Database Management System \|last=Kandasamy \|first=Saravanakumar \|publisher=[[Blogger]] \|access-date=September 10, 2017}}</ref>
	* '''Independent parallelism~~''' –~~ Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		;Independent parallelism: Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	* '''Pipe-lined parallelism~~''' –~~ Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		;Pipe-lined parallelism: Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	* '''Intraoperation parallelism~~''' –~~ Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.		;Intraoperation parallelism: Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.

	==References==		==References==

Mwtoews: Reverted edits by 197.155.226.142 (talk) to last version by Monkbot

2021-06-13T21:22:33Z

Reverted edits by 197.155.226.142 (talk) to last version by Monkbot

← Previous revision		Revision as of 21:22, 13 June 2021
Line 14:		Line 14:
	* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, ~~musoro~~ ~~bhangu~~ ~~akaita~~ ~~kunge~~ ~~iwewe~~ ~~anoda~~ ~~zvemahara~~.		* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, ORDER BY clause of a query that tries to execute on millions of records can be parallelized on multiple processors.

	==References==		==References==

197.155.226.142: /* Types of parallelism */

2021-06-11T08:21:28Z

Types of parallelism

← Previous revision		Revision as of 08:21, 11 June 2021
Line 14:		Line 14:
	* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, musoro bhangu akaita kunge iwewe ~~inoda~~ zvemahara.		* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, musoro bhangu akaita kunge iwewe anoda zvemahara.
	<ref></ref>

	==References==		==References==

197.155.226.142: /* Types of parallelism */

2021-06-11T07:21:50Z

Types of parallelism

← Previous revision		Revision as of 07:21, 11 June 2021
Line 14:		Line 14:
	* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.		* '''Independent parallelism''' – Execution of each operation individually in different processors only if they can be executed independent of each other. For example, if we need to join four tables, then two can be joined at one processor and the other two can be joined at another processor. Final join can be done later.
	* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.		* '''Pipe-lined parallelism''' – Execution of different operations in pipe-lined fashion. For example, if we need to join three tables, one processor may join two tables and send the result set records as and when they are produced to the other processor. In the other processor the third table can be joined with the incoming records and the final result can be produced.
	* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, ~~ORDER~~ BY ~~clause~~ of a ~~query~~ ~~that tries to execute on millions of records can be parallelized on multiple processors~~.		* '''Intraoperation parallelism''' – Execution of single complex or large operations in parallel in multiple processors. For example, musoro bhangu akaita kunge iwewe inoda zvemahara.
			<ref></ref>

	==References==		==References==