3 ms·
No third party tools etc. are needed for that. A trigger can update a materialized view whenever the source table changes.
by Bishonen88 4y ago
No third party tools etc. are needed for that. A trigger can update a materialized view whenever the source table changes.
- jpalomaki 4y agoThis causes the whole materialized view to update. If the underlying query is complex (which it usually is - otherwise you would not need the view), you often don't want to rerun it for every update. With the separate tools the idea is to stream the incoming updates and keep the materialized views up to date all the time.
- egeozcan 4y agoHow does it know which rows would be affected how when we have something complex? Even better: Is there a detailed proposal or a paper to allow me to gawk at the intelligence of other people? :)
- tazjin 4y agoYes, there is! https://jon.thesquareplanet.com/papers/phd-thesis.pdf https://jon.thesquareplanet.com/papers/phd-thesis.pdf This is the paper on which Readyset and Noria are based.
- dineshgowda24 4y agoI am unable to open the link. Do you mind sharing a working one? Thanks.
- tazjin 4y agoThis is likely because the author blocks access from non-Western countries, you're likely located outside the West (I am as well, and had to use a VPN to access it). I've mirrored the file here, this link should work for you: https://tazj.in/blobs/noria-thesis.pdf https://tazj.in/blobs/noria-thesis.pdf