Have worst case optimal join algorithms made a practical impact, since the linked article's first publication in 2015? I've seen them in the context of egglog, but are they used in real world database management systems?
I always wonder this and maybe people in the comments here know the answer: If humans had the technology to eliminate all viruses on Earth, what would be the outcome? Do viruses keep other bad things in check? Would there be bad consequences if we eliminated all viruses?
The world of viruses is wide and beyond our current understanding. 50 years ago one might have dreamily wondered whether "eliminating all bacteria" would improve the world. Now we know we'd all die quickly without bacteria (e.g. gut biome). I think we're about at that level of understanding today regarding viruses.
I think they'll always need special guidance for things like business logic. They'll never know exactly what it is that you're building and why, what the end goal of the project is without you telling them. Architectural stuff is also a matter of human preference: if you have it mapped out in your head where things should go and how they should be done, it will be better for you when reading the changes, which will be the real bottleneck.
Indeed I have observed that my coworkers "never know exactly what it is that [we]'re building and why, what the end goal of the project is without [me] telling them"
"If technology can be perfected to manage medicine, navigation, education, and even design, what then becomes of work? The specter is not merely unemployment—it’s meaninglessness. Once freed from the burdens of labor, what do we do?"
https://en.wikipedia.org/wiki/Worst-case_optimal_join_algori...