Sql Chaining explained

Data System Architecture


All operations on a table return a table.

The operations on tables can therefore be chained together (ie pipelined)

The Relational algebra expressions dictate how to achieve it by giving:

  • what operations to do
  • and in what order to do them.

Discover More
Data System Architecture
(Relation|Table) - Tabular data

This section is based on the relation data structure must well known under the term of table. The system that manages this structure are called Relational databases (or RDMS) . They are founded on Set...
Data System Architecture
What is the SQL With clause (known as CTE) ?

The with sql clause permits to define inline views (ie without creating them). These views are also commonly known as CTE (common table expression) because a query (hence a view) returns a logical table....

Share this page:
Follow us:
Task Runner