answersLogoWhite

0

A join is a temporary relationship that you create between tables in database query.

Parallel join: split the pair to be tested over several processors of computer is the part of join and then the result is merged back to have the output.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What do you mean by lossiess join in dbms?

what do u mean by lossiess join in dbms


What is self join in DBMS?

join by itself


What are the advantage and disadvantage of parallel dbms?

The advantages of parallel DBMS include improved performance and scalability, as it allows for parallel processing of queries across multiple servers or processors. This can result in faster query execution and the ability to handle larger data volumes. However, the disadvantages include increased complexity and cost of implementation, as well as the need for specialized hardware and software to support parallel processing. Additionally, parallel DBMS may require additional effort for administration and maintenance.


What is the difference between ddbms and parallel dbms?

A distributed database management system (DDBMS) manages databases that are stored on multiple computers, often in different locations. A parallel database management system (parallel DBMS) uses multiple processors to perform operations on a single database, improving performance by dividing tasks among these processors. In essence, DDBMS focuses on data distribution and replication across different sites, while parallel DBMS focuses on high-speed data processing using multiple processors.


Why global query optimization is difficult in distributed dbms?

1:parallel execution 2: Additional communication cost 3: Transparency and replication


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


What are three types of dbms?

Hierarchical DBMSNetwork DBMSRelational DBMS


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What do correlative conjunction do?

join relate items to help provide parallel structure


What are the importance of dbms in industrial environment?

importance of DBMS