Relationship to Mathematical Set Theory

Contact Us or call 1-877-932-8228
Relationship to Mathematical Set Theory

Relationship to Mathematical Set Theory

  • MINUS operation is analagous to a difference. Image of Venn Diagram of Difference Operation
  • INTERSECT named the same as the mathematical operation. Image of Venn Diagram of Intersect Operation
  • UNION is also named the same as the mathematical operation. Image of Venn Diagram of Union Operation
  • UNION ALL does not have an analagous operation in elementary set theory where there is no notion of duplicates.
  • Other mathematical operations can be emulated by combining SQL operations. For instance, creating a symetric difference can be accomplished by

    (<query 1> UNION <query 2>)

    MINUS

    (<query 1> INTERSECT <query 2>)

    Image of Venn Diagram of Symetric Difference Operation

The diagrams that follow show the correlation between the Oracle set operator, the mathematical notation and a Venn diagram representing the relationship.

MINUS operation is analagous to a difference: Image of Venn Diagram of Difference Operation

INTERSECT named the same as the mathematical operation: Image of Venn Diagram of Intersect Operation

UNION is also named the same as the mathematical operation: Image of Venn Diagram of Union Operation

UNION ALL does not have an analagous operation in elementary set theory where there is no notion of duplicates.

Other mathematical operations can be emulated by combining SQL operations. For instance, creating a symetric difference can be accomplished by the following combination:

(<query 1> UNION <query 2>)

MINUS

(<query 1> INTERSECT <query 2>) Image of Venn Diagram of Symetric Difference Operation

Next