2 ms·
This paper is a really good treatment of the space from my perspective. I think the greatest power in the relational model comes from its ability to directly r
by bob1029 2y ago
This paper is a really good treatment of the space from my perspective.
I think the greatest power in the relational model comes from its ability to directly represent cyclical dependencies without forcing weird workarounds. Many real-world domains have ambiguities regarding which types should be strict dependents of another. This confounds approaches relying on serialization. As mentioned in the paper, many major providers offer extensions to SQL which allow you to iterate through the graph implied by these relations with a single logical command.
> The impact of AI/ML on DBMSs will be significant
I agree with this but not in the way the authors may have intended. I think the impact will be mostly negative. The amount of energy being spent on blackbox query generator approaches could be better spent elsewhere. You can get extremely close, but this often doesn't matter.
> Do not ignore the out-of-box experience.
This is why everyone says to start with SQLite now.