4 ms·
> Our approach has clear semantics, i.e. our extended SQL returns subsets of all tables with only those tuples that would be part of the traditional (single-tab
by runeks 3y ago
> Our approach has clear semantics, i.e. our extended SQL returns subsets of all tables with only those tuples that would be part of the traditional (single-table) query result set, however without performing any denormalization through joins.
Hmm, so if I understand this right, the query
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID
would return two tables: (1) an Orders table with only the OrderID and OrderDate columns present; and (2) a Customers table with only the CustomerName column present — without any connection between CustomerName and either Orders.OrderID or Orders.OrderDate?
EDIT: Or, perhaps both Orders.CustomerID and Customers.CustomerID would be present in the respective tables since they're referenced by the JOIN?
- frankfrank13 3y agoI think your edit is correct.