Re:The Next 50 Years of Databases (2015)
by jiggawatts on Tuesday November 12, 2019 @03:14AM
(#21512433)
The closest I've seen anyone come to this "dream" scenario is PowerBI. It's very visual and drag & drop, with practically no coding or query language skills required. Yet, it can automatically generate insanely complex queries that even a seasoned developer would struggle to write manually.
[ Parent
| on HN ]
Re:The Next 50 Years of Databases (2015)
by Discombulator on Tuesday November 12, 2019 @05:23AM
(#21513007)
PowerBI is an interesting case. As long as you do “run of the mill” business analytics (Star or snowflake tables, “simple” aggregations) it is like you say.
But once you need something different, you’re in for some serious rethinking and coding.
I have this article printed out in a drawer for these cases: http://mdxdax.blogspot.com/2011/03/logic-behind-magic-of-dax...
With DAX, Microsoft has extended the PivotTable model (instead of the relational model), and they deserve full respect for trying something new in this space.
Is it a simpler model? I kinda like it, but don’t think it is simpler.