3 ms·
That’s one implementation of a similar idea in RDBMSs, although they generally require manually refreshing them when desired. I think I’ve heard that some RDBMS
by tshaddox 6y ago
That’s one implementation of a similar idea in RDBMSs, although they generally require manually refreshing them when desired. I think I’ve heard that some RDBMSs also allow you to apply normal inserts and updates to materialized views if you want to manually keep them up to date as well, although I’ve never tried that approach.
- vaughan 6y agoIt’s called incremental view maintenance. Check out: https://wiki.postgresql.org/wiki/Incremental_View_Maintenance https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
- solipsism 6y agoManually refreshing them? How could such a process possibly be manual but not automatable? Does it involve turning a crank?