2 ms·
The relational model includes the relational algebra. The relational algebra means that the order of operations do not change the results. That's a huge advan
by brudgers 5y ago
The relational model includes the relational algebra.
The relational algebra means that the order of operations do not change the results.
That's a huge advantage for query optimization. Relational database systems maintain metadata that allows pruning poor orders of operations.
The other advantage of the algebra's lack of implicit ordering is that arbitrary orderings can be added on top of it, e.g. multi-version concurrency control without changing the underlying algebraic logic.