Join operation, Database Management System

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations must have at least single domain compatible attributes.

Syntax:

R1 R2 is used to join related tuples from two relations R1 and R2 into a single tuple.

is of the form:

ANDAND..............AND.

  • Degree of Relation:

Degree (R1   R2) <= Degree (R1) + Degree (R2).

  • There are three types of joins:

a)   Theta join

When every condition is of the form A θ B, A is an attribute of R1 and B is an attribute of R2 and have the similar domain, and θ is one of the comparison operators { ≤, ≥, ≠, =, <, <}.

Posted Date: 3/6/2013 5:53:13 AM | Location : United States







Related Discussions:- Join operation, Assignment Help, Ask Question on Join operation, Get Answer, Expert's Help, Join operation Discussions

Write discussion on Join operation
Your posts are moderated
Related Questions
Special comparison operator used in where Clause a.   between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem