What is the situation of relational algebra?

Click For Summary

Discussion Overview

The discussion revolves around the relationship between relational algebra and topology, specifically examining whether relational algebra can be considered a specification of topology or if it employs topological operators. Participants explore both theoretical and practical aspects of relational algebra, particularly in the context of database design.

Discussion Character

  • Debate/contested
  • Conceptual clarification

Main Points Raised

  • Some participants propose that topology is the merging domain of analysis and algebra, suggesting a connection between these fields.
  • Others argue that relational algebra is primarily related to database design and consists of discrete operations, which may not align with the continuous nature of topology.
  • A participant challenges the initial assumptions, suggesting that topology should be viewed more as a merger of real analysis and geometry rather than algebra.
  • There is a suggestion that relational algebra and topology serve fundamentally different purposes, with relational algebra being discrete and finite in practice.
  • One participant expresses interest in counterarguments to their position on the relationship between relational algebra and topology.

Areas of Agreement / Disagreement

Participants do not appear to reach a consensus, as there are competing views on the relationship between relational algebra and topology, with some supporting the initial assumptions and others challenging them.

Contextual Notes

Participants express differing interpretations of the foundational aspects of topology and relational algebra, highlighting potential limitations in definitions and assumptions regarding their relationship.

OppenheimerBohr
Messages
2
Reaction score
1
Hi!
I would like to know if my assumptions are right:
  • Topology is the merging domain of analysis and algebra;
  • Relational algebra use topological operators;
  • Relational algebra is a specification of topology
?
 
Mathematics news on Phys.org
Thanks Jedishrfu,

I am specialist in databases conception, so I know what you write. My question is about the theoretical aspect.
 
OppenheimerBohr said:
Hi!
I would like to know if my assumptions are right:
  • Topology is the merging domain of analysis and algebra;
  • Relational algebra use topological operators;
  • Relational algebra is a specification of topology
?

I would argue that your assumptions are not correct, based on a simple argument. I think it might be better to understand topology as a merger of real analysis and GEOMETRY, not algebra (analysis is an extension of the infinite to algebraic methods). For instance, think of the homeomorphisms or the Klein bottle. Secondly, relational algebra is a mathematical foundation of database query design which contains only 5 discrete-mathematical operations and is itself discrete and finite in practice; while both may stand on a set-theoretic foundation, the aims of the two are fundamentally different. I might make the simile that relational algebra to topology is a lot like the division between algebra and calculus. But I'd be interested in a counter argument.
 

Similar threads

  • · Replies 25 ·
Replies
25
Views
4K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 157 ·
6
Replies
157
Views
19K
  • · Replies 22 ·
Replies
22
Views
3K
  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K