These are questions to be resolved because my vision for Andl depends on them. The questions are: how to build on the work of TTM and TD to better address the ability to do:
- Complex aggregation (including things like
- statistical variance
- running sum
- aggregations across ‘outer joins’.
- Deep ‘self joins’, that is relations that form graphs and trees (and including aggregation on them, such as pricing a bill of materials).
- Deep nesting, that is relations that are not in first normal form, with RVAs (relation valued attributes) that in turn include RVAs to form trees and graphs in a single relation.
- Relational (joinable) functions.
- Relational Updates (not so SQL-like).
- Quantifiable restriction (equivalents for SQL TOP/LIMIT; list parts obtainable from at least 2 suppliers)
I think the ground work has been laid already, and all I need to do is to draw it together.