Hacker News Reader

> Are things like "a materialized view (1996!), a continuous query, the result cache" available in any free DBs nowadays?

Getting there... http://www.postgresql.org/docs/9.3/static/rules-materialized...

(The rest of his examples are complicated Oracleisms and you'd probably get pretty far with MVs.)

View on HN

9.3 matviews are a step forward, yet you could probably roll your own matviews with triggers.

The nice thing with materialized views in DB2 for instance (don't know about oracle) is that they are automatically picked by the optimizer to replace a join. So your logical query is - as it should be - completely exasperated from the physical storage underneath. The DBA just puts in a materialized view and the application will speed up magically :)

I think you mean "completely abstracted from the physical storage underneath" :) Although, I'm sure queries exasperate the storage all the time.

Regardless, I had no idea DB2 was so smart. I guess you get what you pay for.

Reply on news.ycombinator.com