MHB Relational algebra - What does "in" mean and how is it different than "="?

  • Thread starter Thread starter find_the_fun
  • Start date Start date
  • Tags Tags
    Algebra Mean
Click For Summary
In relational algebra, "in" signifies membership, indicating that an element belongs to a set or relation. The expression σ_{car IN car}R suggests that "car" is being evaluated against a set of values within relation R. The syntax used can vary based on the context, such as the specific software or textbook referenced. Typically, atomic formulas in relational algebra involve comparisons between attributes or constants, and "car IN car" likely represents a comparison where the first "car" is an attribute and the second is a collection of values. Understanding the precise meaning of "in" requires context regarding the specific relational algebra framework being discussed.
find_the_fun
Messages
147
Reaction score
0
In relational algebra what does "in" mean?
For example
[math]\sigma_{car IN car}R[/math] where R is some relation.
 
Mathematics news on Phys.org
Do you mean:

$\displaystyle \sigma\in\mathbb{R}$ ?

If so, the "in" means "is an element of."

edit: I just noticed this is probably not what you are referring to! (Doh)
 
I mean the selection operator as described here.
 
find_the_fun said:
In relational algebra what does "in" mean?
For example
[math]\sigma_{car IN car}R[/math] where R is some relation.
The subscript after σ is a formula. The exact syntax of such formulas depends on the context (software, textbook, etc.). As Wikipedia explains, a typical case is when atomic formulas have the form xRy where x is an attribute name, y is an attribute name or a constant, R is a relation such as <, and atomic formulas are joined by logical connectives. The formula "car IN car" is probably an atomic formula. Maybe the first "car" is an attribute name and the second "car" is an array of values. For a more precise answer one needs the context.
 
Thread 'Erroneously  finding discrepancy in transpose rule'
Obviously, there is something elementary I am missing here. To form the transpose of a matrix, one exchanges rows and columns, so the transpose of a scalar, considered as (or isomorphic to) a one-entry matrix, should stay the same, including if the scalar is a complex number. On the other hand, in the isomorphism between the complex plane and the real plane, a complex number a+bi corresponds to a matrix in the real plane; taking the transpose we get which then corresponds to a-bi...

Similar threads

  • · Replies 4 ·
Replies
4
Views
1K
Replies
4
Views
1K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 5 ·
Replies
5
Views
825
  • · Replies 3 ·
Replies
3
Views
761
  • · Replies 2 ·
Replies
2
Views
1K
Replies
13
Views
3K
  • · Replies 10 ·
Replies
10
Views
2K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 11 ·
Replies
11
Views
1K